PRINTING INVOICES FROM ACCESS

  • Thread starter CABO COFFEE PATRICK
  • Start date
C

CABO COFFEE PATRICK

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.
 
T

terry

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
 
Top