Paper Data Entry Form

S

sargum

Hello,

I have a form with many fields. Some of the fields are combo boxes
based on value lists where the value list could have up to 5 different
choices.

Field Example: Incision Dimension (Value List: 2.0, 2.5, 3, 3.5, 4)

I need a paper copy of the form that users can fill out. Is there an
easy way to do this such that the fields which are combo boxes will be
presented with all the value list choices (i.e., Incision Dimension
(2, 2.5, 3, 3.5, 4) so the user is aware of all the choices and
perhaps circles the relevant one?

I know I could print the form but it would not capture the value
options in these combo boxes.
I know I could make a form in Word or Excel but hoping I can avoid
having to do that.

Thanks for you help.

S
 
J

Jeff Boyce

I'll be very curious to see if someone has such a tool. For whatever it's
worth, I've not heard of a way to "print a form" and have it drop down all
its own comboboxes. Actually, depending on the placement, I could imagine
having some drop-down lists obscuring other dropped-down lists, so it might
not even be a good idea?!

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
S

sargum

I'll be very curious to see if someone has such a tool. For whatever it's
worth, I've not heard of a way to "print a form" and have it drop down all
its own comboboxes. Actually, depending on the placement, I could imagine
having some drop-down lists obscuring other dropped-down lists, so it might
not even be a good idea?!

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP












- Show quoted text -
Click to expand...

Hi,

You bring up a good point. I thought about this too but am thinking
that there may be a report or something like a report that would take
this into account and generate something that would present the data
without obscuring fields based on combobox choices. If there isn't a
tool, there should be...It would be great to have a wizard that spits
out a paper data entry version to give to users. My guess is that
every database maker has to use work or Excel to make such a thing...I
am surprised that MS Access hasn't thought of making this easy to do.

S
 
B

Bob Quintal

My guess is that every database maker has to
use work or Excel to make such a thing...I am surprised that MS
Access hasn't thought of making this easy to do.

S
Click to expand...
Very few developers need to have users fill in a paper form and someone
else perform data entry on the completed paper. It's duplication of
effort and expensive.
 
J

Jeff Boyce

What I've noticed is that it is often easier to give the users a screen and
let them do the data entry/data selection. This tends to reduce the
frequency of data entry errors, since it's touched once, not twice.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
S

sargum

What I've noticed is that it is often easier to give the users a screen and
let them do the data entry/data selection. This tends to reduce the
frequency of data entry errors, since it's touched once, not twice.

Regards

Jeff Boyce
Microsoft Office/Access MVP







- Show quoted text
Click to expand...

Hello,

I agree that it would be most efficient if the user entered the data
into the DB. However, these are going to be clinicals at the
hospital. They need to have the data fresh in their mind to fill out
a paper data entry form. Let me know if anyone has any ideas. Thx.

S
 
J

Jeff Boyce

Consider reposting as a new thread.

Consider searching on-line.

Consider creating a Word (or Excel) document that depicts what you need it
to.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
B

benyod79 via AccessMonster.com

I'd be very interested in knowing if someone has a tool for this. One
suggestion I'd make is to create a report that brings all your data together.
Each of your combo boxes would be a sub-report. Make a seperate expression
for each different subreport. I just tested this method out and it works.
It'd take some time to revamp the layout, but it'll work.

The nice thing about this method is the data will not be hard-coded and will
update automatically. However, the layout won't be as manageable as a word
document.

Good luck.
 
S

sargum

I'd be very interested in knowing if someone has a tool for this. One
suggestion I'd make is to create a report that brings all your data together.
Each of your combo boxes would be a sub-report. Make a seperate expression
for each different subreport. I just tested this method out and it works.
It'd take some time to revamp the layout, but it'll work.

The nice thing about this method is the data will not be hard-coded and will
update automatically. However, the layout won't be as manageable as a word
document.

Good luck.
Click to expand...

That's a good idea. Thank you. I will try it.

-S
 
Top