I have a table that has columns for: Stock # (PK), Line 1, Line 2, Line 3, Line 4, Label 2 Line 1, Label 2 Line 2, Label 2 Line 3, Label 2 Line 4.
I already have it setup where it will print to the right page format using the Label Wizard (but only for one label per record). I would like to be able to ask a user for a Stock # and x (the number of labels needed), and for Access to print so many copies of one label if only lines 1-4 are used in the table, or so many copies of two labels if line 1-4 and Label 2 Lines 1-4 are used (Some records will need all identical labels, and some records need copies of two different labels).
Before it prints the labels, I would like it to ask the user: "Do you want to print x labels:" and then show the user what one (or one of each) label will look like on the screen. Then they can OK or Cancel.
Sorry if this is an easy question; I work more in Excel than Access.
Thanks for any help!!!
I already have it setup where it will print to the right page format using the Label Wizard (but only for one label per record). I would like to be able to ask a user for a Stock # and x (the number of labels needed), and for Access to print so many copies of one label if only lines 1-4 are used in the table, or so many copies of two labels if line 1-4 and Label 2 Lines 1-4 are used (Some records will need all identical labels, and some records need copies of two different labels).
Before it prints the labels, I would like it to ask the user: "Do you want to print x labels:" and then show the user what one (or one of each) label will look like on the screen. Then they can OK or Cancel.
Sorry if this is an easy question; I work more in Excel than Access.
Thanks for any help!!!