Allow user to change where label starts

[spudracer]

I've got a report that spits out a barcoded label for items on my inventory. What I'd like to know, is if there is a way in 2010 to allow the user to select where on the page for the label to print.

I found a way that looks like it worked for 2007, but it required enabling ADO, which I am not able to do on my work computer.

 

[spudracer]

Do you mean you are using an A4 sheet of labels and you don't want to waste a whole sheet just printing one label?

Yes. I imagine it won't take long to have a bunch of label sheets with the first two or three labels missing.

 

[CJ_London]

surprised you can't implement ADO - you just need to add a library reference to Microsoft ActiveX Data Objects 2.8 library

Are you saying it is not available?

 

[spudracer]

We have a very restrictive network. I'll try again in the morning, but I had no luck today.

CJ_London: From what I could see today, yes. I didn't have the option to add it or any other add-in for that matter.

 

[spudracer]

Ok, I was able to enable it this morning. My question is, sense I'm not too familiar with the ADO reference, will it work on any computer now or will I have to enable it on every computer that uses this database?

 

[CJ_London]

no, it should just link. The only time you'll need to reference it again is if you create a new db and copy this routine to it

 

[spudracer]

If anyone else happens to want to change where labels print on a report, this link should help you. It worked perfectly for me. http://support.microsoft.com/kb/q95806