A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Data entry - fields from 4 tables



 
 
Thread Tools Display Modes
  #1  
Old June 12th, 2005, 10:19 PM
2nd_Stage_User
external usenet poster
 
Posts: n/a
Default 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  
Old June 13th, 2005, 12:10 AM
Arvin Meyer [MVP]
external usenet poster
 
Posts: n/a
Default

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  
Old June 13th, 2005, 01:16 AM
2nd_Stage_User
external usenet poster
 
Posts: n/a
Default

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  
Old June 13th, 2005, 01:27 AM
Bob Howard
external usenet poster
 
Posts: n/a
Default

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  
Old June 13th, 2005, 03:44 AM
2nd_Stage_User
external usenet poster
 
Posts: n/a
Default

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  
Old February 3rd, 2006, 06:12 PM posted to microsoft.public.access.forms
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 11:39 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.