Hi,
I'm totally new to VBA and SQL and I just can't figure out why I keep
getting this error message. In fact I copied part of a different code
which works that way...
Dim conn As ADODB.Connection
Dim rst As New ADODB.Recordset
Set conn = CurrentProject.Connection
Dim curArtist As String
rst.Open "SELECT Artist FROM Artist_Information WHERE Artist = " &
curArtist, conn, adOpenForwardOnly, adLockReadOnly
--> Here I get a syntax error (missing Operator) for 'Artist=' Why is that?
While Not rst.EOF
curArtist = rst.Fields(0)
If curArtist = "Anna Ternheim" Then
MsgBox ("Biography: Anna Ternheim was born in 1976" )
End If
Thanks!
--
http://www.annikajayne.de
"Ravens fly in flights, but the eagle flies alone" - Quote from the film
"Beyond Silence".
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:3032
Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
