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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
<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
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
< 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.
Normally, this should not be a problem...but we would need more info on this if this is an issue.
ASKER
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.
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.
ASKER
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...
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
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
ASKER
Thanks for the info. Can you elaborate more on this "2 page tab control". I'm not familiar with it.
Thanks.
-A