Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Newly Created Table no Available
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"...- WebCodger
- Thread
- Replies: 3
- Forum: Microsoft: Access Tables and Relationships
-
How do you modify/create field properties in ACCESS using ADO
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...- WebCodger
- Thread
- Replies: 7
- Forum: Microsoft: Access Modules (VBA Coding)
-
How to capture filename and path in Word?
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...- WebCodger
- Thread
- Replies: 3
- Forum: Microsoft: Office
