By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,921 Members | 1,466 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,921 IT Pros & Developers. It's quick & easy.

How to create Invoice?

P: 33
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,Address,SubTotal,GST,To tal

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,
Jul 16 '07 #1
Share this Question
Share on Google+
2 Replies

P: 28
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!?
Jul 16 '07 #2

P: 33

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,
Jul 18 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.