Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rating: Thread Rating: 3 votes, 5.00 average. Display Modes
Old 12-04-2012, 06:51 AM   #1
Jambuck
Newly Registered User
 
Join Date: Dec 2012
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Jambuck is on a distinguished road
Syntax error (missing operator) in query expression

Hi.

I have recently been recieving an error message:

"syntax error (missing operator) in query expression 'field name' "

This happens each time I try and right click any of the fields on a certain page of my database whilst in datasheet view.

Can anyone help me fix this problem or offer some advice.

Thanks,

Jambuck is offline   Reply With Quote
Old 12-04-2012, 06:57 AM   #2
pr2-eugin
Super Moderator
 
pr2-eugin's Avatar
 
Join Date: Nov 2011
Location: Bournemouth, UK
Posts: 8,498
Thanks: 68
Thanked 2,065 Times in 2,014 Posts
pr2-eugin has a spectacular aura about pr2-eugin has a spectacular aura about pr2-eugin has a spectacular aura about
Re: Syntax error (missing operator) in query expression

Hello.. Welcome to AWF..

See if there is any event associated with the Form_OnClick() event. Or the controls that causes the error..

Also the Syntax error normally points to the query that forms the Record Source of the Form.. If you have accidentally compared Text with Number or vice-verse..
__________________
Regards,
Paul Eugin

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
!
!
Windows 7 Professional, MS Access 2010
---------------------------------------------------------------------------------------------------------------------
If the above post has helped you, please click the scales
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
or click the 'Thumbs up'. Cheers.

---------------------------------------------------------------------------------------------------------------------




Last edited by pr2-eugin; 12-04-2012 at 07:05 AM.
pr2-eugin is offline   Reply With Quote
Old 12-04-2012, 07:20 AM   #3
Jambuck
Newly Registered User
 
Join Date: Dec 2012
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Jambuck is on a distinguished road
Re: Syntax error (missing operator) in query expression

Thanks for getting back to me so quickly.

My problem is also that I don't know how to do any of the checks or fixes that you mentioned. I didn't design the database myself and until now have only input data, so have very little knowledge of Access and how to get around.

Jambuck is offline   Reply With Quote
Old 12-06-2012, 02:42 AM   #4
pr2-eugin
Super Moderator
 
pr2-eugin's Avatar
 
Join Date: Nov 2011
Location: Bournemouth, UK
Posts: 8,498
Thanks: 68
Thanked 2,065 Times in 2,014 Posts
pr2-eugin has a spectacular aura about pr2-eugin has a spectacular aura about pr2-eugin has a spectacular aura about
Re: Syntax error (missing operator) in query expression

Check the image for how to check the Form properties..

Attached Images
File Type: png formProp.png (35.8 KB, 14835 views)

__________________
Regards,
Paul Eugin

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
!
!
Windows 7 Professional, MS Access 2010
---------------------------------------------------------------------------------------------------------------------
If the above post has helped you, please click the scales
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
or click the 'Thumbs up'. Cheers.

---------------------------------------------------------------------------------------------------------------------



pr2-eugin is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Syntax Error - Missing operator in query expression frispee Modules & VBA 3 07-05-2012 09:18 AM
Syntax error (missing operator) in query expression jlathem Reports 5 10-19-2010 01:48 PM
Syntax error missing operator in query expression wrightie Modules & VBA 6 03-26-2010 01:40 PM
Syntax error (missing operator) in query expression 1griffa25 Queries 3 10-12-2007 12:20 AM
Syntax error (missing operator) in query expression hollering Modules & VBA 3 02-18-2005 05:31 AM




All times are GMT -8. The time now is 12:47 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World