Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Printing an invoice using vb6 and access
- Thread starter fareezf
- Start date
There are several ways to accomplish this and here is just a few.
You can create a form that will look like the final invoice with the data entry fields that you want and use Me.PrintForm (set me.backcolor = vbwhite prior to printing).
You can collect the information and...
use the printer object to draw the invoice to the printer.
use a reporting package like crystal reports to print the invoice out.
Good Luck
You could also use a datareport or use the Word object model
________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first
'People who live in windowed environments shouldn't cast pointers.'
________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first
'People who live in windowed environments shouldn't cast pointers.'
- Thread starter
- #4
Hi,
I cannot use the tip vb5prgrmr gave because I don't have Crystal Reports.
As for johnwm's tip please could you tell me whether I can acheive the following if I use the Word object model.
If I design the invoice in Word how do I retreive the proper data from the database table to the appropriate place in the Word?
Fareez...
I cannot use the tip vb5prgrmr gave because I don't have Crystal Reports.
As for johnwm's tip please could you tell me whether I can acheive the following if I use the Word object model.
If I design the invoice in Word how do I retreive the proper data from the database table to the appropriate place in the Word?
Fareez...
1. Design your invoice in Word, inserting Bookmarks where each datafield will go.
2. Step through the recordset inserting fields into the appropriate bookmarks.
For further details do a Keyword Search (tab at top of this page) for 'Word model', 'Exact phrase' in this forum and in forum222 as the details have been done several times
________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first
'People who live in windowed environments shouldn't cast pointers.'
2. Step through the recordset inserting fields into the appropriate bookmarks.
For further details do a Keyword Search (tab at top of this page) for 'Word model', 'Exact phrase' in this forum and in forum222 as the details have been done several times
________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first
'People who live in windowed environments shouldn't cast pointers.'
- Thread starter
- #6
Johnwm,
Sorry to trouble you again but I did a keyword search on 'word model' and nothing came but I visited the thread and found some tips. But all of them showed how to open a word or print a word app from vb.
I opened a word document and inserted some bookmarks. But I am clueless as to how I can get the data from my access table and put it in those bookmarks. In the bookmarks do I have to set a formula? Could you please help me because I have seen your name in most of the complicated cases and how you have helped the other guys.
Sorry to trouble you again but I did a keyword search on 'word model' and nothing came but I visited the thread and found some tips. But all of them showed how to open a word or print a word app from vb.
I opened a word document and inserted some bookmarks. But I am clueless as to how I can get the data from my access table and put it in those bookmarks. In the bookmarks do I have to set a formula? Could you please help me because I have seen your name in most of the complicated cases and how you have helped the other guys.
I've just had a quick look through some old posts. thread222-678481 discusses opening a copy of Word. thread709-623084 gives details of inserting data into a table in a Word doc from VB
Start with these and see how you get on.
________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first
'People who live in windowed environments shouldn't cast pointers.'
Start with these and see how you get on.
________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first
'People who live in windowed environments shouldn't cast pointers.'
- Status
