PRINTING INVOICES FROM ACCESS

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have my client database in Access 2000. I would like to be able to design
an invoice that I can print. Ideally, I would like to have just the data
appear on a preprinted form because I am located in Mexico and it has to be
in Spanish.
 
Cabo create a report and set the fields you would like to print on the
report delete the labels (Align ect...) from the form creat a command button
and use the following code *** SomeReportname is the name of your report
UniqueField is the field you identify the records with example
InvoiceNumber

Dim strDocName As String
Dim strWhere As String
strDocName = "SomeReportname"
strWhere = "[uniqueField]=""" & Me!uniqueField & """"
DoCmd.OpenReport strDocName, acPreview, , strWhere
 
Back
Top