May 26 2006, 12:03 PM
...............A bit new on UA and quite thankful to all Access Gurus..
I have a 1500 (and growing) record database in which I have a Search Form to return values based on items selected from drop-downs [or typed field values]..
Can anyone PLEASE help... I've found this sooooo hard/impossible to do..
i.e. a range of account numbers....
i.e account falling within a certain date range...
Regards and Thanks in Advance!!
May 26 2006, 12:16 PM
I have an example database with a few different ways to do a search form...as soon as I find it I will post it!
May 26 2006, 12:22 PM
Ok I found it! I created two different forms. One that shows you how to do a search using SQL code, and one that uses queries. I personally choose writing SQL code, but some people are more comfortable with queries...it is up to you! If you have any questions please let me know!
May 26 2006, 12:34 PM
will show you how to search using multiple criteria and is very flexible. The code may look a bit daunting, but it is not that tricky once you get into it.
May 26 2006, 06:11 PM
I'd rather use the code like you. However, is it possible to select more than one field...?
I have about 8 fields on the search form.... to search. Thanks again.
May 26 2006, 06:16 PM
I am not trying to butt in on Kristen, but I would suggest you take a look at my previous post as the article I suggested does exactly what you want.
With apologies to Kristen....
May 26 2006, 07:00 PM
Please do not feel as if you were intruding.. your comment and help is quite welcome. In fact I am also looking at the Article..
I am still working my way through the codes as it is a bit daunting...
May 26 2006, 07:05 PM
The code will come together for you, I believe, once you start implementing it. Add your combo boxes to your search form but only add one bit of code for one combo box and when you have that working go on to the next bit. Before you know it you will have it working.... Good luck!!
May 26 2006, 07:08 PM
Thanks a Million...I'll start working on that now..
May 27 2006, 04:02 PM
You are welcome and good luck!
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here