473,404 Members | 2,174 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,404 software developers and data experts.

Syntax error missing operator in Access subform linked to a table with photo attachme

I am attempting to add a subform to a form. There are photo attachments in the table of the subform. When I add the subform, it shows the attachment icon and shows that there is (1), but I get the error message and can't open the attachment from the form or add an attachment. Any ideas? Thanks
May 18 '17 #1
5 1135
NeoPa
32,556 Expert Mod 16PB
You get the error message. I guess that means you have a clue what you're asking about.

It's hard to help if you don't share the information in the thread.
May 18 '17 #2
I guess I'm in over my head to post anything on this forum. I thought I just asked a question. I actually don't have a clue and have no idea what information I should have shared. It's OK, I found a work-around solution that takes a bit more time, but I can see my attachments now. I have no idea why it works and the normal way of setting up my subform didn't work, but thanks for your non-answer anyway. Have a nice day.
May 19 '17 #3
NeoPa
32,556 Expert Mod 16PB
My response was not intended as an answer to your question. It was some advice that should have been far more helpful. That depends on your attitude of course.

We can help those that are inexperienced, and have done on many occasions. Those that want help from others but can't be bothered to take the effort to formulate a question properly, or even work with someone on that first part, are frankly beyond any help I'd want to give.

As an administrator of this site I'm also keen to protect our experts from having to waste their time with people who are happiest watching others take the strain.

If and when you feel like working with some of us then we're always here.

PS. Referring to my first comment in the earlier post, if you have a problem that triggers an error message then you shouldn't need any experience to know that someone trying to help you would need that error message included. Claiming inexperience is the cause is simply a cover for lack of consideration on your part and no-one is likely to be convinced otherwise. We take very good care here of those that simply lack experience. That doesn't mean we're about to allow such blatant disrespect.
May 19 '17 #4
Is 'syntax error missing operator' not the error message? I am truly clueless and would be better off seeking help at a forum who deals with less than expert users. I meant no disrespect and apologize if you perceived it that way. I personally do not find your responses particularly friendly, but you probably didn't intend that either. At any rate, I did solve my problem and won't be bothering you again with my amateur questions.
May 19 '17 #5
NeoPa
32,556 Expert Mod 16PB
LauriBob:
Is 'syntax error missing operator' not the error message?
I guess it probably is. I don't tend to look for such a detail in the title.

We'd want more than simply the error message of course, but being inexperienced we shouldn't necessarily expect you to know that without some assistance. Perhaps my frustration led me to be a little snappy, for which I apologise.

Communication is always such a critical element of any problem. I see that clearly. This is illustrated time and again. Unfortunately we see so many come here with problems they never get much help with simply because they don't appreciate that. I know how many quality experts we have here available, and how frustrating it is for all of us to be unable to help - simply because so many fail to understand the importance of clear and straightforward communication of their problems.

It's not really about experience with the subject matter - it's more about understanding the importance of communicating the problem well. That can be difficult of course, but always worth the effort.
May 20 '17 #6

Sign in to post your reply or Sign up for a free account.

Similar topics

4
by: dcarson | last post by:
I've read about this error in several other discussions, but still can't seem to pinpoint the problem with my code. Everything seemed to be working fine for some time, but it now tends to bomb out...
1
by: Alan Murrell | last post by:
Hello, One of our web hosting clients is getting the following error when someone tried to log in form their login page: --- ODBC ERROR --- Microsoft OLE DB Provider for ODBC Drivers error...
3
by: Lumpierbritches | last post by:
Syntax Error (missing operator) in query expression =BLANK'S MOLLIE-PRINCE BRUISER-3/14/2004-03 AnimalID is correct. I'm trying to open with a command button or double click the frmAnimal from a...
7
by: jodyblau | last post by:
I'm new at this stuff, so bare with me. I have a main form which displays a client record. The main form has 2 subforms. The first subform has a list of Cases. The Second subform is a list of...
4
Tog
by: Tog | last post by:
Hello, I have read several posts with this heading but none of them have helped. I have the following error message: Syntax error (missing operator) in query expression 'left(Your Product...
3
by: access baby | last post by:
I hava a date parameter filter query but it shows error Syntax error missing operator in query experssion can some one please help where am i going wrong in expression SELECT copyorderdtl * ...
6
by: Dave Richardson | last post by:
Hi to everyone, I have the following problem which is producing the following error: Syntax error (missing operator) in query expression '(CourseNo = CN1863) This caused from the follOwing...
4
by: nerd4access | last post by:
Hello all! I am not new to access, but new to coding (and posting). I have a database that I have created and need some help with a login form. When a user opens the database, a form pops up...
6
by: DuncanMcCloud | last post by:
Hi All, I am getting the following MS Access error: Syntax error (missing operator) in query expression '(((BOQ.Description) =Site Establishment Dismantle))' For the following VBA statement:...
2
by: pptechs | last post by:
Hello. In dying need of assistance. All I am trying to do is search a table for a valid user ID for a form login screen and I am getting error : "Run-time error 3075 syntax error (missing...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.