Sorting Query through Forum for range

[dbalilti]

I specify it directly.

Im going to attach my DB and you are welcome to take a look if you can. it will really help out.


Advanced Search is the form that gives the criteria and Advanced Query is the query.

[dbalilti]

Electrical_Mechanical_Contracts_Aug13_Public.zip

Here is my DB.

you are welcome to look through it if you can and see if you can find whats wrong with it lol.

the form that adds the criteria is called Advanced search and the query is advanced query.

thanks for any help

[orange]

Can you attach a copy iin mdb format, or have you used features that prohibit same?

[dbalilti]

I cant, It prohibits me.

[orange]

OK, Thanks for getting back.

[Rawb]

Here ya go!

There were really only a few minor issues that were causing your problem, however because you were opening the Query directly (instead of as a Continuous Form), it was a little more complex to solve than I had anticipated.

Basically, I did the following:

• I changed the Default values on your Form from an empty string (" ") to nothing.
• I changed the "Run Query" button so that it dynamically builds the SQL Query and then inserts it into your "Advanced Search" Query Object before running the Query.

The code for this isn't actually as complex as it may seem when you first look at it so you should be able to change it as needed for future use.

[dbalilti]

You sir, are amazing.

I have alot of VB to learn all over again, but I am seeing patterns in the code and i can figure out how I can modify it to add more criteria.
Thankyou, Thankyou Thankyou!

[dbalilti]

One last Question, How would i do this for a Boolean (Yes/No) Field on VB?


AND maybe another, I am trying to add another field into the Advanced search query and every time i add it and run the advanced search form, the field disapears.

Help please@!