Create SnapShot File on Deactivate.

[Bill Barber]

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

 

[GrandMaMa]

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.

 

[Len]

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