Search results for query: *

I've got a lot of DAO code I'm managing so my hope is that I can find a solution without switching to ADO. To answer your question, yes, I've tried changing the arguments and using different lock parameters.

Yes, sorry. I realized after my post that I should have mentioned I'd checked for the library reference.

After upgrading my access database from 97 to 2003 I'm running into problems with recordsets opened from querydef objects. Here's an example Sub testdao() Dim db As DAO.Database, RecMain As DAO.Recordset, myQuery As DAO.QueryDef Dim MillSection As String Set db = CurrentDb()...

I have several datagrid controls that sort based on a column header click event, but the Flexgrid does not have a headerclick event. Any ideas how I can accomplish the same thing as my datagrid control so that me users don't have to think about right clicking on a selected column?

Thanks for your post Omega36 I tried moving my validation code to the validation event with the same result. The validation event does not fire before the query_unload event (I have no idea what MS is thinking here). To my mind when a user clicks the close button on the form he is essentially...

Hi all My problem is that I have entered my validation code for my fields in the lost focus events of the controls on my forms. When a user clicks the close button on the form after having made a change to any control on the form the query unload event fires but the lost focus event does not...