The Microsoft Jet engine does not recognise 'Red' as a valid field name or expre

[Paul kelly via AccessMonster.com]

Hi,

I'm new to VB and am currently trying to link VB with access but the following error message appears 'The Microsoft Jet engine does not recognise 'Red' as a valid field name or expression'

red is a record under one of the fields in acess.

Can you please help me with this? I need to know A.S.A.P
Thank you very much.

 

[Jeff Boyce]

Paul

From the error message you provided, it sounds like you have an expression
that refers to a field named "Red". From your description, it sounds like
you have a value in one of your fields, said value is "Red". The two don't
match.

If you provide the expression which is causing the error, 'group readers
might be able to help more.

--
Good luck

Jeff Boyce
<Access MVP>

Hi,

I'm new to VB and am currently trying to link VB with access but the

following error message appears 'The Microsoft Jet engine does not recognise
'Red' as a valid field name or expression'

 

[Paul kelly via AccessMonster.com]

I have this problem fixed Thanks for your reply

 

[Tom Lake]

I have this problem fixed Thanks for your reply

So what was the solution?

Tom Lake