473,326 Members | 2,013 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

New field added in Table to appear in Form

How is that done? Thanks.

Neil
Cat Paintings At Carol Wilson Gallery
http://www.carolwilsongallery.com
Nov 13 '05 #1
8 1653
Not automatically. But if you open the form in design view, all should
be(come) clear.
Nov 13 '05 #2
>New field added in Table to appear in Form
How is that done?


For that matter, into all other views, such as into an already created report.
Thanks.

Neil
Cat Paintings At Carol Wilson Gallery
http://www.carolwilsongallery.com
Nov 13 '05 #3
>Not automatically. But if you open the form in design view, all should
be(come) clear.


After another hour or so of wasted time, I finally found the icon Field List,
and then it took me 5 minutes to realize I have to click and drag the new field
into the design. I think Microsoft should fire whoever is in charge of their
Help menus -- this instruction is no where to be found. I'm lucky you have
taken the time to answer my questions. Much thanks again.

Neil
Cat Paintings At Carol Wilson Gallery
http://www.carolwilsongallery.com
Nov 13 '05 #4
>Not automatically. But if you open the form in design view, all should
be(come) clear.


For Form, the field list is only an icon.
For Report, the field list is only under Insert.
And nothing about it in Help. Is this another prime example of American
workmanship? Come on, Microsoft!

Neil
Cat Paintings At Carol Wilson Gallery
http://www.carolwilsongallery.com
Nov 13 '05 #5
Nhmiller wrote:
Not automatically. But if you open the form in design view, all should
be(come) clear.


After another hour or so of wasted time, I finally found the icon Field List,
and then it took me 5 minutes to realize I have to click and drag the new field
into the design. I think Microsoft should fire whoever is in charge of their
Help menus -- this instruction is no where to be found. I'm lucky you have
taken the time to answer my questions. Much thanks again.


Should I have said "copy one control, paste it onto the same form, and
change the ControlSource property to the new field"?

To deal with fields not appearing automatically on a form, I went to
great length writing a wizard-like form maintainer. There is an
in-database solution for many of these problems as well:

I realized that a table definition basically is a set of records itself.
In most SQL databases there are system tables that show this
clearly--unfortunately Microsoft decided to include many features to the
design, which calls for a company standard. Not the Codasyl-standard
however. Rant, rant: the system tables in Access cannot be so easily
used. So, I created my own data dictionary tables:

Tables (containing the name of every table)
Columns (containing the name of every field for every table)

and I added Forms (for every form: its recordsource, and if that is a
query, the table it sits upon in the end) and FormControls (every
control in the form)

From these tables, I can create all forms anew, any time I like (which
is especially after I change the table structure). During design phase
this often saved me hours.

On my site (http://www.heuveltop.nl/BasCB) you can find the Case project
under samples. It contains the basic setup (honestly, I need to review
it, because it was put on the site in 1999 or so, and since then my
insight and knowledge has changed) and maybe it tells you something more.
Nov 13 '05 #6
Nhmiller wrote:
For Form, the field list is only an icon.
For Report, the field list is only under Insert.
And nothing about it in Help. Is this another prime example of American
workmanship? Come on, Microsoft!


Does the Help tell you more on the subject 'controls'?

Have you got the Northwind sample database? It contains many basic
instructional objects. It may feel like a waste of time crawling through
a sample database, but you have to waste time anyway to get to using a
new product. Access can do extremely many different things (right now
I'm working on an air traffic controller simulator, and I have an
application for my folk band too, all Access) and that means you have to
learn.

Remember how it was to learn to drive? Assuming you have your license.
And the difference between theory and practice in traffic behavior?
Nov 13 '05 #7
>and that means you have to
learn.


I agree 100% and I have had to explain that to many other computer users who
are capable of doing their own work, but can't seem to push through like I do.
You may have the wrong impression about me. I'm way above average on computer
literacy. Built our company's website and get very deep into the applications I
use, writing my own macros, etc. And no matter what, there's always a lot of
old-fashioning deducing. But, it's all a lot easier if the software includes a
complicated situation tutorial, and well-written Help. For Access to have
nothing on the topics I have had to post here is absurd. Good thing we have
newsgroups. Thanks much for your help. I hope I can make a go of it from here.
I have ordered 4 recent books from the library -- 2 on Access and 2 on Office
XP.

Neil
Cat Paintings At Carol Wilson Gallery
http://www.carolwilsongallery.com
Nov 13 '05 #8
Nhmiller wrote:
You may have the wrong impression about me. I'm way above average on computer
literacy.
You see that literacy in one field does not guarantee for other fields :-)
Built our company's website and get very deep into the applications I
use, writing my own macros, etc. And no matter what, there's always a lot of
old-fashioning deducing.
Good practice.
But, it's all a lot easier if the software includes a
complicated situation tutorial, and well-written Help. For Access to have
nothing on the topics I have had to post here is absurd.
Which version? And can you use the sample Northwind in any way?
Good thing we have newsgroups.


You will keep asking? Good.
Nov 13 '05 #9

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
by: Marco Simone | last post by:
Hi, What is your opinion about using Lookup field in table. I would like to use lookup field in table 1, so that I can choose data in combo box from table 2. Is this good design of database? ...
3
by: Earthling | last post by:
Any help would be appreciated to solve the following simple problem that I will describe. *** There is a form called "red chocolate form". The form has a particular subform field that has a...
25
by: Lyn | last post by:
Hi, I am working on a genealogy form. The only table (so far) lists everybody in the family, one record per person. Each record has an autonum ID. The parent form (frmMainForm) displays the...
2
by: TroutFisherMan | last post by:
MS Access 2003 on Windows XP Sequence of steps taken to date: 1. Created 7 tables 2. Established relationships with all tables using a single primary key; the same value in each table...
4
by: - | last post by:
I had added a new field to a form, and try insert the data to the new created table field. But when i try to assign the a control source for that form field, in the control source drop down list it...
39
by: windandwaves | last post by:
Hi Folk I have to store up to eight boolean bits of information about an item in my database. e.g. with restaurant drive-through facility yellow windows
4
by: whamo | last post by:
I have the need to populate a field based on the selection in a combo box. Starting out simple. (2) tables tbl_OSE_Info and tbl_Input; tbl_OSE_Info has three fields: Key, OSE_Name and OSE_Wt...
2
by: cephal0n | last post by:
I have this peroblem thats really bugging me for days, please have a patience to read it and help me find the probplem because I knew I missed it and just cant tell where. I have a table named...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.