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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Trying to use integer variable in SQL query
Dim POFROM As Integer POFROM = Range("H1").Value Range("B1").Select With Selection.QueryTable .Connection = Array(Array( _ "ODBC;DSN=Vantage 5...- Minkus
- Thread
- Replies: 1
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Adding extra parameter to working Query cause Query to Fail !!
I am adding to an existing query that searches a database and compiles an Excel report using VBA program. The database is a Vantage database. The code is as follows: Sql$ = "SELECT RcvDtl.PartNum, RcvDtl.PartDescription, RcvDtl.OurQty, RcvDtl.PONum, RcvDtl.ReceiptDate, PORel.DueDate...- Minkus
- Thread
- Replies: 1
- Forum: VBA Visual Basic for Applications (Microsoft)
