If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Adding a Combo Box
Please bear with me because I'm very inexperienced with Microsoft
Access. I have a simple existing database that consists of a form and a table of half a dozen fields. There are a few thousand records in the database. I would like to add a new field to the table, and then create a combo box in the form to use to enter information into the new field. Can someone give me a quick overview of the process to add a new field to a table with a combo box in the form to control the field? I'm not looking for anything too detailed, just some general information to get me going in the right direction. I don't think it will matter, but in case it does, the table is linked. (I.e, basically the form is in one database, and the table in another...and the table is linked to the form.) I'm using Access 2003. Thank you! Randy Seys Mankato, MN |
#2
|
|||
|
|||
Adding a Combo Box
You will need to go into the table in the other database and go to design
view. After the list of fields, add your field and set the datatype you desire (text, date, etc.) Now go back to the other database and click on file/get external data/ link tables and re-link it. After relinking it will pick up the new field. Now add your combo to your form and allow the wizard to select that filed for you. Or you could go to design view of the form, click on field list, and insert the field. "Randy" wrote: Please bear with me because I'm very inexperienced with Microsoft Access. I have a simple existing database that consists of a form and a table of half a dozen fields. There are a few thousand records in the database. I would like to add a new field to the table, and then create a combo box in the form to use to enter information into the new field. Can someone give me a quick overview of the process to add a new field to a table with a combo box in the form to control the field? I'm not looking for anything too detailed, just some general information to get me going in the right direction. I don't think it will matter, but in case it does, the table is linked. (I.e, basically the form is in one database, and the table in another...and the table is linked to the form.) I'm using Access 2003. Thank you! Randy Seys Mankato, MN |
#3
|
|||
|
|||
Adding a Combo Box
Correct with one exception.
The OP does not need to use file, get external data, rather go to the linked table manager (Tools, Database Utilities, Linked Table Manager), select the modified table, and relink. -- Dave Hargis, Microsoft Access MVP "Golfinray" wrote: You will need to go into the table in the other database and go to design view. After the list of fields, add your field and set the datatype you desire (text, date, etc.) Now go back to the other database and click on file/get external data/ link tables and re-link it. After relinking it will pick up the new field. Now add your combo to your form and allow the wizard to select that filed for you. Or you could go to design view of the form, click on field list, and insert the field. "Randy" wrote: Please bear with me because I'm very inexperienced with Microsoft Access. I have a simple existing database that consists of a form and a table of half a dozen fields. There are a few thousand records in the database. I would like to add a new field to the table, and then create a combo box in the form to use to enter information into the new field. Can someone give me a quick overview of the process to add a new field to a table with a combo box in the form to control the field? I'm not looking for anything too detailed, just some general information to get me going in the right direction. I don't think it will matter, but in case it does, the table is linked. (I.e, basically the form is in one database, and the table in another...and the table is linked to the form.) I'm using Access 2003. Thank you! Randy Seys Mankato, MN |
Thread Tools | |
Display Modes | |
|
|