Jegajothy vythilingam
asked on
Access 2016 - Labels prompt to print
My OS is win 10 pro 64 bit and I have Office 365 and use Access 2016.
I want to print labels with the user to type the label Id, which is a numb and integer. The Report which is a label for printing on Avery 5162. Thus I want to print as many labels as I want to when the query runs and displays the prompt, like : Enter the IDs that u want to print.
Has anyone the code on how to achieve this.
And since the avery sheet may have used up, say 2 rows of the labels thus only from the 3rd row only is available to print.
Is there any sample report and query for this? thank u and regards.
I want to print labels with the user to type the label Id, which is a numb and integer. The Report which is a label for printing on Avery 5162. Thus I want to print as many labels as I want to when the query runs and displays the prompt, like : Enter the IDs that u want to print.
Has anyone the code on how to achieve this.
And since the avery sheet may have used up, say 2 rows of the labels thus only from the 3rd row only is available to print.
Is there any sample report and query for this? thank u and regards.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thank u, this is what I was looking for. But is there any where the actual vb code for it?
ASKER