limit of objects / using Do menu item

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am developing a survey using access and i found out there is a limit of
number objects for each form. So i have to create a new form for every
single question )or a group of questions) .
The problem i have is that i need to keep all forms open as they are part of
the same record.

When i finish eahc survey i have to save the record and then add a new record.
I think i could do a doMenuItem, but i am not sure.. any suggestions?
thanks
 
I think you have a very limited understanding of what an Access database is,
and can do. Your statement that "... i need to keep all forms open as they
are part of the same record." betrays this. Forms are not part of any
record - they are a means of entering data into tables, and displaying data
from tables/queries. Yes, there is a limit to the number of controls which
can be placed on a form (768, if memory serves me correctly). I'd be very
surprised if your survey requires more than this.

Of more practical help to you, however, is this:

Duan Hookom has designed a survey database appplication, which you can use
as is (removing the example questions and responses), or modify for your own
needs. Your can download it from
http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='At Your Survey 2000'

I suggest you start here, and study this carefully. Then, if you have
problems, post again.

HTH,

Rob
 
you are right.. i am just trying to develop a survey using access and i dont
have much experience
i will explain what i need to do
i have around 50 question for each survey and each question has around 6
options, which means i cant just create one form and put all fields from the
same table there. (as i usually do)

what i did then was to create 10 forms and each form contains 5 questions.
so when i fill out the first 5 questions and open the next form, it creates
another record, instead of keeping all in the same record... which is my
problem.

do you understand me?
thanks heaps
 
You can force each form to use the same record if you have a primary key (in
this case, an autonumber field would serve fine) in the underlying table.
Then, when you open the second form from the first - I presume you are doing
this via a command button - simply use the Where parameter to ensure that it
opens with the correct record showing. Something like:
Me.Dirty = False 'force save, to ensure ID autonumber is set
DoCmd.OpenForm "frmSurveyPart2", , , "ID = " & Me.ID

You'll probably also want to set the AllowAdditions property of the latter
forms to No, and ensure that no navigation controls are available, so that
the user cannot move to another record.

An alternative approach would be to use a tab control to display each
section of the survey in separate tab pages on the same form.

HTH,

Rob
 
Back
Top