Search results

Hi. I believe the only problem would be that all of my fields simply require yes or no, therefore there would be several yes or no data fields. I am not that well-versed in access so can you tell me if that would be a problem? The only options to choose from are yes and no and there are about 19...

Yes it was very interesting however it is not exactly what I am trying to achieve. I have combo boxes that I need to use where the end user can simply select their desired criteria and click a button to give them results. I am creating a similar db to see how your method works but it is not...

The last demo was very interesting but it was for a search form which does not exactly match what I am trying to achieve. Is that what you are referencing? The copydbsample?

That's fine, whenever you get a chance :) your help is greatly appreciated!

Hi, yes it is! Just looking for any feedback. Any general ideas?

Hi, I am trying to create a form with certain criteria to open a query with the desired result. I will attach the db so that you can take a look before you have anymore questions regarding the db. The problem is that the query is very specific to every single answer I put out. I am generally...

Thanks so much. I will take a look in the meantime. Does my issue look like it can be resolved with the current format?

Thank you so much! I really appreciate your help :)

Should I change the entire format of my database so far? Or is there any way of achieving what I am looking to do with a particular code? Please look at my database and let me know! thank you!

Here is part of the database. The form and Query are both in capital letters. Please let me know if you are able to help with the coding or have alternative suggestions. Thank You!

I am not using checkboxes, instead it is a lookup wizard with 2 options; yes and no. So there are dropdown combo boxes. Don't know if this makes a difference but let me know if it does. I will try and post the database as well so it is easier and clearer to understand. Thanks again for your...

How should I implement this? Since I am looking at yes/no fields, the search forms are not very helpful in my case. Or maybe I am looking at the wrong links?

How do I go about this?

SELECT [Special Notes Matrix (Main)].[Name Of Special Note] FROM [Special Notes Matrix (Main)] WHERE ((([Special Notes Matrix (Main)].[Paving/Resurfacing])=([Forms]![THEFORMTOUSE]![Paving/Resurfacing])) AND (([Special Notes Matrix (Main)].[Drainage Work])=([Forms]![THEFORMTOUSE]![Drainage...

I will look through that, thank you so much! In the meantime, I wanted to know if you could help me directly? The following is my code: SELECT [Special Notes Matrix (Main)].[Name Of Special Note] FROM [Special Notes Matrix (Main)] WHERE ((([Special Notes Matrix...

Hi, that is not exactly what I am looking for. I am looking to find a way to put in sql language so that I can have no effect from the no answers and search only based on the yes answers. Do you know how I can achieve this?

Thank you so much! That is exactly what I am looking for. Please let me know if you know how to achieve this.

I am creating a query for several fields of data. My current criteria is as follows: ([Forms]![Formname]![labelname]). So this criteria goes on for several fields of information and in the end I linked this to a form which will display information in a query search based on the selections on the...

Thanks so much for your input. I am attaching a link with a demo of something that looks like what I have but much more simplified. Basically from here I am trying to create a form where I can make an input into each box and have those results display those certain characteristics. Going back to...

Hi, I am attempting to create a form in which I can automatically receive a list of records based on my desired criteria. To further explain, say I am creating a database containing construction projects. I have about 20 characteristics which may or may not apply to each project. I want to...