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  

Sub Form Input



 
 
Thread Tools Display Modes
  #1  
Old December 20th, 2006, 05:20 PM posted to microsoft.public.access.forms
Nanette
external usenet poster
 
Posts: 151
Default Sub Form Input

I created a form with several subforms. To get the visual placement I wanted,
I split up some of the fields into several subforms (fields from the same
table). Now when data is entered, data from one subform is inputted onto one
line in the table, then when data is entered into another subform on the same
form (from the same table) data is inputted onto another line in the table.

Is there a way to get all the data from the separate subforms (from one
table) on one form to enter onto one line in the table?

OR is there another way to place fields of a subform onto a form so I can
move the subform fields to where I want them?
  #2  
Old December 20th, 2006, 06:21 PM posted to microsoft.public.access.forms
John Vinson
external usenet poster
 
Posts: 4,033
Default Sub Form Input

On Wed, 20 Dec 2006 08:20:00 -0800, Nanette
wrote:

OR is there another way to place fields of a subform onto a form so I can
move the subform fields to where I want them?


Use a Single Form or Continuous Form view on the subform rather than
the default Datasheet view, and arrange the fields into some suitable
arrangement on the screen, rather than using separate subforms.

John W. Vinson[MVP]
  #3  
Old December 20th, 2006, 07:16 PM posted to microsoft.public.access.forms
Nanette
external usenet poster
 
Posts: 151
Default Sub Form Input

Hi John,

I'm still not getting the flexibility I'd like. Is there a way to make the
background of a subform transparent so I can do some fancy aligining?

"John Vinson" wrote:

On Wed, 20 Dec 2006 08:20:00 -0800, Nanette
wrote:

OR is there another way to place fields of a subform onto a form so I can
move the subform fields to where I want them?


Use a Single Form or Continuous Form view on the subform rather than
the default Datasheet view, and arrange the fields into some suitable
arrangement on the screen, rather than using separate subforms.

John W. Vinson[MVP]

  #4  
Old December 20th, 2006, 07:27 PM posted to microsoft.public.access.forms
John Vinson
external usenet poster
 
Posts: 4,033
Default Sub Form Input

On Wed, 20 Dec 2006 10:16:01 -0800, Nanette
wrote:

Hi John,

I'm still not getting the flexibility I'd like. Is there a way to make the
background of a subform transparent so I can do some fancy aligining?


I don't know; I've never needed to do so, and have no clue what kind
of fancy aligning you want to do, or how a transparent background
would help.

Might a Tab Control help with arranging screen real estate?

John W. Vinson[MVP]
  #5  
Old December 20th, 2006, 08:17 PM posted to microsoft.public.access.forms
Nanette
external usenet poster
 
Posts: 151
Default Sub Form Input

I'm not sure if tab control would help. I think I'm going to work on
redesigning the form.

Thanks for your comments!

"John Vinson" wrote:

On Wed, 20 Dec 2006 10:16:01 -0800, Nanette
wrote:

Hi John,

I'm still not getting the flexibility I'd like. Is there a way to make the
background of a subform transparent so I can do some fancy aligining?


I don't know; I've never needed to do so, and have no clue what kind
of fancy aligning you want to do, or how a transparent background
would help.

Might a Tab Control help with arranging screen real estate?

John W. Vinson[MVP]

 




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


All times are GMT +1. The time now is 01:35 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.