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?

Microsoft AccessMicrosoft OfficeDatabases

Last Comment

Joe Howard

8/22/2022 - Mon

Jeffrey Coachman

3/27/2015

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

3/27/2015

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

3/27/2015

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

GET A PERSONALIZED SOLUTION

Ask your own question & get feedback from real experts

Find out why thousands trust the EE community with their toughest problems.

Joe Howard

6/15/2016

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

Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!

Walt Forbes