Error Message 3075 - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Error Message 3075

John Miller

4 years ago

I have a table that I want to pull a value from. Then table is called abcMonthtbl. Here is the code an error:
   Dim SQL As String

    SQL = "SELECT abcMonthtbl.InvoiceType" & _
          "From abcMonthtbl;"

    DoCmd.RunSQL SQL

run-Time error "3075':
Syntax error (missing operator) in query expression
"abcMonthtbl.InvoiceTypeFROM abcMonthtbl'.
Can someone please tell me what I am doing wrong!!!! I thought that the word SELECT was an "operator"?
Thank you In advance

	Adam Schwanz @Reply 4 years ago
If you take out the & _ I think you will see the problem. (missing a space) SQL = "SELECT abcMonthtbl.InvoiceTypeFrom abcMonthtbl"

	Adam Schwanz @Reply 4 years ago
Add a space either after Type or before From

John Miller OP @Reply

4 years ago

Tank you Adam I made changes 3 different ways.
1.) SQL = "SELECT abcMonthtbl.InvoiceType FROM abcMonthtbl;"
2.) SQL = "SELECT abcMonthtbl.InvoiceType "& _
               "FROM abcMonthtbl;"
3.) "SELECT abcMonthtbl.InvoiceType "& _
               " FROM abcMonthtbl;"
and each time I get the following error:
Run-Time Error "2342":
"A RunSQL  action requires an argument Consisting of an SQL statement."
Now what is going on?

	Adam Schwanz @Reply 4 years ago
What are you trying to do with that SQL statement? You can only run action queries (append/update/delete) with a statement like that.

	Adam Schwanz @Reply 4 years ago
Sorry, just took the time to really read what you had going on, a SELECT statement there doesn't really make sense. What I think you're looking for is DLookup

	John Miller OP @Reply 4 years ago
OK I now know what you are telling me. Think I understand I will relook at my plan and redo. Thanks.

	Richard Rost @Reply 4 years ago
Yep. Adam caught it. There's nothing to do if you RunSQL a SELECT statement. That's for action queries. :)

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View