Send email report on certian date

[unluckytoe]

Bob:

The trusted locations was blank, so I added the directories and still nothing. Nothing fires.

Brian

 

[boblarson]

Well, it might have corruption. See what happens if you import everything into a new, blank file. You could also try uploading here and we can see if it has that problem for us.

 

[unluckytoe]

Bob:

Well, importing it into a new container didn't work. I had to remove a lot of stuff from my DB just to upload it, but here it is. It's not pretty.

Brian

 

[boblarson]

Well, I'll have to look more later. I have to run. But my intial opening of the form showed it ran (set a breakpoint on the IF). So, you might set a breakpoint on the IF in the Timer and see if it stops there. If it does then the rest of your code in that event is likely the suspect.

 

[unluckytoe]

Bob:

Ok, let me know more when you can, I don't know how to set a break point...I'm still very new at this. Again, thank you so much for your time.

Brian

 

[boblarson]

Bob:

Ok, let me know more when you can, I don't know how to set a break point...I'm still very new at this. Again, thank you so much for your time.

Brian

Well here's how to set a breakpoint.

 

[bradford8481]

Test your code to see if it works.
Try nthis...

msgbox "Environ('computername') = " & "WALSH-BMOORE"

 

[unluckytoe]

Bob:

I followed the web page and it works now. I haven't tested the "environ" part yet, but I have another question. Would making this into a module work better, and then have the hidden form timer call it? Im not sure if I'm asking the right question or not. I just want to make sure that this wont happen again (although knowing my luck it will!)

EDIT: I just applied your environ code and it still works, I'll test it on another machine later today.

Again, thank you for your help!

Brian

 

[unluckytoe]

Bob:

This is fantastic! It works perfectly on both machines! I'm so happy. Again, I can't thank you enough. You're Awesome!

Brian

 

[boblarson]

Glad we could help