Printing a From???

  • Thread starter Thread starter Wolfe
  • Start date Start date
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
 
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.
 
This I know, but the end users who will be using this application need
every thing done for them. Standard end user crap.

WOLFE
 
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,
 
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
 
Why not use the control wizard to create a command button that prints the
form (Form Operations --> Print Form)? Or did I miss something?
 
Back
Top