Trying to print Access labels in rows other than the first

teresedp · Post by **teresedp** » 22 Dec 2010, 01:46

Hi--I am trying to get Access to print labels starting in a different row than the first (to use up partial sheets of labels). A compacted version of the database is attached. Please note that this was the first database I ever wrote; I still use it because it serves its function but I would do some things differently now that I know more about Access!

When I posted this request on another forum, someone tried to help but nothing worked. They referred me to the MS Knowledge Base article
http://support.microsoft.com/kb/299024 . I am not an Access beginner any more but am still very new to VBA.

I pasted the code from the KB article into a VB Standard module in the database (mdl1 in the attached) and tried to call the procedures from events in a report as the KB article instructed.

When the OnOpen event of the report ("Copy of rptSecondaryLabels") attempts to call the function LabelSetup() from the module, I get an error message

"Microsoft Office Access cannot find the object '=LabelSetup().' "

So far, I have (1) compacted and repaired the database, (2) deleted, repasted and recompiled the code in a Standard module (more than once), (3) made sure the spelling in the event property calling the function and the name of the function in the code are exactly the same.

The "label printing report" that works without any code (but can only print starting in row 1, column 1) is rptSecondaryLabels.

Thank you,
teresedp

Post by **HansV** » 22 Dec 2010, 10:40

Welcome to Eileen's Lounge!

There was a space before =LabelSetup(), this extra space caused Access not to recognize the name.

I entered the expressions anew, and then the report worked.

I have attached the database with the working report.

CCLstripped.zip

teresedp · Post by **teresedp** » 22 Dec 2010, 23:24

Works like a charm. Thanks so much for all of your help. I did not know that there was even a space in the Event property calling the function!

I appreciate all of your time. Best regards and happy holidays.

teresedp

Post by **HansV** » 22 Dec 2010, 23:30

You're welcome!

Best wishes to you too!

Eileen's Lounge

Trying to print Access labels in rows other than the first

Trying to print Access labels in rows other than the first

Re: Trying to print Access labels in rows other than the fir

Re: Trying to print Access labels in rows other than the fir

Re: Trying to print Access labels in rows other than the fir