Search results

Here is something I have been noticing and I thought someone might be able to shed some light on this and maybe offer a cleaner solution. I working with a front-end db in Access and linking to Oracle tables. When writing SQL Insert and Update statements using dates and strings, if the...

Hi, I have a form which has two separate subforms in it. When the user selects a record in the first subform, I want the values of that record to write to the second subform's fields. OnCurrent works when there is more than record in the subform. My problem is two fold, one I don't want my copy...

I am saving an odbc connection string to a global variable. Periodically, it seems to lose the connection. Does anyone have a way of testing that the connection exists. I have tried to do if gblvar=nothing then... and it doesn't like that. It often gives the err=13 Type Mismatch when it doesn't...

Hi, I have written ADO VBA code that cycles through an open database and copies all the objects to a new database. Even though, I do a docmd.close on the form that launched the code, it still hiccups like it is open. Any thoughts on how to remedy this so that object gets copied as well. Also...

From inside one database, I create a blank database from which I copy all of the objects to the new database. I use createdatabase to make the blank database. Then I loop through the linked tables and make local copies in the new db. I then copy the rest of the objects. I would like to set the...