Me + Access = badness

Dymetrie · 22-09-2006, 12:56

So I'm working on a little project at work at the moment. A nice happy little database to track Covert Camera installations.

I open Access and create a table.. Lovely, I write a macro to automatically calculate the Cancellation due date (installations can only go in for 3 months) and review dates for the installation. After some hitting things with hammers I get all that to work.

Now comes the fun part.

I want this database to automatically send out e-mails to remind Housing Officers of review dates. No problem, I get a nice little macro running which, when run, sends out an e-mail (the content at the moment is a load of tosh, I just want to get it working first of all).

Then I wrote a new Macro.

The Macro of EVIL!

If the review date of the installation is the same as today's date run e-mail macro... Simple...

It managed to spam out 97 e-mails before I managed to pull the plug

Methinks the exchange server at work is possibly a mite peeved at me now

Now comes a fun afternoon of trying to figure out what I ballsed up (I refuse to run that macro again without some kind of safeguard, like yanking the network cable out first) and to get it to run properly...

If anyone has any advice then it'd be more than welcome as my Access guru appears to be asleep today. (can't access forums when I'm meant to be working but e-mail works)

*runs off to spam some more e-mails*

22-09-2006, 12:56	#1
Dymetrie A large glass of Merlot Join Date: Jun 2006 Location: Letchworth with a Lightsaber Posts: 5,819	Me + Access = badness So I'm working on a little project at work at the moment. A nice happy little database to track Covert Camera installations. I open Access and create a table.. Lovely, I write a macro to automatically calculate the Cancellation due date (installations can only go in for 3 months) and review dates for the installation. After some hitting things with hammers I get all that to work. Now comes the fun part. I want this database to automatically send out e-mails to remind Housing Officers of review dates. No problem, I get a nice little macro running which, when run, sends out an e-mail (the content at the moment is a load of tosh, I just want to get it working first of all). Then I wrote a new Macro. The Macro of EVIL! If the review date of the installation is the same as today's date run e-mail macro... Simple... It managed to spam out 97 e-mails before I managed to pull the plug Methinks the exchange server at work is possibly a mite peeved at me now Now comes a fun afternoon of trying to figure out what I ballsed up (I refuse to run that macro again without some kind of safeguard, like yanking the network cable out first) and to get it to run properly... If anyone has any advice then it'd be more than welcome as my Access guru appears to be asleep today. (can't access forums when I'm meant to be working but e-mail works) runs off to spam some more e-mails __________________ Khef, Ka and Ka-Tet....