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 Rhinorhino 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 TheVicar75
-
SQL in vba
thx, i'll do it that way with the saved query. i just thought there was another way... thx Vic.- TheVicar75
- Post #4
- Forum: Microsoft: Access Modules (VBA Coding)
-
SQL in vba
Hi, i've got an sql statement that doesn't work. I get runtime error 7874, what's wrong, all names are spelled correctly. Private Sub cbo_SelectSupplier_AfterUpdate() Dim StrSQL As String StrSQL = "SELECT tbl_Demerit_0900_Overzicht_All.* " StrSQL = StrSQL & " FROM...- TheVicar75
- Thread
- Replies: 4
- Forum: Microsoft: Access Modules (VBA Coding)
