Search results

Thanks for all of your help Billmeye! You sure know your stuff!

Hi All, I have a small database and have just begun to create some reports. I have a table called EVAP Database. I want to create a form where users can select 3-6 fields (from combo boxes) and then can click a generate button to open a report with those selected fields as the report. I messed...

I answered to the best of my ability. I am not an expert in Access and I thought you would help me by looking at the databse, as everyone who has helped me on here has. But Im going to assume you dont know much about it either. Thanks for your help.

Both of your suggestions are not solutions to my problem. I plugged the code in and recieved an error. I also tried stacking them per your instructions and the keyword search does not function. Can you look at my provided database and try to fix the issue?

Hi, I tried both of your suggestions but they didnt seem to work. :( Would you mind looking at my file and trying it for yourself? Thanks!

Hi All, I currently have a small database where users input information on return parts. I have added a section to add data from testing and have made it so it greys out certain boxes when the part type is selected using conditional formatting. However conditional formatting will only allow...

Hi All, I currently have a database with a few search forms. I recently attempted to add a box on one of my search forms to search 3 cells of a record for a key word. What happens is when I go to search, say for P0442, it does not bring up all of the records that contain that keyword in the 3...

On the Search(ViewOnly) form I have 5 search criteria. Trracking Number, Date Code, VIN, Part Number, and Keyword or Phrase. Before adding the Keyword phrase to the search query everything works fine. I want the Keyword box to search in 3 cells of each record: Remarks, Additional Remarks, and...

Hi All, I currently have a database with a few search forms. I recently attempted to add a box on one of my search forms to search 3 cells of a record for a key word. What happens is when I go to search, say for P0442, it does not bring up all of the records that contain that keyword in the 3...

Actually I guess it was only putting results for CT VIN numbers on bottom. I tried with other vins (begining with DD and EZ ) and they seemed to work fine. I am usure why results were different for "CT" VIN's

Hi Billmeye, That is more like what I wanted. Although when I search by VIN for some reason my results still show up at the bottom (Maybe it needs to be assending for vin?). So it is not possible then to have it show only tracking number instead of tracking number and null? (Same with VIN and...

Hi Billmeye, I replaced it with that and it is not searching correctly. (That is what I tried before I asked you). When I replace it, It does show records without tracking numbers but for some reasonwhen i search by tracking number, it wont filter. Also filtering by date code or VIN acts up as...

Hi Billmeye, Thanks for your help! That is almost exactly what I was hoping for! I also want to be able to search even if a tracking number isnt in the record. I tried adding Or ...tracking number...is null (like the other two) but for some reason it did not work. WOuld you mind editing the...

Hi Billmeye, Thanks for the help! I replaced the row source with your code, but a "enter Parameter Value" box keeps popping up. The file is attached.

I also noticed that the part search does not bring up records if they do not have a VIN in their record. Sometimes we get returns with no vins. The query or search results is programmed in some way in which it wont return results that do not have a vin even if you leave the vin search box empty...

That did the trick Billmeye! I feel stupid now. Its been a long day Haha. Thank you so much!

Hi Dale, Here is the database. Hi Billmeye, I tried using your code but it change anything, except I get a message box instead of error now when I click to load record. I appreciate all the support!

Hi, I recently just created a search form where users may enter 3 types of criteria, with results showing below in a list box. When a user double clicks the result it brings them to the whole record. For some odd reason when I close out of the database and reopen the search form, My cursor will...

When I close out of the database and re-open it, It wont let me type any numbers in the boxes of the search form and I get a syntax error 3075 for the open form cmd line for the search box.I dont know how to fix it :/

Thanks BrotherBook! I do like the list because it shows you instantly if a record is available which meets your criteria, but at the same time I was thinking of just having a button that takes you directly to the record. Is it possible for either method to have the search window close after...