On Fri, 12 Dec 2008 10:40:01 -0800, Claire wrote:

I am running a label report in Access 2007 and entered this code for the
event procedure for the report header and the detail, and like JimH, have no
luck. It prints with the label in the 0 position. I tried to add a
breakpoint to watch the code, and though I could get it on the VBA page
(highlighted with a bullet to the left), I do not know how to find what the
values were. I hovered over the VBA page after running the report, but the
report itself just runs without any sort of indications. Does this code not
work in 2007? Is there something special that 07 wants? Am I just going
crazy?

Thanks,
Claire

"jinh" wrote:


"fredg" wrote:

*** snipped ***

Thanks again! I followed your steps to set a breakpoint. But nothing
happen after I entered 2 in the [Skip How Many?] box. It just take me to the
report. Any other idea? Should I email you the whole access database?
Please let me know.

Thanks again in advance!

Are you using Access 2000 or 2002?
Are you using Access 2003?
Saving data in the 2000 or 2002 format?
Alright, you twisted my arm. ;-)

Access 2007? Sorry, I have no way off running it as is.
Perhaps you can Convert it into an earlier version... Tools + Database
Utilities + Convert Database to 2002 version.

It the Database is small, you can send it as is.
If the database is large, strip everything out that is not needed to
run the label report. All I need is enough records to print 2 pages of
labels, or fewer.
Compact the database to make sure it compiles. Try it before sending
it. No need to Zip the file. Make sure it does not have workgroup
security so that I can open it.
Send it to

jandf
at
roadrunner.
com

I'm sure you can properly reconstruct that address.
MAKE SURE you write, as the subject line:
"Skip Labels"
otherwise I will never see it.
I'll reply here in the newsgroup.

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail


Hi Fred,

I'm running access 2007. I've email the attached to you. Please let me know.

Thanks,

I remember this original post as he originally sent me the database in
Access 2007 format and I wasn't able to open it, however I don't
remember the outcome. It wasn't the code.
If you found this old post perhaps you can go back and see if there is
a follow-up reply sent AFTER I looked at his database.

If you care to send me your database, I'll be happy to look at it. It
MUST be sent as an Access 2000 MDB format, which is one of the options
available in Tools + Database Utilities + Convert Database.
Strip everything out of the database that is not needed to run the
label report. I'll get back to you here in the newsgroup.
Send it to

jandf
at
roadrunner
dot
com

Make sure you write "Skip Labels" as the Subject line, otherwise I
will never see it.

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail