Create SnapShot File on Deactivate.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
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
 
Back
Top