Recent content by MartyL354

That is what I needed. I had a single form that I opened modal. I put code in the On Unload Event to close the application (Application.Quit). If I tried to close the form then put it in Design mode I would get a cyclical error # 2046, The command or action "Quit" isn't available right now. I...

I can't test the event because it isn't even available (as in doesn't show up in the list of available events) in my installation of Access 2007. Is it available in other versions of Access?

Sorry, I meant QueryUnload in VB6. I was just hoping the QueryClose event was there in Access because they do show it in the online Access 2007 help file.

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...

Re: Quirk in Access where 1 code error = "The expression On Load you entered as the . Thanks for the info Bob.

Re: Quirk in Access where 1 code error = "The expression On Load you entered as the . Caveat. This is at leat the case in Access 2007.

Re: Quirk in Access where 1 code error = "The expression On Load you entered as the . jal sent me a solution to this issue. (Thanks jal) I know that the error would finally surface once I ran the event where the error was but the fact that Access detected an error, in my opinion, it should...

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...

Thanks flect. That did the trick.

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...

Thank you kindly. That works. I was trying to do soemthing like that earlier. I was tracking the row with .listindex but then I was trying to move to a different row and then back using the .selected property to move off the row and then back. That doesn't seem to work at all. However...

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...

Sorry it took me so long to get back. I was working on another project. In relation to the post to use "acPreview" that isn't an available option in Access 2007. I am guessing that was a VBA constant in an earlier version perhaps? In relation to how I was printing I was using the standard...

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...