automate Label Reports in MS Access

[marvel]

VBA newbie!

Using VBA how would I go about creating a macro that would create a label report (using L7416 10-L for example) and autofill in data that would increment from DP00001, DP00002 and so on...

thanks

 

[highandwild]

Hi

Do you always want to print the same sequence e.g. DP00001 to DP001000 or do you want to specify when producing the labels what numbers to start and end with?

Are the numbers in a database table already?

Justin

 

[marvel]

thanks for the reply I would like the for DP00001 to increment...we are using labels to identify PCs starting with 00001 then 00002 and 3,4, up to DP99999....now it wont be that many PCs so maybe fill a few print pages.... the numbers are not in a table....

 

[highandwild]

I am not sure about your level of competance but to safe i would say
create a table with one field, e.g. [labeldata], in it and populate it with all values fom DP00001 to DP99999. This can best be done by creating the data in a spreadsheet and importing it into Access.

All you then have to do is query this table and use this as the data source for the labels.

 

[marvel]

Ok..ill start with that...with that said...how would I go about printing out a fresh "batch" of DP#####s on the labels...for example I printed out a set of labels ranging from DP00001 to DP00100(or whatever equals two pages worth)...now I come back later to print the next set DP00101 to DP00200...I would like it to pick up where it left off type of thing. Is that possible?

 

[highandwild]

Anything is possible with a certain amount of coding.

Either you remember where you left off or the database has to record where you left off and start with the next label when asked to print labels again.

Maybe it would be easier to set up a label mail merge in MS Word based upon
data in a spreadsheet. This would be a two minute or less job each time labels were required. There does come a time when the time spent automating something is disproportionate to the benefit gained.