vba code to talk to access - Mind blank!

[jparfitt87]

hi all!

i can't seem to find the answer i'm looking for and i can't for the life of me remember the code i need.
Basically, I'm having an excel file retrieve data from Access via VBA code:

Sqlstr = "SELECT ID, Record_Date, Request_Type, Policy_Number, Customer_Name, Amount, CSR, TL "

Sqlstr = Sqlstr & "FROM Tbl_Requests "

Sqlstr = Sqlstr & "WHERE Completed = FALSE and Pending = False and Declined = False and Request_Type = & Chr(34) & Refund & Chr(34) "

Sqlstr = Sqlstr & "ORDER BY Record_Date, Record_Time"

It's the highlighted bit that i can't figure out, when I debug.Print it returns request_type as "" or & Chr(34) & Refund & Chr(34).

Please help

 

[mole999]

Chr34 is ", maybe you mean '

SELECT ID
, Record_Date
, Request_Type
, Policy_Number
, Customer_Name
, Amount
, CSR
, TL
FROM Tbl_Requests
WHERE Completed = FALSE
and Pending = False
and Declined = False
and Request_Type = 'Refund'
ORDER BY Record_Date, Record_Time

 

[Norie]

You are missing a ".

Sqlstr = Sqlstr & "WHERE Completed = FALSE and Pending = False and Declined = False and Request_Type = '" & Refund & "'"