[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 225
  • Last Modified:

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.  
0
Anthony6890
Asked:
Anthony6890
  • 3
  • 3
1 Solution
 
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 CoachmanCommented:
<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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
Jeffrey CoachmanCommented:
< 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 CoachmanCommented:
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

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now