Re: Type Mismatch in dLookup

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I made some changes and got a different error. But I think that I'm on the
right track.

New String*******************
strContact = DLookup("[ContactID]", "qryLLCAddressFillIn", "[ChurchID]=" &
Me.ContactChurch.Value & "' And [ContactLastName]='" &
Me.ContactLastName.Value & "'")

Error Message******************
Run time error 3075: Syntax error missing operator in query expression
'[ChurchID]=13230' AND [ContactLastName]='cash".

"Linq Adams via AccessMonster.com" wrote:

These things are always a hairball for me, getting the quotes correct, so I
keep a template to use. Try this:

strContact = DLookup("ContactID", "qryLLCAddressFillIn", "[ChurchID]=" &
Me.ContactChurch.Value And """[ContactLastName]=""" & """
Me.ContactLastName.Value """)

Also, be aware that in the statement

Dim strAddress1, strAddress2, strCity, strStateID, strState, strZip,
strPhone As String

only

strPhone

is being Dimmed as a String. Every other variable is being dimmed as Variant,
which is the default. To have them all declared as String you need to use

Dim strAddress1 As String, strAddress2 As String, strCity As String,
strStateID As String, strState As String, strZip As String, strPhone As
String

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200811/1


.

Relevant Pages

  • Re: Type Mismatch in dLookup
    ... Dim strAddress1, strAddress2, strCity, strStateID, strState, strZip, ... strPhone As String ... is being Dimmed as a String. ...
    (microsoft.public.access.formscoding)
  • Re: Type Mismatch in dLookup
    ... You have an extra single quote in the string. ... Dim strAddress1, strAddress2, strCity, strStateID, strState, strZip, ...
    (microsoft.public.access.formscoding)
  • Re: Type Mismatch in dLookup
    ... Dim strAddress1, strAddress2, strCity, strStateID, strState, strZip, ... strPhone As String ...
    (microsoft.public.access.formscoding)
  • Parameter value
    ... It seems can execute the query. ... strPhone: String; ... The field 'Phone' is not a required field. ...
    (borland.public.delphi.database.ado)
  • Color
    ... I want to put some data of the string in RED color ...
    (microsoft.public.access.formscoding)