How to use a scanned pdf as a form in Access 2007?

Hi everyone,

I am trying to use a scanned pdf which I've converted into a jpeg as a form background.  I want my access query to fill in certain value, so I've setup control source text boxes- which works great.  However there are two sides to the form which poses my first problem.  The second is that there are multiple individuals that I would need to print this file out for.  

I've also thought about making a templated in Word, but I don't know how to setup the constant link to the database file.  
LVL 1
Anthony6890Asked:
Who is Participating?
 
hnasrCommented:
You can use a form with 2 page tab control. Select the page and paste the image.
Add the text boxes to proper places over the respective image.

Output can be produced by imposing the controls over the scanned images.
0
 
Anthony6890Author Commented:
hnasr,

Thanks for the info.  Can you elaborate more on this "2 page tab control".  I'm not familiar with it.

Thanks.

-A
0
 
Jeffrey CoachmanMIS LiasonCommented:
<No Points wanted>
hnasr has answered your question here.

Just note that using images that fill entire Forms or Reports will Bloat the DB.

A few images is fine, but when you start using high rez images for all your forms and reports, the DB will grow even bigger than the size of the images themselves.

JeffCoachman
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Jeffrey CoachmanMIS LiasonCommented:
< The second is that there are multiple individuals that I would need to print this file out for.  >
Normally, this should not be a problem...but we would need more info on this if this is an issue.
0
 
Anthony6890Author Commented:
Hi boaq thanks for the fyi.

The DB is strictly going to be used to produce the forms so they will not be stored in the DB.  Once the form is created and printed the data will be refreshed and deleted.  
0
 
Anthony6890Author Commented:
For the multiple individuals issue, I mean that the table I'm retrieving the data from, to fill in the form, will have multiple lines for different individuals.  I just want to make sure that this will not fowl up any of the processes...
0
 
Jeffrey CoachmanMIS LiasonCommented:
Then this issue would be better served as a new question.

If one record will have Multiple XXX's, then you should probably have a related table where each user can enter data, then display this data in a subform or sub report.

But again, post a new/related question for this issue...

;-)

JeffCoachman
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.