Search results

You would create a query that queries 2 fields the date and the assigned engineer. In the query criteria for the date you would use the query line I listed in my earlier making changes for the form name, field name etc. Then set the toggle button set to run the query and just use the basic...

Not sure if this is what your looking for but setting up a simple user parameter search would be fairly simple using a form based query. First you would have to create a new form with several unbound data boxes. Two unbound boxes for each of the data ranges you want to search for. So you would...

Sorry for the late reply got swamped with other duties. At the risk for sounding ignorant how would one go about doing that you lost me abit on how to implement this solution. If i am following you correctly set up a report? Wouldnt that have to run off of a query?

Hi Bob. Unfortunately according to our SOW everything but the auto generated numbers is propriatary or confidential to our customer or our company. However I can post up the SQL code for the query in question. So I went through and linked each query field to a form field saved, closed the...

Thanks for the reply's. Big Pat and vbaInet. First off the Record Source for the form was blank but when I set it up as the qrysearch (the one having the issue) and tried opening the qrysearch design view from the record source access locked up. Then I tried creating a blank database and...

First of all Hello. This problem has really got me stumpped. I have searched ton's of forums and haven't found anything that has helped. I am updating a working database with some more user friendly form queries. I have set the query up to the main data table, created the query, and the...