How do I skip used mailing labels and print dublicates in Access 2

[carlos1261]

I have been using a Visual Basic code that I located on a Microsoft support
site that allowed me to skip labels and print duplicates for a label report
that I created in an Access 2003.

I recently upgraded to Access 2007 and now the VB code no longer works as it
had in Access 2003. I get the following error message:

The expression On Open you entered as the event property setting produced
the following error: The expression you entered has a function name that
Microfsoft Office Access can't find.

I've looked for another pre-written code that will do the same thing to no
avail. I know nothing when it comes to Visual Basic and I was relying on this
code! Anyone have any ideas?

Thanks!

 

[Klatuu]

What is the funtion it can't find?
Have you check the References in VBA to be sure all you need are there?

 

[carlos1261]

Thank you for your quick response.

The error message doesn't specify what function it is looking for. The
function I have in the On Open property is "=LabelSetup()" which is what the
original Microsoft support info says to put in that place.

In the VBA code that "function" is in there as written is spelled correctly
in the (General) LabelSetup section .

Not sure what you're referring to when you ask about REFERENCES. I did find
"References" in the "Tools" drop down menus on the VBA screen but did not
feel brave enough to make any changes.

Carlos

 

[Klatuu]

Where is the code for the LabelSetup() function? In the report or in a
standard module?

 

[carlos1261]

it is in the VBA code which is attaced in the Property Sheet, On Format, and
[Event Procedure]. this is where the Microsoft support site instructed me to
put it when I found it for Access 2003.

Here is the link to the original source where I found the VBA code. I simply
cut and pasted it into my Access 2003 program that I wrote. But now I need to
use it in Access 2007 but as I've said, it won't work the same.

http://support.microsoft.com/default.aspx?scid=kb;en-us;95806&Product=acc

Carlos

 

[Klatuu]

I read the site. This should all be in a report.
--
Dave Hargis, Microsoft Access MVP

it is in the VBA code which is attaced in the Property Sheet, On Format, and
[Event Procedure]. this is where the Microsoft support site instructed me to
put it when I found it for Access 2003.

Here is the link to the original source where I found the VBA code. I simply
cut and pasted it into my Access 2003 program that I wrote. But now I need to
use it in Access 2007 but as I've said, it won't work the same.

http://support.microsoft.com/default.aspx?scid=kb;en-us;95806&Product=acc

Carlos

Where is the code for the LabelSetup() function? In the report or in a
standard module?

 

[carlos1261]

what do you mean by that? i placed it in Access 2007 in the exact same
location and in the exact same manner that i placed it in Access 2003. it's a
mystery to me why it worked correctly in 2003 but it won't work in 2007.

Carlos

I read the site. This should all be in a report.
--
Dave Hargis, Microsoft Access MVP

it is in the VBA code which is attaced in the Property Sheet, On Format, and
[Event Procedure]. this is where the Microsoft support site instructed me to
put it when I found it for Access 2003.

Here is the link to the original source where I found the VBA code. I simply
cut and pasted it into my Access 2003 program that I wrote. But now I need to
use it in Access 2007 but as I've said, it won't work the same.

http://support.microsoft.com/default.aspx?scid=kb;en-us;95806&Product=acc

Carlos

Where is the code for the LabelSetup() function? In the report or in a
standard module?
--
Dave Hargis, Microsoft Access MVP


:

Thank you for your quick response.

The error message doesn't specify what function it is looking for. The
function I have in the On Open property is "=LabelSetup()" which is what the
original Microsoft support info says to put in that place.

In the VBA code that "function" is in there as written is spelled correctly
in the (General) LabelSetup section .

Not sure what you're referring to when you ask about REFERENCES. I did find
"References" in the "Tools" drop down menus on the VBA screen but did not
feel brave enough to make any changes.

Carlos

:

What is the funtion it can't find?
Have you check the References in VBA to be sure all you need are there?
--
Dave Hargis, Microsoft Access MVP


:

I have been using a Visual Basic code that I located on a Microsoft support
site that allowed me to skip labels and print duplicates for a label report
that I created in an Access 2003.

I recently upgraded to Access 2007 and now the VB code no longer works as it
had in Access 2003. I get the following error message:

The expression On Open you entered as the event property setting produced
the following error: The expression you entered has a function name that
Microfsoft Office Access can't find.

I've looked for another pre-written code that will do the same thing to no
avail. I know nothing when it comes to Visual Basic and I was relying on this
code! Anyone have any ideas?

Thanks!