Search results for query: *

Thanks for responding, Pete. The code hangs up on "dbRefreshCache". Error message: "Variable not defined" Is there another reference I should have active? You obviously have the right idea. If I put a long "For...Next" loop in the code, the tables collection does catch up. You're also right...

With all the sophisticated stuff on this site, I'm embarrased to post this. Here's the code in its simple form: Dim Con As New ADODB.Connection Con.Open CurrentProject.Connection Con.Execute "CREATE TABLE MyTable (MyColumn text(10));" Con.Close Set Con = Nothing DoCmd.OpenTable "MyTable"...

I am attempting to migrate from DAO to ADO. I can create a table and add fields using the Catalog set, but all fields have the "Required" property set to true. A listing of the properties for one of the new fields doesn't show "Required" as a property, so I suppose I need...

Skip, Appreciate your response to my question. The code you supplied did indeed bring up a dialog box to open files, however, no files can be opened using dialog boxes in my crippled version of Word, whether the dialog box comes through the Word libraries or the Excel libraries. What I was...

We have an obnoxious program on our intranet called PCDOCS. This "Big Brother" type program virtually insists that you open and close all files through its filing system. But it does not block a direct VBA command to open a file such as WordBasic.fileopen...