Print record displayed on screen in a report

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

I am fairly inexperienced in Access, but have been asked
to design a database for my company.

Within this database I have a table "Berks Dss Info" and a
form "Berks Dss Info". The table contains information
about a person who is claiming benefit.

I would like a button to be present at the bottom of the
form which prints two copies of a report - for the
specific record, or person, that is displayed on screen.

How can I do this?
 
Without knowing the names of your report, field, etc, it would be hard to
give you a specific answer. Here is code from my application that prints an
employee worksheet based on the current UserID. You can copy it and change
the names. I don't think there is a way to specify 2 copies in code.


Private Sub Print_Button_Click()
If (IsNull([UserID])) Then
' If no employee selected, stop procedure
Exit Sub
End If
DoCmd.OpenReport "Admin - Employee Worksheet", acViewNormal, "",
"[UserID]=Forms![frmSINEmpDataMaintenance]![UserID]"
End Sub



Rick B


I am fairly inexperienced in Access, but have been asked
to design a database for my company.

Within this database I have a table "Berks Dss Info" and a
form "Berks Dss Info". The table contains information
about a person who is claiming benefit.

I would like a button to be present at the bottom of the
form which prints two copies of a report - for the
specific record, or person, that is displayed on screen.

How can I do this?
 
On the two copies thing, if this report is only used for this purpose, you
coud simply include a page break and a second instance of all the fields in
your report design. In other words, just make your report two pages long
with the same data on each page.

Rick B


I am fairly inexperienced in Access, but have been asked
to design a database for my company.

Within this database I have a table "Berks Dss Info" and a
form "Berks Dss Info". The table contains information
about a person who is claiming benefit.

I would like a button to be present at the bottom of the
form which prints two copies of a report - for the
specific record, or person, that is displayed on screen.

How can I do this?
 
Back
Top