Search results

Try "file size" in the Answer Wizard of the VBA Help. Should give you all the info you need.

Use a Case Else at the end for anything not mentioned in the other cases.

OK, firstly, telnet is very unsecure. Your password is sent in plain text, so it would be very easy for anyone to "sniff" your username and password. If you are logging in from Windows, you can use "Putty" to log in via SSH, which is much more secure. Secondly, "whereis" is simply a unix...

Surely a SELECT CASE would work just fine?

Nope, sendmail is the program you use to actually send the email. The perl script doesn't actually send your email, it simply passes the details on to sendmail, or whichever mail program you have installed on your web server. If you have SSH access, you can simply log in and type whereis...

Have you checked that sendmail is correctly configured and working on your web server?

OK James, I am just on my way out of work now, so I will take a look at this tomorrow. Hmm, it seems I don't know anything about delete queries. I was sure I had done something very similar some time ago. It should be possible to do via some VBA, however I have a couple of questions first. Is...

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.