Hello ladies and gents,

I just need to know if it is possible to make a code or someting that sends a report by email in a certian time? I asked before and searched on the forum, but other similar question had no answer, so I just would like to know if some one knows if it can or can not be done. That way I can stop trying to figure it out or follows someones code thats done it, and finaly get a peice of mind!! You know what I mean?!! I think you do!!!:)

Thank you

DaniBoy

You should read through the following.

Obviously, you will have to adjust for sendobject rather than printing a report as most of these are.

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=29757&highlight=print+report+timer+event

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=24252&highlight=print+report+timer+event

Thus, I would say "Yes"

Hello,
I tried the on timer event and its not working!!!! this is the code

Private Sub Form_Timer()
If Timer > TimeSerial(12, 13, 0) Then
MsgBox "Its Working"
End If
Me.Timer = 0
End Sub

I set the timer interval to 5000 like the other thread says, and then I set the timeserial to what ever time I want. When it gets to that time, i get a :

Compile Error

Method or Data menber not found

and the the Me.Timer = 0 the ".Timer =" is in grey "Blocked"

What am I doing wrong?

Thanks

DaniBoy