It's obvious your vba logic is in the wrong order - curArtist is used in the
SQL before it even has any value.
On Fri, Feb 15, 2008 at 2:12 AM, Annika Scheffler <[EMAIL PROTECTED]>
wrote:
> 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...which I find confusing:
>
>
>
> 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!
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:3035
Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
