asked on

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?

Jeffrey Coachman

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

kris45068

ASKER

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

ASKER CERTIFIED SOLUTION

Jeffrey Coachman

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Joe Howard

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