Okay so I am pretty new to vb and ms-access. Ive been practicing and building a database and im having issues with the search options. Basically Ive got 2 forms, form1 is mainly for searching through the database which is on form2. There are 3 textboxes to search from on form1 and they need to search simultaneously with a search button (length, Width, Thickness). The textboxes would only be searched using numbers. The database saves everything perfectly according to (length, Width, Thickness) but now i wish to search using these 3 boxes and find something that is closest to the numbers i put. The range should be like anything with 5 extra or 5 less, meaning if i put the length at 100, it should show the saved items on the database with the length of 95 to 105. All 3 textboxes should work the same way. But they should work together simultaneously to find the correct item. Any assistance would be greatly appreciated
0 Answers
Related