UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Changing Forms A Query Searches From, Access 2016    
 
   
RustEE
post Oct 21 2019, 02:22 PM
Post#1



Posts: 3
Joined: 21-October 19



Hello.
I am currently making a search function for customer information in a database, and can see a future need for an advanced search.
Right now I will give the users a small number of parameters to search with such as Customer Name, Customer Number, Machine Number.
This search will cover most cases, but what would be the best way to go about setting up an advanced search where they can search using all fields in the table?
A couple ways I can think of doing this is to simply make a second query that will use criteria based on another form with all the fields in it.
Another is to find and replace the table name in the SQL code using VBA, however this seems like a lot of work.
Does anyone have a better suggestion?

Thank you all in advance.
Go to the top of the page
 
theDBguy
post Oct 21 2019, 02:27 PM
Post#2


Access Wiki and Forums Moderator
Posts: 76,606
Joined: 19-June 07
From: SunnySandyEggo


Hi. Welcome to UA! welcome2UA.gif

Have a look at our Code Archive for some examples of different ways to create a search form.

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    21st November 2019 - 02:48 PM