| | |
|
|
|
Printing a From??? |
|---|
| message from Wolfe on 17 May 2004 |
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
|
| Brian Kastel replied to Wolfe on 24 May 2004 |
Why not use the control wizard to create a command button that prints the
form (Form Operations --> Print Form)? Or did I miss something?
"Wolfe" <Wolfe@Wild.web> wrote in message
news:Xns94EC94EA5214AWolfe@140.99.99.130...
|
| fredg replied to Wolfe on 17 May 2004 |
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.
|
| Wolfe replied to fredg on 17 May 2004 |
This I know, but the end users who will be using this application need
every thing done for them. Standard end user crap.
WOLFE
|
| Cheryl Fischer replied to Wolfe on 17 May 2004 |
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,
|
| =?Utf-8?B?Um9zY28=?= replied to Cheryl Fischer on 18 May 2004 |
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
|
| Wolfe replied to =?Utf-8?B?Um9zY28=?= on 18 May 2004 |
Thanks for all the help.
|
|
Archived message: Printing a From??? (Microsoft Access Error Message)
