Hi.
I have a client that wants to do the following:
1) Scan in a copy of a paper form. (The form is very complicated and hard to
replicate manually.)
2) Data enter the fields from the paper form into the screen. (The reason he
wants the "image" of the form itself is that this will make the data entry
easier.)
3) Use the entered data to populate an Access 2000 table.
4) Use the stored data to print reports etc... that are based on this data.
Does anyone have any suggestions as to the best way to do this: in VB or
Access directly? Any 3rd party tools to recommend?
TIA!
Aliza

Signature
-----------------------------------
Aliza Klein
abklein@optonline.net
-----------------------------------
Sounds like you want to emulate Adobe's "fillable forms". A quickie off the
top of my head...
Scan the form and set the scanned image's file to the VB form's Picture
property. Then arrange text boxes and such on the VB form accordingly (also
insure their tab indexes are set accordingly). You can make the text boxes
borderless or flat with border to fit the aesthetics of the scanned form.
If the form's too big to fit the screen, do it as a scrollable viewport,
placing the scanned image in a picturebox and placing the controls in this
picturebox container.
Just some ideas regarding the VB data input design.
> Hi.
>
[quoted text clipped - 16 lines]
> TIA!
> Aliza
Sparky - 27 Feb 2004 22:25 GMT
Personally I'd invest the time in replicating on an access form. Access
forms have built-in scrolling (if you enable it) which would deal with the
form being bigger than the screen.
<Sparky />
> Sounds like you want to emulate Adobe's "fillable forms". A quickie off the
> top of my head...
[quoted text clipped - 33 lines]
> > TIA!
> > Aliza
Aliza Klein - 29 Feb 2004 01:02 GMT
Thanks, all, for the advice!
That's kind of the way I was going but wanted another opinion as to the best
way of doing this.
Aliza
> Personally I'd invest the time in replicating on an access form. Access
> forms have built-in scrolling (if you enable it) which would deal with the
[quoted text clipped - 45 lines]
> > > TIA!
> > > Aliza