Tabs in a form with subforms on each tab

[Amy Schmid]

Good afternoon,

I learning Access as I use it and I am having trouble with tabs, my data
input and subforms.

I have a form created [frm:_ajs_Ag_Main]. This form has a drop down feature
that allows for searching for a client name (tied to dbo_clients). This
should then display the client number but it does not.

In frm:_ajs_Ag_Main, I have 9 tabs; one for each section of my financial
statement (FS):
Sales
Livestock
Crop
Labor
Land
General
Other Income
Other FS Data
Non FS Data

The information for the 1st 8 tabs come from two tables: dbo_ajs_Ag_FS_Data
and dbo_ajs_Ag_FS_Detail. The 9th tab has a subform that is working properly.

I need to have the FS Detail listed on each tab and still allow for the data
input of the numbers. I cannot figure out how to get this set up as the data
is coming from two different tables. The 9th tab came from one table.

What I want the 1st tab to look like is this:
[static label] [data input box]
Milk $4,410
Cull Cow $2,000
etc.

The static lable comes from table dbo_ajs_FS_Detail. the data input box
comes from dbo_ajs_FS_Data. This would allow the preparer the ability to see
the whole list of FS Details as he is entering his information.

I have tried to creat a form from both and a query from both and cannot get
it to do what I want. I get the list of details, each on a separate record
instead of a list on the form. Then I cannot it to accept my data input.

Please let me know if you need more information or clarification. I am
using Access 2000.

Thank you,
Amy

 

[NKTower]

Here's a demonstration of something similar I put together for the local user
group.

http://tinyurl.com/5ktkaw

Take a look at how the forms are constructed, the queries behind, the code
in the main form that does the selection of data for the subforms, etc.

 

[NKTower]

A while ago I put together a demonstration for our local Access Special
Interest Group - take a look:

http://tinyurl.com/5ktkaw

I'd suggest you start on the TABLES page and click VIEW / RELATIONSHIPS to
see how the tables are set up. (You don't have to change your database, but
you should see how my tables are related.)

Then open the form MAIN and play with it a bit.

Then open MAIN in design view and see how the subforms are linked to the
main form.

Lastly open MAIN's code view and see what is happening in the code behind
teh form.

I think that most if not all of the things you requested are addressed in
the sample.

 

[NKTower]

Here's a link to a download -
http://www.deadzoom.com/member/nktower/SIG/MultiTab.html

It will take you to a file with _ZIP_ as the extension. (This server doesn't
permit storing of .ZIP files, so you will have to rename the file upon
download.)

It is a demonstration I put together for our local user group's MS Access
Special Interest Group. It demonstrates the use of tabbed subforms where the
main form has a combo box for selecting the primary record to which the
subforms are attached.

I'd suggest looking at the table structure first (VIEW /RELATIONSHIPS) -
just so you see how this app. works, you shouldn't have to change our
application. Then run the MAIN form, then open main form's VBA code (View /
Design) followed by (View / Code) to see how things are tied together.

 

[Amy Schmid]

Good morning,

I was not able to access the link below. Can I access this another way?

Thanks,
Amy

Here's a link to a download -
http://www.deadzoom.com/member/nktower/SIG/MultiTab.html

It will take you to a file with _ZIP_ as the extension. (This server doesn't
permit storing of .ZIP files, so you will have to rename the file upon
download.)

It is a demonstration I put together for our local user group's MS Access
Special Interest Group. It demonstrates the use of tabbed subforms where the
main form has a combo box for selecting the primary record to which the
subforms are attached.

I'd suggest looking at the table structure first (VIEW /RELATIONSHIPS) -
just so you see how this app. works, you shouldn't have to change our
application. Then run the MAIN form, then open main form's VBA code (View /
Design) followed by (View / Code) to see how things are tied together.

Good afternoon,

I learning Access as I use it and I am having trouble with tabs, my data
input and subforms.

I have a form created [frm:_ajs_Ag_Main]. This form has a drop down feature
that allows for searching for a client name (tied to dbo_clients). This
should then display the client number but it does not.

In frm:_ajs_Ag_Main, I have 9 tabs; one for each section of my financial
statement (FS):
Sales
Livestock
Crop
Labor
Land
General
Other Income
Other FS Data
Non FS Data

The information for the 1st 8 tabs come from two tables: dbo_ajs_Ag_FS_Data
and dbo_ajs_Ag_FS_Detail. The 9th tab has a subform that is working properly.

I need to have the FS Detail listed on each tab and still allow for the data
input of the numbers. I cannot figure out how to get this set up as the data
is coming from two different tables. The 9th tab came from one table.

What I want the 1st tab to look like is this:
[static label] [data input box]
Milk $4,410
Cull Cow $2,000
etc.

The static lable comes from table dbo_ajs_FS_Detail. the data input box
comes from dbo_ajs_FS_Data. This would allow the preparer the ability to see
the whole list of FS Details as he is entering his information.

I have tried to creat a form from both and a query from both and cannot get
it to do what I want. I get the list of details, each on a separate record
instead of a list on the form. Then I cannot it to accept my data input.

Please let me know if you need more information or clarification. I am
using Access 2000.

Thank you,
Amy

 

[NKTower]

Sorry you ran into a problem. Did you get to the HTML page which had furtner
instructions? If so, try right-clicking on the link on that page and select
SAVE AS...

I don' t have an ftp server with which to provide public access.

Alternatively, set up a throw-away e-mail account - such as hotmail, put the
adress here, and I will e-mail it to you. The ZIP is only something like
55KB. It is generally not a good idea to post e-mail addresses on forum
pages.

 

[Amy Schmid]

I clicked on the link, clicked save as and then tried to open it and I was
taken to a website to sign up for payment options.

I was able to solve my problem by simplfing my process. I had a data table
and two tables linked to that data table. I decided to make things simpler
by removing the one table and combining the data table with the remaining
table and was able to create my subforms from that.

It works like a charm.

Thank you!
Amy

 

[NKTower]

I'm glad you worked it out. I don't know why deadzoom (the server site the
..MDB in a ZIP is sitting upon) wouldn't let you download the ZIP. I guess
I'll have to get anonymous ftp (read only) set up on a server as the demo
isn't much good w/o the tables and forms behind it.