How can I print screen a report? I need immediate help!! Please

  • Thread starter I need immediate help!! Please
  • Start date
I

I need immediate help!! Please

Hello,

I want to create a button on a form that will print that form as report.


Is this possible?
 
R

Rick B

Forms are not designed to be printed. You should build a report and tie that to a button. You can even use the form and "save it as a report" then open it in design-view and clean it up. Below is some code to tie to the button so that only the currently-displayed record is included on the report.

If you really want to just print the screen. I believe pressing CTRL+PRINT SCREEN will do so. I know that ALT+PRINT SCREEN will capture the current window and place it in the clipboard.

Button to print specific record
Private Sub cmdPrint_Click()

Dim strWhere As String

If Me.Dirty Then 'Save any edits.

Me.Dirty = False

End If

If Me.NewRecord Then 'Check there is a record to print

MsgBox "Select a record to print"

Else

strWhere = "[ID] = " & Me.[ID]

DoCmd.OpenReport "MyReport", acViewPreview, , strWhere

End If

End Sub



Notes: If your primary key is a Text type field (not a Number type field), you need extra quotes: strWhere = "[ID] = """ & Me.[ID] & """"

If you want the report to print without preview, replace acViewPreview with acViewNormal.



See also: http://allenbrowne.com/casu-15.html
 
C

Coleen

Hi Rick - thanks for answering this post - I am having the same issues. I have created a report and have a button to preview it from the form - this works great. My users do want the report to open to the record they have just entered.

I tried your code and get and error that "Microsoft Access can't find the field '|' referred to in your expression. I'm running the report off a query not a table, will that make a difference?

I also tried a docmd.gotorecord, last, but could not get that to work either...

TIA,

Coleen
"Rick B" <Anonymous> wrote in message Forms are not designed to be printed. You should build a report and tie that to a button. You can even use the form and "save it as a report" then open it in design-view and clean it up. Below is some code to tie to the button so that only the currently-displayed record is included on the report.

If you really want to just print the screen. I believe pressing CTRL+PRINT SCREEN will do so. I know that ALT+PRINT SCREEN will capture the current window and place it in the clipboard.

Button to print specific record
Private Sub cmdPrint_Click()

Dim strWhere As String

If Me.Dirty Then 'Save any edits.

Me.Dirty = False

End If

If Me.NewRecord Then 'Check there is a record to print

MsgBox "Select a record to print"

Else

strWhere = "[ID] = " & Me.[ID]

DoCmd.OpenReport "MyReport", acViewPreview, , strWhere

End If

End Sub



Notes: If your primary key is a Text type field (not a Number type field), you need extra quotes: strWhere = "[ID] = """ & Me.[ID] & """"

If you want the report to print without preview, replace acViewPreview with acViewNormal.



See also: http://allenbrowne.com/casu-15.html
 
L

Larry Linson

Did you change the Field Name "[ID]" in Rick's code to the corresponding
unique identifier of your record? The Control on the Form where the Field
[ID] is displayed should have a different name than the Field that is its
Control Source, to avoid confusion.

Larry Linson
Microsoft Access MVP


Hi Rick - thanks for answering this post - I am having the same issues. I
have created a report and have a button to preview it from the form - this
works great. My users do want the report to open to the record they have
just entered.

I tried your code and get and error that "Microsoft Access can't find the
field '|' referred to in your expression. I'm running the report off a query
not a table, will that make a difference?

I also tried a docmd.gotorecord, last, but could not get that to work
either...

TIA,

Coleen
"Rick B" <Anonymous> wrote in message
Forms are not designed to be printed. You should build a report and tie
that to a button. You can even use the form and "save it as a report" then
open it in design-view and clean it up. Below is some code to tie to the
button so that only the currently-displayed record is included on the
report.

If you really want to just print the screen. I believe pressing
CTRL+PRINT SCREEN will do so. I know that ALT+PRINT SCREEN will capture the
current window and place it in the clipboard.

Button to print specific record
Private Sub cmdPrint_Click()

Dim strWhere As String

If Me.Dirty Then 'Save any edits.

Me.Dirty = False

End If

If Me.NewRecord Then 'Check there is a record to print

MsgBox "Select a record to print"

Else

strWhere = "[ID] = " & Me.[ID]

DoCmd.OpenReport "MyReport", acViewPreview, , strWhere

End If

End Sub



Notes: If your primary key is a Text type field (not a Number type
field), you need extra quotes: strWhere = "[ID] = """ & Me.[ID] & """"

If you want the report to print without preview, replace acViewPreview
with acViewNormal.



See also: http://allenbrowne.com/casu-15.html




--
Rick B



"I need immediate help!! Please" <I need immediate help!!
(e-mail address removed)> wrote in message
news:[email protected]...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Program buttons to create a word document 0
Is there any place I can get screen shots of Outlook Web Mail screens with notations? 0
Access 2002 change report header text 0
Page numbering with Merged Document and IF statements 1
How can I give customized drop down in Ms Forms online or refer dropdown from excel list 0
I need to place a rule between columns 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Request Form - Alert Team Member 0

Top