Hi,
I have a word document which is a template for printing out labels. Instead of printing the document and writing in serial numbers I created an access database and used it's autonumber facility.
I also have another drop down list which the user can select parts from.
The word document consists of 16 labels in two rows of eight. I have copied this into a report and dragged the autonumber and part which the user enters on the database into the report. I have set up the report to ask the user what numbers to enter, eg 1 to 16, 16 to 20 etc.
When I go to print this report it is coming out on a number of pages, I need to have all the data on one page.
Is there a way of directly matching word documents into access and then adding two pieces of information using access?
Thanks
Novice
I have a word document which is a template for printing out labels. Instead of printing the document and writing in serial numbers I created an access database and used it's autonumber facility.
I also have another drop down list which the user can select parts from.
The word document consists of 16 labels in two rows of eight. I have copied this into a report and dragged the autonumber and part which the user enters on the database into the report. I have set up the report to ask the user what numbers to enter, eg 1 to 16, 16 to 20 etc.
When I go to print this report it is coming out on a number of pages, I need to have all the data on one page.
Is there a way of directly matching word documents into access and then adding two pieces of information using access?
Thanks
Novice