Access 2007-2016
Access 2000-2003
Access Seminars
TechHelp Support
Tips & Tricks
Access Forum
Course Index
Topic Glossary
Insider Circle
 
Home   News   Tips   Glossary   Templates   Forums   Help   Logon   Order   Contact Us  
 

News      User Comments     History     Notify Me

4/27/2011 4:32:49 PM
Access Tip: Multi-Field Search Form
By Richard Rost   Richard Rost on Facebook Richard Rost on Twitter Richard Rost on Google Plus Richard Rost on LinkedIn Email Richard Rost

 
One of the most requested questions I get asked is how to create a multi-field search form in Access. Well, I put together a short 10-minute free video for the ACCESS TIPS section on how to do this.

This is only a TEENY, TINY preview of what's to come in the Search Form Seminar I'm preparing, which will be released after the SQL Seminar parts 2 and 3. There's SO MUCH more you can do with search forms in Access... but this will get you started.

Permanent Link
Keywords: search form like wildcard access tips
Post Reply

ALike Comment from Bernard Goah @ 3/14/2013
Thanks a million, Mr. Rost! Now, I can enter Like freely.
Show Just This Thread        Post Reply
ALike Comment from Bernard Goah @ 3/14/2013
"ALike"  keeps appearing.  I just want to type "Like". Someone please make it stop. I am using MS Access 2007.


Reply from Richard Rost:

You may have ANSI 92 compatibility mode on. Go to File > Access Options > Object Designers > Query Design > and make sure the checkboxes are OFF under SQL Server Compatible Syntax (ANSI 92).
Show Just This Thread        Post Reply
New Access Tip Search Form Comment from Brad Y. @ 5/15/2012
I got the search form working really easily.  Thanks!  

My only problem is that I can only run the search once, then I have to close the query.  Once I close the query I can then run a new search from the form.

On your video you didn't have to do this.  You just continued to ajusted the filters and click Run Query.

How did you do this?

Thank you much.


Reply from Richard Rost:

I'm pretty sure I was closing the query in the video each time, I just didn't specify it. You don't see me click on the close button because it's out of the video frame. If you don't want to have to do this, use a FORM based on that query, and you could just issue a Formname.REQUERY command which would refresh it.

Show Just This Thread        Post Reply
I found it Comment from zaher @ 4/1/2012
Hi Richard
after i sent the last thread  I found my mistake: I wrote with one criteria field "=forms" expression, but when I delete these criteria the form work very well, but I think we have to refresh query after we click run query button to work. So can we make the button do the two functions (run query and refresh it)? and how can i add (=forms) expression without any proplems?
Thank you again for your hard work
Show Just This Thread        Post Reply
working just one time Comment from zaher @ 3/31/2012
hi and thanks for thise great video, i try the with my data and worked very nice, but for one time, then it stopped to work, and i try to make another one but does't work at all, so what's the problem?
Show Just This Thread        Post Reply
New Access Tip Search Form Comment from Josef Stirnimann @ 2/28/2012
Hello, I enjoyed your 10 minute video of the access search form.
Show Just This Thread        Post Reply
New Access Tip Search Form Comment from Tandin Phuntsho @ 6/14/2011
Dear all,
i know that working with access is very effective and very helpful but i have a problem in creating a search form in access and in importing data from excel to access, so please help me.

with regards


Reply from Richard Rost:

Creating a search form will be the topic of an upcoming seminar. Importing data from Excel to Access is covered in Access 308.
Show Just This Thread        Post Reply
New Access Tip Search Form Comment from Farman Ullah Khan @ 5/16/2011
please in want to learn in access 2000 in form all tool box commands.

can this is possible?
i am trying every day but i am not clear in this tool box.



Reply from Richard Rost:

The tool box contains all of the objects that you place on your forms. I cover all of them in quite detail in my tutorials.
Show Just This Thread        Post Reply

Add Your Comments or Subscribe
 
If you just want to subscribe to get email updates when the News is updated, then enter your name and email address and check the Notify Me box below. If you would optionally like to add your comments below to be posted, they are welcome.
 
  Your Name:  Required
  Your Email:  NOT Public
  Subject:
  Comments:

 

Sorry about this step. It's just to keep the spam bots away:
  Verify: What is 6+3:
  
  Notify me when the News is updated.
  Remember Me for my next comments
  
 
 
Please do not use this form for Customer Service inquiries! If you have questions about your account, shipping info, courses you've ordered, need passwords, etc. please use the Customer Service Center instead.

I value your comments. They will be displayed on this page (above). Your name will be displayed, but your email address will not be.
As always, I promise to never give away your personal information to anyone else, ever.

NOTE: If you don't leave your name and email address, DON'T expect a reply. I can't promise a personal reply to everyone who posts here. I TRY my best, but I cannot guarantee it. If you don't leave your real name and email address, I won't even bother. I usually just hit DELETE. -Richard

 

 

You may want to read these articles from the 599CD News:

8/25/2018NEW: Access Dev 9, 10, 11
8/25/2018Microsoft Access Developer 11
8/25/2018Microsoft Access Developer 10
8/25/2018Microsoft Access Developer 9
8/23/2018Access Dev 11 is ONLINE
8/17/2018Access Dev 10 is ONLINE
8/15/2018Access Tip: Search Form
8/15/2018Access Tip: Locked v. Enabled
8/15/2018Access Dev 9 is ONLINE
7/31/2018Microsoft Access Developer 8
 

Learn
 
Accessindex
Excelindex
Wordindex
Windowsindex
PowerPointindex
Photoshopindex
Visual Basicindex
ASPindex
Seminars
More...
Customers
 
Account Login
Online Theater
Downloads
Lost Password
Free Upgrades
Insider Circle
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Articles
Search Our Site
Waiting List
Production Schedule
Collapse Menus
Help
 
Live Chat
Customer Support
WalkThru Tutorials
Troubleshooting
FAQs
TechHelp
Consulting Services
About Us
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Order
 
Video Tutorials
Handbooks
MYOLP Memberships
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Gift CDs
Contact
 
Live Chat
General Info
Support Policy
Contact Form
Email Us
Mailing Address
Phone Number
Fax Number
Course Survey
Facebook    Twitter

Google Plus    LinkedIn

Blog RSS Feed    YouTube Channel
Richard Rost Microsoft MVP