Search results

That's a good tip, thanks. But what I really need is something which doesn't require the user to go to the control but forces a requery when triggered by an event (e.g. a re-selection / re-filtering) on the main form. Regards and many thanks for the feedback / suggestion.

Hi Everyone, In my main forms I use me.myobject.requery to refresh particular list and combo boxes. That works fine. I tried using this in subforms because I found that, when the main form was refiltered, the subform refiltered correctly but any combo-boxes in that form did not refresh. I'm...

Hi Everyone, I use a range of Import Specs to connect external (text and csv) data to an mdb database. This works fine. However, I would like to create and adapt these specifications using VBA and am not sure how to handle this. Are there (maybe?) internal/system tables that handle these...

I managed to fix this problem by doing the following ... I created the query a dummy select and then after the connection string had been set (and MS-Access knew it was a passthrough), only then did I set the SQL. Thus ... Set qdfNew = CurrentDb.CreateQueryDef(qFullName, "SELECT SYSDATE FROM...

Hi Everyone, I have a number of ODBC passthrough queries which collect data from an Oracle database. This all works fine. I also have some VBA code which can generate some of these queries 'on the fly' (e.g. passing filter parameters). This also works fine when I avoid using table...