Recent content by tech12345

As someone fairly new to this, the main problem I had with this was not including the AND as text (ie inside quotes somewhere), as jrbarnett has obviously correctly done in the above example. Sometimes its little things like this which are not accentuated in Help files and examples, and (I hope...

Thanks for the help, Its confirmed that my understanding was on the right lines. I suppose the name Immediate is very appropriate.

Thanks to Both, Thats me sorted

Code for “Do nothing” Is there any VBA code for “do nothing” As an example, there is no VBA function for Is Not Null so to carry out an action if a field is Not null If IsNull(Fieldname) then ‘do nothing Else DoCmd.OpenForm “Formname” End If This works fine with leaving the first statements...

This is probably a basic question, but I see a lot of code examples using Debug.print to copy some information to the Immediate Window eg Debug.Print Formname Debug.Print (strMsgPrompt) I can see the value of this for checking small amounts of information, but what about larger amounts. I...

I dont know if this is directly relevant, but I have had some problems developing an Access 2000 database in Access 2002. At first it was a couple of silly things. The scroll arrows on a form would not work on a form when opened in access 2002, but would in 2000, and the autocomplete in a form...

Does anyone know a way of finding/listing macros which are redundant/no longer attached to any event.The reason for this is Im converting to VBA, and each new Event procedure leaves a redundant Macro. I could delete manually each time but the macro may be used in other places. Ive also searched...

Does anyone know a way of finding/listing macros which are redundant/no longer attached to any event