Recent content by Barry.dunnage

Have you checked that the data type is correctly set in the tables:)

Thanks for your help nanscomb It likes being a string have a nice day. Regards Barry

Hi Thanks for the prompt replies I have done as you said. now getting run time error 3464 Data type mismatch in criteria expression any ideas

hi all Can you help with this one please? This works CurrentDb.Execuite "UPDATE Table1 SET Table1.Status = 2 WHERE Table1.orderNumber ='632';" This wont work CurrentDb.Execuite "UPDATE Table1 SET Table1.Status = 2 WHERE Table1.orderNumber = varItem1;"

Hi all I am a self taught programmer started on PHP now use access at work and have attended a beginners course. Looking forward to using and learning about access. Regards Barry