Sample tabbed form

[Will04]

Hi folks,
I've got a questionnaire which has about 80 fields in 5 sections. all sections are linked to a person Id - which is the unique identifier.

I'm thinking that a tab form is the way to go in putting this form in Access in order to facilitate data entry. Is this the best way or is there another way to accomplish this task?

Does anyone have a sample form that I can modify to meet my needs?

Thanks

Will.

 

[KeithG]

I think a tabbed form would suit your needs. If you are going to have multiple people filling out the survey you should use an FE/BE design.

 

[Will04]

KeithG,
Thanks for responding..

Do you have a sample that I can work with?

Will

 

[CEH]

Will, I don't really think you'll need a sample... Probably be easier then you think. First I assume you'll have a query of your 80 fields... say "qryEighty" In your DB forms section just click new.... at this point don't pick any query or table to base it on. Just a blank form in design view. From your tool box pick the "Tab Control" drag it onto your form. You will see the tabs now... two is the default I believe... It will say "page1" and "page2" just right click in the area... say "Page1" and pick "Insert page" from the dropdown. Repeat until you have as many pages as you need. Now click in the little box in the upper left hand corner of the form. Right click and pick "Properties" (properties of the form) In the "Properties" box find "Record source" you can now pick your query.... "qryEighty" (or whatever you call it) from the dropdown.Now click on the "Field List" icon. Now as you click on each different tab you can drag the fields, from the field list, to each page you want them on. Thats about all there is to it.

 

[KeithG]

I agree it is really that difficult. It's just like designing a regular form except you have tabs.

 

[missinglinq]

A tabbed form is really perfect for this sort of thing! There are two things to remember about using tabbed forms:

First, the tabbed pages are simply extensions of the form; think of it as a really long form, turned sideways. You reference controls in the exact same manner as you would if they were all on a single screen.

Secondly, and most importantly when designing your form, ALWAYS be sure that you have selected a page first before placing controls on it! If you don't have a page selected first, the controls you place will appear on all pages!

Occasionally you'll want to have a single control show on all pages, such as if you have a "Save" button popup if the record IsDirty. Then select the form, not a page before placing the control.

 

[Will04]

Thanks so Much!!

Thank you so much for your responses. I will give it a try and let you all know how it works out..

Once again, many thanks..

Will

 

[Will04]

Problems with the Tabbed Form

Hi Folks,

I tried following the instructions posted but I've hit a snag, what have I done wrong??

Here's the situation:
I've got 5 tables linked by a patient Id.

I created a query to select all the fields from the 5 tables.

I then created the form with 5 pages and used the query as the record source.

I then selected the relevant fields and placed them in their respective pages.

The Problem:
When I try to enter data in any of the fields, nothing is happening. I checked the property of the form and 'Data Entry' has been set to Yes.

Any Suggestions?


Thanks so much.


Will

 

[CEH]

Post the DB

 

[Will04]

Here's the form

Hi Curtis and Others

Tabbed form attached.

Can you advise on :-

1. How to get control to move from the last field in one page to the first field in the next page?

2. The relationship between the tables. Is it ok or do I need to change it?

Many thanks


Will

 

[CEH]

Well....... Lots of things here..... All these one to one's.... NO
One to one relationships are not that common, and usually used to break up a table. But here I see alot of tables... but not related correctly. Lets take one example for you. You have a table "ethnicity" basically a lookup table... thats fine... Now you have your "Main" table so to speak... "PatientData" OK in the "PatientData" table you should have a foreign key "EthID"... number. Now you relate the "Ethnicity" table where "EthID" is the primary key, to the "EthID" foreign key in "PatientData" table.... A One to many relationship.
Now with the "EthID" say on your first tab... you can drop a combo box onto your form.... Follow the wizard... combo box to look up value from table "Ethnicity" store value "EthID" in "EthID" in "PatientData" table. Now you will have a dropdown combo to choose ethnicity when entering a new patient.
Now you can start looking at all your other tables and how they relate. I think you'll find alot of "ID" fields (number) are going to be in yout "PatientData" table.
The dropdowns speed data entry and limit the input to your list.
But once you change one or two of these I think you'll see how it works. And I bet you end up with NO one to one relationships


As for your other problem on the Tab.... Not sure if there is an easy way... I'll let someone else chime in on that one..... You can always on the "AfterUpdate" event of the last text box on one tabbed page to set the focus to the first textbox of the second tabbed page. That should work (didnt try it) but there might be an easier, and better way.

 

[Will04]

Thanks so much!!

Curtis,

Thanks for the info. on the table relationships, I will implement these changes shortly.

However, the original problem is still there i.e. the tab form is not allowing me to enter data, can you check it for me please?

Once again, thanks..


Will