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!
-
3021: No Current Record - Update Query
Hi, Im fairly new to creating databases and please be nice as my database is probably not the best designed but im trying. My database is designed to compare two datasets from our internal systems and then append data mimatches into [Mismatch Table - Results] then people can use forms and such...- shVBA
- Thread
- Replies: 2
- Forum: Microsoft: Access Queries and JET SQL
-
Microsoft Query Not Running Query
I have VBA cose that inserts SQL into microsoft query and then is supposed to refresh the query. The code runs fine without any errors and inserts the SQL into ms Query. once the code has finished if i look at the query it does not return any rows of data but then if i go into msQuery and exit...- shVBA
- Thread
- Replies: 7
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Using SQL in VBA to Query External Database
Hi, I am trying to use SQL in VBA to query an external database, i have set the query up in microsoft query and just want to pass the SQL to the query with variables in each time. I am getting an error when running the code at With Sheets("Sheet1").Querytable(1) The Code is as follows: Sub...- shVBA
- Thread
- Replies: 9
- Forum: VBA Visual Basic for Applications (Microsoft)
