|
| 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
June 14th, 2007, 08:01 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
automatically updating a table
I have a form used to create an inventory of items. Associated with
the form is a table of items that have been previously entered. When I enter an item that is on the list it automatically fills 2 form fields; one with the item name and one with some additional info. In order to type in an item name that is not in the table I must go to the table and enter then return to the form. I would like to be able to fill in the info to the form and have the table automatically updated with the new item info. Is this possible? 
|
|
#2
June 14th, 2007, 08:50 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
automatically updating a table
If you use a combobox you can set the Limit To List to No.
-- KARL DEWEY Build a little - Test a little " wrote: I have a form used to create an inventory of items. Associated with the form is a table of items that have been previously entered. When I enter an item that is on the list it automatically fills 2 form fields; one with the item name and one with some additional info. In order to type in an item name that is not in the table I must go to the table and enter then return to the form. I would like to be able to fill in the info to the form and have the table automatically updated with the new item info. Is this possible?
|
|
#3
June 14th, 2007, 09:16 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
automatically updating a table
On Jun 14, 2:50 pm, KARL DEWEY
wrote: If you use a combobox you can set the Limit To List to No. -- KARL DEWEY Build a little - Test a little " wrote: I have a form used to create an inventory of items. Associated with the form is a table of items that have been previously entered. When I enter an item that is on the list it automatically fills 2 form fields; one with the item name and one with some additional info. In order to type in an item name that is not in the table I must go to the table and enter then return to the form. I would like to be able to fill in the info to the form and have the table automatically updated with the new item info. Is this possible? But then how do I have what I type into the form automatically update the table?
|
|
#4
June 15th, 2007, 12:09 AM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
automatically updating a table
In the property Not on List create a macro or event to add a record to your
table from the form field. -- KARL DEWEY Build a little - Test a little " wrote: On Jun 14, 2:50 pm, KARL DEWEY wrote: If you use a combobox you can set the Limit To List to No. -- KARL DEWEY Build a little - Test a little " wrote: I have a form used to create an inventory of items. Associated with the form is a table of items that have been previously entered. When I enter an item that is on the list it automatically fills 2 form fields; one with the item name and one with some additional info. In order to type in an item name that is not in the table I must go to the table and enter then return to the form. I would like to be able to fill in the info to the form and have the table automatically updated with the new item info. Is this possible? But then how do I have what I type into the form automatically update the table?
|
|
#5
June 15th, 2007, 09:11 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
automatically updating a table
Here's a link to an example - not in list demo - that should help you
http://www.candace-tripp.com/pages/a...downloads.aspx wrote in message oups.com... I have a form used to create an inventory of items. Associated with the form is a table of items that have been previously entered. When I enter an item that is on the list it automatically fills 2 form fields; one with the item name and one with some additional info. In order to type in an item name that is not in the table I must go to the table and enter then return to the form. I would like to be able to fill in the info to the form and have the table automatically updated with the new item info. Is this possible?
|
|
#6
June 20th, 2007, 09:58 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
automatically updating a table
Thanks a lot, I got it to work. Now, does anyone now if it is
possible to have a drop down menu automatically open when you begin typing in it? So that you can start typing a word and see it in the menu and select it. On Jun 15, 3:11 pm, "Pat Hartman \(MVP\)" please no wrote: Here's a link to an example - not in list demo - that should help youhttp://www.candace-tripp.com/pages/access_downloads.aspx wrote in message oups.com... I have a form used to create an inventory of items. Associated with the form is a table of items that have been previously entered. When I enter an item that is on the list it automatically fills 2 form fields; one with the item name and one with some additional info. In order to type in an item name that is not in the table I must go to the table and enter then return to the form. I would like to be able to fill in the info to the form and have the table automatically updated with the new item info. Is this possible?- Hide quoted text - - Show quoted text -
|
|
#7
June 21st, 2007, 06:25 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
automatically updating a table
Auto fulling is the default behavior
wrote in message oups.com... Thanks a lot, I got it to work. Now, does anyone now if it is possible to have a drop down menu automatically open when you begin typing in it? So that you can start typing a word and see it in the menu and select it. On Jun 15, 3:11 pm, "Pat Hartman \(MVP\)" please no wrote: Here's a link to an example - not in list demo - that should help youhttp://www.candace-tripp.com/pages/access_downloads.aspx wrote in message oups.com... I have a form used to create an inventory of items. Associated with the form is a table of items that have been previously entered. When I enter an item that is on the list it automatically fills 2 form fields; one with the item name and one with some additional info. In order to type in an item name that is not in the table I must go to the table and enter then return to the form. I would like to be able to fill in the info to the form and have the table automatically updated with the new item info. Is this possible?- Hide quoted text - - Show quoted text -
|
|
#8
June 28th, 2007, 02:57 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
automatically updating a table
On Jun 21, 12:25 pm, "Pat Hartman \(MVP\)" please no
wrote: Auto fulling is the default wrote in message oups.com... Thanks a lot, I got it to work. Now, does anyone now if it is possible to have a drop down menu automatically open when you begin typing in it? So that you can start typing a word and see it in the menu and select it. On Jun 15, 3:11 pm, "Pat Hartman \(MVP\)" please no wrote: Here's a link to an example - not in list demo - that should help youhttp://www.candace-tripp.com/pages/access_downloads.aspx wrote in message groups.com... Autofilling is not the issue. I want the dropdown table to dropdown when I start typing, not when I click the arrow. I want to see the entire list as I type. I have a form used to create an inventory of items. Associated with the form is a table of items that have been previously entered. When I enter an item that is on the list it automatically fills 2 form fields; one with the item name and one with some additional info. In order to type in an item name that is not in the table I must go to the table and enter then return to the form. I would like to be able to fill in the info to the form and have the table automatically updated with the new item info. Is this possible?- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text -
|
|
#9
July 18th, 2007, 06:58 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
automatically updating a table
In the onEnter Event of the control -
Me.yourcontrolname.Dropdown wrote in message ups.com... On Jun 21, 12:25 pm, "Pat Hartman \(MVP\)" please no wrote: Auto fulling is the default wrote in message oups.com... Thanks a lot, I got it to work. Now, does anyone now if it is possible to have a drop down menu automatically open when you begin typing in it? So that you can start typing a word and see it in the menu and select it. On Jun 15, 3:11 pm, "Pat Hartman \(MVP\)" please no wrote: Here's a link to an example - not in list demo - that should help youhttp://www.candace-tripp.com/pages/access_downloads.aspx wrote in message groups.com... Autofilling is not the issue. I want the dropdown table to dropdown when I start typing, not when I click the arrow. I want to see the entire list as I type. I have a form used to create an inventory of items. Associated with the form is a table of items that have been previously entered. When I enter an item that is on the list it automatically fills 2 form fields; one with the item name and one with some additional info. In order to type in an item name that is not in the table I must go to the table and enter then return to the form. I would like to be able to fill in the info to the form and have the table automatically updated with the new item info. Is this possible?- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text -
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
