Simple i think.... breaking SQL

[Guest]

My syntax is slightly wrong and having a look on the help file hasnt helped.

This works--------------------------------------------------------------------
Set rs = db.OpenRecordset("SELECT description FROM" & selectTable)

How do i get this to work?---------------------------------------------------
Dim i As String
i= "description"
I have tried this -> Set rs = db.OpenRecordset("SELECT" i " FROM" &
selectTable)
+ this -> Set rs = db.OpenRecordset("SELECT' i ' FROM" &
selectTable)
+ this -> Set rs = db.OpenRecordset("SELECT" & i " FROM" &
selectTable)

im sure the fix is very simple, thanks in advance

 

[Guest]

Made it simpler to read below:

'This works
Set rs = db.OpenRecordset("SELECT description FROM" & selectTable)

'Trying to get it so that i can put the column name from a variable
Dim i As String
i= "description"

'none of these work
'Set rs = db.OpenRecordset("SELECT" i " FROM" & selectTable)
'Set rs = db.OpenRecordset("SELECT' i ' FROM" & selectTable)
'Set rs = db.OpenRecordset("SELECT" & i " FROM" & selectTable)

im sure the fix is very simple, thanks in advance

 

[Keith74]

Hi

Try

Set rs = db.OpenRecordset("SELECT " & i & " FROM" & selectTable)

hth

Keith

 

[RB Smissaert]

You need this:

Dim i As String
i = "description"

Set rs = db.OpenRecordset("SELECT " & i & " FROM " & selectTable)

It won't matter, but I wouldn't pick i for the variable name as this is
normally
for an integer or long variable. Pick something like strField or sField.


RBS

 

[Guest]

Hahaha. I really should of thought of that! (Silly adding strings!)

Thanks keith.