Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How to work around 22 inch section limit?
- Thread starter tracy1234
- Start date
I think the best you can do (as far as keeping to one form) would be to stretch it out horizontally and vertically as far as it goes and use all of that area. Just thinking of the surveys I've seen, maybe you could link some forms...finish ten questions, go to the next ten. I guess if you're stuck using one form you can't do much more than stretch it as far as possible. Sorry...maybe someone else has a better idea.
Kevin
Kevin
....is limited to 22 inches long. .....
As far as I know, the 22 inches is a limit imposed by Access. The only thing I can think of is making the point size smaller and try using a different font. It is something you may have to play with and / or move the fields closer together. One thing I do is make all fields Can Grow (in properties). This way, when viewing, you can quickly see if a field is too small.
HTH
An investment in knowledge always pays the best dividends.
by Benjamin Franklin
As far as I know, the 22 inches is a limit imposed by Access. The only thing I can think of is making the point size smaller and try using a different font. It is something you may have to play with and / or move the fields closer together. One thing I do is make all fields Can Grow (in properties). This way, when viewing, you can quickly see if a field is too small.
HTH
An investment in knowledge always pays the best dividends.
by Benjamin Franklin
- Thread starter
- #4
Kevin - I was thinking about breaking it down into linked forms as an alternative, but can't quite get my brain around how to keep the data synchronized.
Let's say that my survey uses autonumbering as the key field. What happens if I have multiusers entering data into the various forms at the same time. How do I ensure that user 1's data is not mixed with user 2 and 3's if I use multiple forms to commit the survey data?
Let's say that my survey uses autonumbering as the key field. What happens if I have multiusers entering data into the various forms at the same time. How do I ensure that user 1's data is not mixed with user 2 and 3's if I use multiple forms to commit the survey data?
Well each set of responses would be one entire record I would think (not sure how your tables are set up to store the information, but it most likely should be set up that way). If that's the case then let's say there are 3 people entering data...#1 will start entering data into the bound controls and the form will automatically create a new record and give it ID#10 or whatever number you are on. Then when you move to the next form with the next 5 questions on it you can pass the ID#10 to the form and continue to work on the same record. That will ensure that nobody else is working with the same record since if #2 starts entering data he/she will be working with ID#11 (the next record). Make sense? Hope that helps.
Kevin
Kevin
- Thread starter
- #6
Look up the OpenForm action in help. Should just be something like this:
OpenForm "TheForm",,,"[id]=" & me.txtID
...where [id] is the id field of the table, and me.txtid is the name of the text box or other control that has the id you are passing.
OpenForm "TheForm",,,"[id]=" & me.txtID
...where [id] is the id field of the table, and me.txtid is the name of the text box or other control that has the id you are passing.
- Thread starter
- #8
Tracy,
Sorry for some misinformation on my part. I happen to be working on a report for someone and even though my eyes saw what you wrote, my brain transposed it report.
Kevin's suggestion is a good one. You may also want to think about making the form tabular. Once you start, no one else can use the same ID#.
Good Luck !!
An investment in knowledge always pays the best dividends.
by Benjamin Franklin
Sorry for some misinformation on my part. I happen to be working on a report for someone and even though my eyes saw what you wrote, my brain transposed it report.
Kevin's suggestion is a good one. You may also want to think about making the form tabular. Once you start, no one else can use the same ID#.
Good Luck !!
An investment in knowledge always pays the best dividends.
by Benjamin Franklin
- Status
Similar threads
