Printing a From???

W

Wolfe

Is there an easy way to print an Access form? The form has a header section
and detail section. The detail section contains three sub forms that pull
off of the header section. What I would like to do is kind of a screen shot
when a user clicks a print button.

Thanks,
WOLFE
 
F

fredg

Is there an easy way to print an Access form? The form has a header section
and detail section. The detail section contains three sub forms that pull
off of the header section. What I would like to do is kind of a screen shot
when a user clicks a print button.

Thanks,
WOLFE
Click to expand...

To get a "screen shot" of your form simply press Shift + Print Screen.
Then open any picture program (i.e. MSPaint, PhotoEd, etc.), or a Word
document, Excel spreadsheet, or an Access report and Paste the image
into it. You can print the image from there.
 
W

Wolfe

This I know, but the end users who will be using this application need
every thing done for them. Standard end user crap.

WOLFE
 
C

Cheryl Fischer

If you're certain that your users cannot handle the PrtScrn and Paste
routine, then you can create an Access report with sub-reports. Then, they
can click a Print button and print the report.

You could use code like the following to have the report open for the same
record as your form. For example, if the current record on your form was
for a particular customer, you could use the CustID field to determine the
where condition as follows:

Dim strCriteria As String

' This works when your matching field is text
strCriteria = "[CustID] = " & Chr(34) & Me!CustID & Chr(34)
DoCmd.OpenReport "MyReport", acViewNormal, , strCriteria

' This works when your matching field is a number
strCriteria = "[CustID] = " & Me!CustID
DoCmd.OpenReport "MyReport", acViewNormal, , strCriteria

hth,
 
R

Rosco

You could also install screen shot print utility on your users PCs. This software makes the print screen key actually print to a printer without doing the copy/paste routine. There are quite a few freeware print screen utlities out there. Just do a google search
Rosco
 
B

Brian Kastel

Why not use the control wizard to create a command button that prints the
form (Form Operations --> Print Form)? Or did I miss something?
 
Top