We print a ton of labels using Access 2007/2010. We set up both single label and multi-label printing as an Access report (the wizard will get you started). You have to adjust it to print correctly. We print on both sheets of labels (30 address labels) and single labels using a Dymo label printer. The label report is tied to a query which controls the number to be printed. We just tag the records that we want labels for and then run an update query to reset the tags when the labels have been printed. Works great.
Another option is printing to a printer like the Zebra LP 2844. You can get them pretty cheaply on eBay and you don't have to worry about skipping labels. The printer is a thermal label printer and it is very easy to use with Access or any other program.
I have no affiliation with Zebra, but I do have quite a bit of experience using one and it is much easier to set up and use than sheets of labels (which I have also used with Access).
Managed to find the label report (and corresponding labels) but I was wondering if there is a way to print a single record on a label and also choose which label in the sheet you are printing on (instead of being the first label on the sheet, top left)......?