Fill form from database 1

[aw23]

I have a database with 30,000 clients. I have a form independent of the program with client information. Name, address, email, etc. Whenever there is a meeting the user needs to fill out one of these forms by hand, taking the data from the database. I have the form scanned into my computer, Is there any way to fill it out from the database programmatically so that the user can just print it out?
Thanks!

 

[ZmrAbdulla]

Can't you create a form or report looks like the scanned form? You can keep the scanned image as backgorund of the report/form and place textboxes & other controls where necessary. Make sure the image is not strechable/zoom, that will relocate the controls on the form

Zameer Abdulla
_{Jack of Visual Basic Programming, Master in Dining & Sleeping}
Visit Me

 

[aw23]

That's a great idea! Thanks, I will try that and see what I can do.

 

[aw23]

I have created the image as a background but a couple of questions.
1. I made it Zoom because otherwise for some reason it is not the right size. Anyway to get around this?
2. When I print the form I get the following message'The section width is greater than the page width, and there are no items in the additional space, so some pages may be blank.
For example, the report width may be wider than the page width.'
I then print and I get 4 pages of the same printout!

Any help would be appreciated. THanks!

 

[ZmrAbdulla]

1) Create an image that to fit exactly and use it on the form
2)There can be a single line that exceeding the page width and reaching the second page. And it may appear as a single dot(.)that we don't noramlly notice.
3)Try to reduce the width of report maximum you can.
4)Zooming a picture may not give the exact result. It will certainly relocated the controls.
5)Remove the header and footer
6)If the pagesetup is A4 then try Letter
7)Also try DoCmd.SetWarnings False to stop the message.
Hope this helps

Zameer Abdulla
_{Jack of Visual Basic Programming, Master in Dining & Sleeping}
Visit Me

 

[aw23]

My image should fit exactly but for some reason it doesn't. When I don't zoom it, it is huge. The designer fit it exactly but it doesn't seem to work.
I am using a form not a report, are those things for a report? Should I be using a report?

 

[ZmrAbdulla]

All are for reports. Also you can recreate design of the fillable form through Report by placing exact controls & images on the desired location.
If you are using it with form you may have to reduce the window size (not form size) or you have to use boarderstyle=dialog
AutoResize=No etc..

I think you have more control if you are using Report. Because they are made for printing.

Zameer Abdulla
_{Jack of Visual Basic Programming, Master in Dining & Sleeping}
Visit Me

 

[aw23]

ok, I tried a report and I tried all of your suggestions. My image is still way too big so that most of it is cut off. But in a graphics program it is the right size! I am so confused and really stuck.

 

[ZmrAbdulla]

Did you try to resizing the image by a graphics program and re-assigning to the report? You can't resize it in Access.

Set margin to maximum area.

Also it is not relevent here but related to images in Access; You have to right click the image and choose change to image to reduce the file size.

Zameer Abdulla
_{Jack of Visual Basic Programming, Master in Dining & Sleeping}
Visit Me

 

[aw23]

If I use a report instead of a form then how does it work with form view? There isn't any? Is it only in design view? But the the user sees all the controls? I have never used reports before.

 

[aw23]

I finally got the graphic as a background. The only problem is that the print quality is not great. So what I'd like to do is leave it as the background and fill in the controls. Then allow the user to edit it (with the background so that they can see what they are editing). Then when I print it I don't want any background, I will feed the paper with the graphic into the printer. So essentially I want to remove the graphic before the user prints, but without the user seeing. Is this in anyway possible? So the graphic is there when editing but it doesn't print out, only the controls do. Thanks

 

[ZmrAbdulla]

There is no form View for reports there is Print preview instead. Unlike forms in report you can't edit anything but view the data.
You can design everything in the design view of the report as you design in the form. So once the user have a form to view the details & and print button he can print/preview this report.

Zameer Abdulla
_{Jack of Visual Basic Programming, Master in Dining & Sleeping}
Visit Me

 

[aw23]

OK, so I think I will use a form then, thanks!

 

[aw23]

Any ideas on how to slove the printing problem?
Thanks

 

[aw23]

One more question.
How can the user print it?
The toolbars aren't up there. Can I create my own like in VB?
Thanks

 

[ZmrAbdulla]

The printing problem is due to you are linking the picture as the backgorund of the form.(even it is embedded)
Open your image with MS Paint Ctrl+A , Ctrl+C (As you know) then paste it on the form.
[ul]
[li] Change the boarder style of the image [/li]
[li] Reduce the width & height of the form to fit the image only. [/li]
[/ul]
You will not get the printing error then. If you are using the picture as background then the picture will be relocating the as the form resizes.
Also take a trial on Bound Object frame & Unbound Object frame to see the difference.

Zameer Abdulla
_{Jack of Visual Basic Programming, Master in Dining & Sleeping}
Visit Me

 

[aw23]

No, I apologize I am not having that error anymore. What I mean is that there are no toolbars so there is no option for the user to print. How can I create the option?

 

[ZmrAbdulla]

There are many options from menu and code. Below some examples[ul]
[li] File > Print from the Menu Bar [/li]
[li] Printer Icon on the Form View Toolbar [/li]
[li] DoCmd.PrintOut[/li]
[li] DoCmd.RunCommand acCmdPrint[/li]
[/ul]

Zameer Abdulla
_{Jack of Visual Basic Programming, Master in Dining & Sleeping}
Visit Me