Please help with Type Mismatch Error

sigh yes, the correct syntax for a number data type is
"MonthID = "& Me.ID

but as i said before, the problem appears to be "a misplaced double
quote
and a missing ampersand." if you'll look carefully at the expression i

posted, you'll see that i did not change the syntax for the MonthID.
rather,
i added an ampersand (&) and moved a double quote. compare my posted
expression and your original posted expression and i'm sure you'll see
the
differences.


as far as the "syntax error" goes, i made the assumption that you're
using
this expression in a VBA procedure. if instead you're using it directly
in a
form, report, or query, then the line-break character ( _ ) is not
recognized. remove it, and put the entire expression all on one line.


hth
(and btw, "hth" stands for "hope this helps")


Tina,
Known to me as hth. Sorry I forgot my computer acronym book at work.
Sigh How do you think I feel?? I have been messing around with this
for the better part of a day. Your message states that you added an
ampersand and moved a double quote. I think you added a double quote.
My original formula was "MonthID = " & Me.ID You told me to try
"MonthID = " & Me.ID & ". Three doulbe quotes?? I am telling you
access gives me a syntax error. I am using this as a default value in
the form but because of the unexpected fact that the statement is not
working I am using VBA to troubleshoot. I hope you can help me with
this problem if you read this. I'll send you a free trip to Tahiti or
something.
TVM (thanks very much)
Sean

Post the exact line of code that is getting the syntax error.

TC (MVP Access)
http://tc2.atspace.com

On 2 Apr 2006 21:22:56 -0700, TC wrote:

OT, but, I'm struggling to find a good newsreader. I like the way that
google groups works, but they impose a posting limit, & they won't
increase it for anyone. (I know; I've asked them; they've told me!)
When I *eventually* (gasp) introduce myself on the mvp newsgroup, I'll
be asking everyone else what they use.


Cheers,
TC (MVP Access)
http://tc2.atspace.com

TC
I've been using Dialog for many years now for newsgroups (as well as
e-mail).
http://www.40tude.com/dialog/
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Your message states that you added an
ampersand and moved a double quote. I think you added a double quote.
My original formula was "MonthID = " & Me.ID You told me to try
"MonthID = " & Me.ID & ". Three doulbe quotes??

DLookup("CraftAH", "HoursTracking", "MonthID = " & Me.ID _
& "And CompanyID = 'SLM'")

above is what i originally posted. not a third double quote - unless you
take it out of context. however, i did find an error in the spacing. here's
the correction:

DLookup("CraftAH", "HoursTracking", "MonthID = " & Me.ID _
& " And CompanyID = 'SLM'")

note the space between the double quote and the And, on the second line. my
previous comments about removing the line break character and placing the
entire expression on one line, if it's used directly in the form, still hold
true.

hth


wrote in message
oups.com...
sigh yes, the correct syntax for a number data type is
"MonthID = "& Me.ID

but as i said before, the problem appears to be "a misplaced double
quote
and a missing ampersand." if you'll look carefully at the expression i

posted, you'll see that i did not change the syntax for the MonthID.
rather,
i added an ampersand (&) and moved a double quote. compare my posted
expression and your original posted expression and i'm sure you'll see
the
differences.


as far as the "syntax error" goes, i made the assumption that you're
using
this expression in a VBA procedure. if instead you're using it directly
in a
form, report, or query, then the line-break character ( _ ) is not
recognized. remove it, and put the entire expression all on one line.


hth
(and btw, "hth" stands for "hope this helps")


Tina,
Known to me as hth. Sorry I forgot my computer acronym book at work.
Sigh How do you think I feel?? I have been messing around with this
for the better part of a day. Your message states that you added an
ampersand and moved a double quote. I think you added a double quote.
My original formula was "MonthID = " & Me.ID You told me to try
"MonthID = " & Me.ID & ". Three doulbe quotes?? I am telling you
access gives me a syntax error. I am using this as a default value in
the form but because of the unexpected fact that the statement is not
working I am using VBA to troubleshoot. I hope you can help me with
this problem if you read this. I'll send you a free trip to Tahiti or
something.
TVM (thanks very much)
Sean

Post the exact line of code that is getting the syntax error.

TC,
I just placed this in the on click event of a button to test the
formula. This gives me a Syntax error:
Me.Text97 = DLookup("[CraftAH]", "[HoursTracking]", "MID = " & Me.ID &
" And "CompanyID = 'SLM'")
This gives me a Type Mismatch Error:
Me.Text97 = DLookup("[CraftAH]", "[HoursTracking]", "MID = " & Me.ID
And "CompanyID = 'SLM'")
Thanks,
Sean

DLookup("CraftAH", "HoursTracking", "MonthID = " & Me.ID _
& "And CompanyID = 'SLM'")

above is what i originally posted. not a third double quote - unless
you
take it out of context. however, i did find an error in the spacing.
here's
the correction:


DLookup("CraftAH", "HoursTracking", "MonthID = " & Me.ID _
& " And CompanyID = 'SLM'")


note the space between the double quote and the And, on the second
line. my
previous comments about removing the line break character and placing
the
entire expression on one line, if it's used directly in the form, still
hold
true.


hth


Tina
AKA hth
Thankyou so much for your help. I guess sometimes things need to be
spelled out several times for me to understand. Where do you want me
to send your free trip to Tahiti??
Thanks again.
Sean

Thanks Fred, I will take a look at it. (I actually downloaded it some
time ago, but have not used it yet.)

TC (MVP Access)
http://tc2.atspace.com

wrote:

This gives me a Syntax error:
Me.Text97 = DLookup("[CraftAH]", "[HoursTracking]", "MID = " & Me.ID &
" And "CompanyID = 'SLM'")

I'm not surprised :-)

Do you mean to find the record where MID is the value of Me.ID, and
CompanyID is the fixed value 'SLM'? If so, this is what you need. Don't
retype it: cut & paste, to make sure it is right. I've coded it on
several lines, to make it look clearer.

Me.Text97 = DLookup( _
"[CraftAH]", _
"[HoursTracking]", _
"[MID] = " & Me.ID & " And [CompanyID] = 'SLM'")


HTH,
TC (MVP Access)
http://tc2.atspace.com

Thanks TC. Along with Tina's help I am all straightened out now.

well, we both muddled through it, glad it's working for you now.


wrote in message
oups.com...
DLookup("CraftAH", "HoursTracking", "MonthID = " & Me.ID _
& "And CompanyID = 'SLM'")

above is what i originally posted. not a third double quote - unless
you
take it out of context. however, i did find an error in the spacing.
here's
the correction:


DLookup("CraftAH", "HoursTracking", "MonthID = " & Me.ID _
& " And CompanyID = 'SLM'")


note the space between the double quote and the And, on the second
line. my
previous comments about removing the line break character and placing
the
entire expression on one line, if it's used directly in the form, still
hold
true.


hth


Tina
AKA hth
Thankyou so much for your help. I guess sometimes things need to be
spelled out several times for me to understand. Where do you want me
to send your free trip to Tahiti??
Thanks again.
Sean