Access 2013 Query

I have created a query based on a table of contractors that I have. When I open up the query I get the following error:

"The Settings you entered isn't valid for this property."

I have double checked the table settings and they are all set up to be short text or number.  I have check with other revision of my database and nothing has changed.  Is there a way to fix this error before my users start working in it?  

Also I have a side question, is it possible to make a report with a drop down list so that we can print reports out per item instead of have 20 different buttons to sort them out?
kris45068Asked:
Who is Participating?
 
Jeffrey CoachmanMIS LiasonCommented:
OK,

Lets first get you naming right.
As far as I can tell, the table name should be: tblContractors
...because it is a table of contractor fields, ...not just contractor names.

Second you have no: "ContractorNames" field in your table, ...so I am not quite sure what you were trying to do with that query...

In this case try the query like this:

SELECT *
FROM tblContractors

Works fine for me...
;-)
JeffCoachman
0
 
Jeffrey CoachmanMIS LiasonCommented:
Delete the query
Run the compact/repair utility
Recreate the query.
If that does not work, then please post the SQL behind the query

Also I have a side question, is it possible to make a report with a drop down list so that we can print reports out per item instead of have 20 different buttons to sort them out?
This is really a separate/unrelated question that should be dealt with in a separate/new question, ...but yes, this is possible,
There is a combobox wizard that will help you create a combobox from the Items table (and include the ItemID).
...then you can use code like this to filter for the selected item
    DoCmd.OpenReport "YourReport", acViewPreview, , "ItemID=" & Me.YourCombobox
;-)

JeffCoachman
0
 
kris45068Author Commented:
Thanks for your reply.  I tried what you posted and recreated the query, but got the same pop up message.  Here is the SQL for the query.

SELECT ContractorNames.*
FROM ContractorNames;


I have also posted a screenshot of the Table in which I am pulling the information from.

Thanks for the help.
contractorsTable.PNG
0
 
MacroShadowCommented:
No comment has been added to this question in more than 21 days, so it is now classified as abandoned.

I have recommended this question be closed as follows:

Accept: Jeffrey Coachman (https:#a40692980)

If you feel this question should be closed differently, post an objection and the moderators will review all objections and close it as they feel fit. If no one objects, this question will be closed automatically the way described above.

MacroShadow
Experts-Exchange Cleanup Volunteer
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.