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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by IAMCONFUSED
-
dao - ado modify query def
I found the answer elsewhere and I'm ashamed I overlooked the simple solution. As long as my query is already defined, I can modify as such: Sub ReplaceQuery() strSQL = "SELECT * FROM MYDATA;" CurrentDb.QueryDefs("qryMyQuery").SQL = strSQL DoCmd.OpenQuery "qryMyQuery", acViewNormal...- IAMCONFUSED
- Post #2
- Forum: Microsoft: ActiveX
-
dao - ado modify query def
My ERP software is dictating that I use ADO connections. I have been able to convert all my code except when I need to modify a querydef. In DAO it was like this: Sub ReplaceQuery() Dim dbs As Database, qdf As QueryDef Set dbs = CurrentDb dbs.QueryDefs.Refresh For Each qdf In dbs.QueryDefs If...- IAMCONFUSED
- Thread
- Replies: 1
- Forum: Microsoft: ActiveX
-
NETWORK LOGIN NAME
HOW DO I ACCESS THE NETWARE 4.11/CLIENT 3.1 LOGIN NAME FROM A USER?- IAMCONFUSED
- Thread
- Replies: 6
- Forum: Microsoft: Access Other topics
