Search results

The online Access Developer Help for Access 2007 shows a "QueryClose Event". It is not an available event on forms in my Access 2007 application. Is this a real event in VBA or is this erroneous information? It is exactly what I am looking for. It has two parameters. One is to Cancel the Close...

Quirk in Access where 1 code error = "The expression On Load you entered as the ... I ran across a particularly frustrating quirk in Access 2007 (perhaps other versions also). After saving changes to code and reopening the form I was working on I kept getting the following general errors...

Select all text in a combobox when it is clicked (not as obvious as it may look) In the Got Focus event I use: If cmbClient.Value & "" <> "" Then cmbClient.SelStart = 0 cmbClient.SelLength = Len(cmbClient.Value) End If That works fine if the user tabs to the combobox but not if they click...

I have a form with a Client Name combo box and a Client Code label. Whenever the user selects a Client Name from the combo box I populate the Client Code label with the coresponding value. I need to allow them to edit any of the Client Name/Client Code combinations. To do that I pop up a form...

I have a form where I prompt the user for criteria. When they click a button I bring up a Report (in Print Preview mode) which uses the criteria. The Report displays properly in the Preview and it is populated correctly. However, Access prints a screen shot of the Form that called the Report...