Search results

Yeah, post it and I will take a look.

No attachments here I'm afraid. You need to zip a DB first, then post it. Also you need to make sure you don't exceed the file size.

You could always unplug the speaker from the jumpers on the motherboard in your PC ;-)

I can't get the link ATM, because work won't let me on maddox.com. I think its entitled "That's right Jock, bag my groceries!". Very amusing.

Use an UPDATE query?

You need to use the "OutputTo" function in Access. This will output the results of your query. You can use Recordsets to get the value of your School for the filename. Search the forums for recordsets, there are lots of examples. You should be able to find all you need about the "OutputTo"...

LOL We can never avoid what we are destined to be :-)

Use "Between #[Start Date]# and #[End Date]#"

Use VBA in a module, and use the SendObject command.

You need to create a seperate table for the interior shots, and then reference this table to the Primary Key or your properties table.

Yes, OnLoad should do it. You can use a table to write a record of which emails were sent on which date. Id the table gets too big, you could always create a query to delete the old info on a weekly/monthly basis.

Yes you will need to have Access open to trigger the code. I would have the code triggered when the "Switchboard" form of your db was opened, then you just need to check that the email hasn't already been sent.

There is no COUNTIF in access, but you could put a field on your report which has IIF([Sample Text Field]="NO",1,0) make it invisible, then just use COUNT to get the number of occurences.

You've not given very much information for anyone to go on here. In order for a dap page to update, the table needs a Primary Key as far as I know. You could check this for a start.

You need to write some VBA to handle this. You can check the current date for which day of the week it is with the Weekday function. You can then use the SendObject command to send the email. Have you written any VBA before?

LOL. I believe hypocrisy is part of the human condition. Show me someone who claims never to be a hypocrite and I'll show you a liar.

...Bart Simpson I believe. I have something similar on my email disclaimer just to draw attention to how ridiculous they all are;

Not quite as annoying as shop assistants, waiters, delivery people who treat the people who pay their wages like dirt, IMHO. The last episode I had was waiting fourty minutes for in Tootsie's (their slogan is "The Best Burgers you ever tasted), for them to burn my burger. When it finally...

This was google's third result for Dan Brown;

Just googled him; the Da Vinci Code guy. So of the alleged three people who haven't read this, I am one, SJ is another, I wonder who the third is? The last book I read was "Life of Pi" by Yann Martel, I am currently reading "How To Lose Friends and Alienate People" by Toby Young (I saw him on...