error message

[azhar2006]

Hello, men
When you call this function with an event the time


Show me an error message

Private Sub Form_Timer()
Call Backup("c:\Test\202.mdb", "c:\Test\ds\az.mdb")
End Sub

Public Sub Backup(strSource As String, strTarget As String)
'creates a copy of whatever file you want to whatever folder you want, overwrites if already there
Dim fso As Object, fsoBackup As Object
Dim tempDate As Variant
Set fso = CreateObject("scripting.filesystemobject")  'set our filesystem object
If fso.FileExists(strTarget) Then   'if target does exist
    Set fsoBackup = fso.getfile(strTarget)  'set target variable
    tempDate = DateAdd("d", 1, fsoBackup.DateCreated)   'add whatever length of time to check (daily, hourly, etc.)
    If Now() >= tempDate Then 'check if now is later than the date/time we want to copy it over next
        fso.deletefile strTarget 'delete target to reset datecreated property
        fso.copyfile strSource, strTarget 'copy source to target
    End If
Else
    fso.copyfile strSource, strTarget  'if target doesn't exist, immediately create backup
End If
End Sub

[pbaldy]

What's the error message?

[ItsMe]

If I recall correctly, the Form_Timer event property is for adjusting the Form's Timer property and is not used as an Event Handler.

If you want to call a function or procedure, perhaps the Form_Load event handler is more appropriate.

[pbaldy]

You can have code in the timer event. Perhaps you're thinking of the timer interval property.

[ItsMe]

I, most likely, am.

[azhar2006]

Thank you Professors
simple backup utility that I thought I would share.

[ItsMe]

Are you still having problems with this?

[azhar2006]

Yes I can not
an example of the application

[pbaldy]

Again, what is the error message?

[azhar2006]

Thank you pbaldy for the follow-up Thread This is the message

[pbaldy]

If you named the module the same as the sub, you can't.

[azhar2006]

Thank you pbaldy
How, do you explain more

[pbaldy]

It sounds like you've named the module itself "Backup", rather than just the sub shown above. Look in the VBA editor on the left side and see what's listed under "Modules".

[azhar2006]

Yes This is the image module

[pbaldy]

I don't know how to say it any clearer. They (the module and the sub) CAN'T have the same name. Change the name of the module.