Group:  Microsoft Access ยป microsoft.public.access.modulesdaovba.ado
Thread: SQL GUID translates into Chinese

Geek News

SQL GUID translates into Chinese
Kelly 12/19/2008 9:16:29 PM
Hi,
Can someone help me figure out why I am getting the error "Malformed GUID.
in query expression...", with the expression
containing Chinese-looking characters instead of the GUID value? Here is the
code:

Private Sub Form_Load()

Dim vargd As Variant
vargd = Me.ctlGUID
Dim str As String

str = "SELECT First_Name, [Name] FROM [ContactList] WHERE
((([ContactList].GUID)={guid " & vargd & "}));"

Me.Combo0.RowSource = str
End Sub

Home | Search | Terms | Imprint Contact
Newsgroups Reader - provided by WiredBox.Net