Automated backup

[ROMADOZ]

OK, still lost here. My limited understanding tells me that the function name is backupcopy() is that true? It is in the 2nd line... "Public function backupcopy()" Am I still misisng something?

 

[RuralGuy]

Your button code will be something like:

Private Sub btn_Exit_Click()
   On Error GoTo Err_btn_Exit_Click

   If Me.Dirty Then Me.Dirty = False
   [B][COLOR="Red"]BackupCopy[/COLOR][/B]
   DoCmd.Quit
Exit_btn_Exit_Click:
   Exit Sub
Err_btn_Exit_Click:
   MsgBox Err.Description
   Resume Exit_btn_Exit_Click

End Sub

What do you have now and what is happening?

 

[ROMADOZ]

I moved the backupcopy above the "If me.dirty" and now it works. I have to admit, I am not certain why... I think it may have something to do with the order access is processing the code. Thank you for all the help and patience, now I begin working on automation. How do I make an event run on it's own at a set time?

 

[RuralGuy]

Start a new thread with your latest question.