Create SnapShot File on Deactivate.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bill Barber - 19 Dec 2005 23:01 GMT

When I view my University Labels File and go to close it I want to create a
SnapShot file.

On DeActivate I have the following code. This code fails without a halt or
message. Does anyone know what I am doing wrong?

DoCmd.OutputTo acReport, "LabelsUNV", "Snapshot(*.snp)", "LabelsUNV", True

Also it keeps opening the Access Report Program, not the Snapshot viewer.

Thanks

Bill

Reply to this Message

GrandMaMa - 20 Dec 2005 23:32 GMT

Bill, Glad to talk to you again. My homework file is failing the same way.
Sometime between July and now something has happened! I tried about four
different things and none worked!

If you frind a solution get a hold of me. You might try removing True at
the end of your statement, I beleive this is the reason it will not close.
Well I guess the kids will be happy over the holidays.

> When I view my University Labels File and go to close it I want to create a
> SnapShot file.
[quoted text clipped - 9 lines]
>
> Bill

Reply to this Message

Len - 21 Dec 2005 02:32 GMT

Bill and Grandma;

Correct code is DoCmd.OutputTo acReport, "LabelsUNV", acFormatSNP,
"C:\YourDirectory\LabelsUNV.snp"

The above statement will work on 2002(XP) and 2003. It will not work on 97!
I do not know about 2000.

Do not feel bad, it was changed since 97.

Good Luck

Len

> Bill, Glad to talk to you again. My homework file is failing the same way.
> Sometime between July and now something has happened! I tried about four
[quoted text clipped - 17 lines]
> >
> > Bill

Reply to this Message