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
|
|||
|
|||
Data entry - fields from 4 tables
I'd like to be able to perform data entry for fields from 4 tables, in a
single data entry interface. (I'm using Access 2002, SP3.) Is there a way for this data entry to be done from a single interface in Form view? The only data entry "interface" solution of which I am aware is not very good. This solution consists of creating a Form from one table, and then adding 3 separate subforms (each subform bound to one of the 3 remaining tables). With this solution, data entry for the fields in the 3 subforms must be done via the 3 subform "datasheets." I find this data entry "interface" solution to be really poor. Further, the solution is made worse because horizontal scrolling is required for data entry into each subform (as the number of fields in each subform does not fit in the visible portion of datasheet). Any help will be greatly appreciated. -- 2nd_Stage_User |
#2
|
|||
|
|||
Subforms do not have to be datasheets. They can be continuous forms, or
single view forms as well. As an interface you can use a Tab control to separate the pages or simply add a page break and use the PageDown/PageUp keys to move between form areas. You can also show and hide subforms, or set their height to 0 and make them visible in code by resetting their properties. -- Arvin Meyer, MCP, MVP Microsoft Access Free Access downloads: http://www.datastrat.com http://www.mvps.org/access "2nd_Stage_User" wrote in message ... I'd like to be able to perform data entry for fields from 4 tables, in a single data entry interface. (I'm using Access 2002, SP3.) Is there a way for this data entry to be done from a single interface in Form view? The only data entry "interface" solution of which I am aware is not very good. This solution consists of creating a Form from one table, and then adding 3 separate subforms (each subform bound to one of the 3 remaining tables). With this solution, data entry for the fields in the 3 subforms must be done via the 3 subform "datasheets." I find this data entry "interface" solution to be really poor. Further, the solution is made worse because horizontal scrolling is required for data entry into each subform (as the number of fields in each subform does not fit in the visible portion of datasheet). Any help will be greatly appreciated. -- 2nd_Stage_User |
#3
|
|||
|
|||
In a moment of distraction, I mistakenly clicked the "Yes" button, regarding
your reply to my question. Clearly, your reply was an answer (and appreciated), but without some "how-to" info, I have no idea how to translate your info into a "single" data entry interface for fields from 4 tables. Please, would you provide some "steps" or "how-to" details? Right now, I have one Form, with 3 subforms added to the Form. The Form is bound to one table. Each subform is bound to one table. The 4 tables a Main, Detail, Author, and Subject. When I switch from Design View to Form View, the subforms are presented as datasheets. Thank you for your first reply! -- 2nd_Stage_User "Arvin Meyer [MVP]" wrote: Subforms do not have to be datasheets. They can be continuous forms, or single view forms as well. As an interface you can use a Tab control to separate the pages or simply add a page break and use the PageDown/PageUp keys to move between form areas. You can also show and hide subforms, or set their height to 0 and make them visible in code by resetting their properties. -- Arvin Meyer, MCP, MVP Microsoft Access Free Access downloads: http://www.datastrat.com http://www.mvps.org/access "2nd_Stage_User" wrote in message ... I'd like to be able to perform data entry for fields from 4 tables, in a single data entry interface. (I'm using Access 2002, SP3.) Is there a way for this data entry to be done from a single interface in Form view? The only data entry "interface" solution of which I am aware is not very good. This solution consists of creating a Form from one table, and then adding 3 separate subforms (each subform bound to one of the 3 remaining tables). With this solution, data entry for the fields in the 3 subforms must be done via the 3 subform "datasheets." I find this data entry "interface" solution to be really poor. Further, the solution is made worse because horizontal scrolling is required for data entry into each subform (as the number of fields in each subform does not fit in the visible portion of datasheet). Any help will be greatly appreciated. -- 2nd_Stage_User |
#4
|
|||
|
|||
Go to the Properties sheet for each of the three subforms. go to the
"Format" tab, and on the "Default View" property dropdown select "Single Form" --- save those three change (one on each subform) ... "2nd_Stage_User" wrote in message ... In a moment of distraction, I mistakenly clicked the "Yes" button, regarding your reply to my question. Clearly, your reply was an answer (and appreciated), but without some "how-to" info, I have no idea how to translate your info into a "single" data entry interface for fields from 4 tables. Please, would you provide some "steps" or "how-to" details? Right now, I have one Form, with 3 subforms added to the Form. The Form is bound to one table. Each subform is bound to one table. The 4 tables a Main, Detail, Author, and Subject. When I switch from Design View to Form View, the subforms are presented as datasheets. Thank you for your first reply! -- 2nd_Stage_User "Arvin Meyer [MVP]" wrote: Subforms do not have to be datasheets. They can be continuous forms, or single view forms as well. As an interface you can use a Tab control to separate the pages or simply add a page break and use the PageDown/PageUp keys to move between form areas. You can also show and hide subforms, or set their height to 0 and make them visible in code by resetting their properties. -- Arvin Meyer, MCP, MVP Microsoft Access Free Access downloads: http://www.datastrat.com http://www.mvps.org/access "2nd_Stage_User" wrote in message ... I'd like to be able to perform data entry for fields from 4 tables, in a single data entry interface. (I'm using Access 2002, SP3.) Is there a way for this data entry to be done from a single interface in Form view? The only data entry "interface" solution of which I am aware is not very good. This solution consists of creating a Form from one table, and then adding 3 separate subforms (each subform bound to one of the 3 remaining tables). With this solution, data entry for the fields in the 3 subforms must be done via the 3 subform "datasheets." I find this data entry "interface" solution to be really poor. Further, the solution is made worse because horizontal scrolling is required for data entry into each subform (as the number of fields in each subform does not fit in the visible portion of datasheet). Any help will be greatly appreciated. -- 2nd_Stage_User |
#5
|
|||
|
|||
Thank you Bob! Extremely appreciated. Easy enough. I'll give it a try.
-- 2nd_Stage_User "Bob Howard" wrote: Go to the Properties sheet for each of the three subforms. go to the "Format" tab, and on the "Default View" property dropdown select "Single Form" --- save those three change (one on each subform) ... "2nd_Stage_User" wrote in message ... In a moment of distraction, I mistakenly clicked the "Yes" button, regarding your reply to my question. Clearly, your reply was an answer (and appreciated), but without some "how-to" info, I have no idea how to translate your info into a "single" data entry interface for fields from 4 tables. Please, would you provide some "steps" or "how-to" details? Right now, I have one Form, with 3 subforms added to the Form. The Form is bound to one table. Each subform is bound to one table. The 4 tables a Main, Detail, Author, and Subject. When I switch from Design View to Form View, the subforms are presented as datasheets. Thank you for your first reply! -- 2nd_Stage_User "Arvin Meyer [MVP]" wrote: Subforms do not have to be datasheets. They can be continuous forms, or single view forms as well. As an interface you can use a Tab control to separate the pages or simply add a page break and use the PageDown/PageUp keys to move between form areas. You can also show and hide subforms, or set their height to 0 and make them visible in code by resetting their properties. -- Arvin Meyer, MCP, MVP Microsoft Access Free Access downloads: http://www.datastrat.com http://www.mvps.org/access "2nd_Stage_User" wrote in message ... I'd like to be able to perform data entry for fields from 4 tables, in a single data entry interface. (I'm using Access 2002, SP3.) Is there a way for this data entry to be done from a single interface in Form view? The only data entry "interface" solution of which I am aware is not very good. This solution consists of creating a Form from one table, and then adding 3 separate subforms (each subform bound to one of the 3 remaining tables). With this solution, data entry for the fields in the 3 subforms must be done via the 3 subform "datasheets." I find this data entry "interface" solution to be really poor. Further, the solution is made worse because horizontal scrolling is required for data entry into each subform (as the number of fields in each subform does not fit in the visible portion of datasheet). Any help will be greatly appreciated. -- 2nd_Stage_User |
#6
|
|||
|
|||
Data entry - fields from 4 tables
Thank you very much. This solution, just fixed my tiresome problem of 1
week. Thank. you again. -- Dorothy "Bob Howard" wrote: Go to the Properties sheet for each of the three subforms. go to the "Format" tab, and on the "Default View" property dropdown select "Single Form" --- save those three change (one on each subform) ... "2nd_Stage_User" wrote in message ... In a moment of distraction, I mistakenly clicked the "Yes" button, regarding your reply to my question. Clearly, your reply was an answer (and appreciated), but without some "how-to" info, I have no idea how to translate your info into a "single" data entry interface for fields from 4 tables. Please, would you provide some "steps" or "how-to" details? Right now, I have one Form, with 3 subforms added to the Form. The Form is bound to one table. Each subform is bound to one table. The 4 tables a Main, Detail, Author, and Subject. When I switch from Design View to Form View, the subforms are presented as datasheets. Thank you for your first reply! -- 2nd_Stage_User "Arvin Meyer [MVP]" wrote: Subforms do not have to be datasheets. They can be continuous forms, or single view forms as well. As an interface you can use a Tab control to separate the pages or simply add a page break and use the PageDown/PageUp keys to move between form areas. You can also show and hide subforms, or set their height to 0 and make them visible in code by resetting their properties. -- Arvin Meyer, MCP, MVP Microsoft Access Free Access downloads: http://www.datastrat.com http://www.mvps.org/access "2nd_Stage_User" wrote in message ... I'd like to be able to perform data entry for fields from 4 tables, in a single data entry interface. (I'm using Access 2002, SP3.) Is there a way for this data entry to be done from a single interface in Form view? The only data entry "interface" solution of which I am aware is not very good. This solution consists of creating a Form from one table, and then adding 3 separate subforms (each subform bound to one of the 3 remaining tables). With this solution, data entry for the fields in the 3 subforms must be done via the 3 subform "datasheets." I find this data entry "interface" solution to be really poor. Further, the solution is made worse because horizontal scrolling is required for data entry into each subform (as the number of fields in each subform does not fit in the visible portion of datasheet). Any help will be greatly appreciated. -- 2nd_Stage_User |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Table Design | A. Williams | Database Design | 3 | April 29th, 2005 07:02 PM |
strategy for data entry in multiple tables | LAF | Using Forms | 18 | April 25th, 2005 04:04 AM |
Same database or another? | accesskastle | Database Design | 2 | April 11th, 2005 07:29 PM |
decipher log of scanpst.exe | km | General Discussion | 0 | July 18th, 2004 09:00 AM |
Newbie? Do I use Report or Query | John Egan | New Users | 11 | June 28th, 2004 08:31 PM |