Search results

Emails work immediately if redirected via Gmail. This has happened before. The server supporting this site seems to refuse to send emails to some domains. It appears that the domain name of bigpond is currently rejected.

Email notification test 1. Chris.

You don’t seem to be saying where the resultant early bound code will be running; Excel or Access? Late binding might be slow but I don’t think I have ever seen anybody, including Microsoft, quantify it. Painful conversion to late binding only exists for those who have always taken the easy...

I can’t speak for other people but sometimes I put error handling in demos but mostly I don’t. For me the main reason for not including error handling in demos is because the demo is about something else other than error handling. It would only add clutter to the demo and in fact I would have...

Can someone please verify the above fault? The service packs involved are not mentioned. Also, “We deleted one of the duplicate locations, and all was well.” is insufficient testing. Under this circumstance, I would suggest the following as a minimum test… Delete the duplicate and test. Close...

Well, if the code doesn’t run it won’t work. Is the database in a trusted location? Does the event procedure have error handling which might bypass the code on error? If you want to close the Form then close it; but is it necessary to set Cancel = True? Chris.

Why would you want to fill a 3 year old thread with such nonsense? Start your own thread in a non-technical forum, I’m locking this one. Chris.

What does it have to do with the way this site displays dates? Chris.

Hi Kim. There are two basic ways to ‘draw’ on Forms and I suspect you may eventually want to reproduce it on Reports. Forms are more difficult than Reports because Access does not like using the draw commands available for Reports in Forms. Depends on what you want to ‘draw’ but one method is...

Claude. I deleted your other post on this matter, it was a duplicate. I do not think you are referring to the download available in this thread, least I hope not. It is too complicated and the screen real estate would not allow for an increase in size of the slider. That’s the reason I didn’t...

Cache user properties for speed. Forward: For far too long it has been said that Global variables lose their value on unhandled errors. Well, quite frankly, that is a load of rubbish but is still being said today. They don’t and never have under any error circumstance. What can happen is that...

Has been handled

This was written in Access97 under Windows 2000 and still works in Access2003 under XP. But "The Times they are a changin." Chris.

DrallocD. >>This will create an unhandled error Dialogue, click on End<< I/we have been saying that Globals do not lose their value on error under any circumstance. They get Reset by program operation. It is not the unhandled error which causes the Reset it’s the click on End. They are two...

DrallocD. There are a lot of wrong things said on the web about Access, but giving each user their own front end is not one of them. It should be expected that it is the case and failure to do so is inviting trouble. Hence, database properties apply only to the single user who is using the...

DrallocD. I do not think that is sufficient reason for your original reply. 1. You did not mention it and… 2. If you have users allowed to modify code then they should be qualified to test the code as other users are going to be using it. And so, back to the database properties… Database...

DrallocD. >>I use the same approach as you with a SessionID since the global variables are reset if there is an unhandled error and the user selects "End" in the Debug dialogue, or if there is a compile error in the debugger.<< If that is what you do then you must allow the user to use an MDB...

Pat. If you don’t need colour information in the signatures then convert them to monochrome bitmaps and they will be about the same size as a jpeg. The jpegs I converted from were 4k and the monochrome bitmaps I converted to were 5k. Chris.

To answer one of my own questions… With CreateObject("Access.Application") .OpenCurrentDatabase strDatabasePathAndName ' Do something. .Quit End With The above .Quit command does not Reset Global variables in the remote application. So the above .Quit is similar to...

I am not in a position to test this but I would like someone to test if TempVars are reset on a VBA Quit command. It would seem consistent for Microsoft to reset them but, if they do, then they would not be as 'robust' as some people like to think they are. And, in general, I'm not against the...