How to create Invoice?

[kathnicole]

Hi All,

i am using MS Access 2003 and i need to know how generate an invoice in ms word from Access database with the invoice date to be the same.

for example, the invoice consists of the fields frm tableJob like :
InvoiceDate, JobDescription, CompanyName,Add ress,SubTotal,G ST,Total

when the date is generated on 20/02/2007, it has to be the same when the user come and visit after 2 weeks.

i need to know how to maintain the same date all the time for a particular invoice and how to extract particulat fields from a particular record and produce the results in a word document.

Need some assistance.

thanks and regards,
Kathy

[mattkorguk]

Hi there,
If you've already created the report, there is a "outputto" command to help you out with this.
(Here's one I put together earlier...)

On Error Resume Next
Kill "C:\Sales Quality\MI-Summary.rtf"
Dim stDocName As String
stDocName = "rptMI-Summary"
DoCmd.OutputTo acReport, stDocName, acFormatRTF, "C:\Sales Quality\MI-Summary.rtf"
MsgBox "A Word document (MI-Summary.rtf) has been created in the following folder C:\Sales Quality", vbOKOnly, "Data Export"

Hope this helps!?
Matt

[kathnicole]

Hi,

thanks for your reply.

I am a beginner in VBA . could you please explain bit more of what i should do?

i want a button "Invoice" in the Form 'Job' and must take the respective fields from the Job record to generate an Invoice

thanks and regards,
Kathy