Free Lessons
Courses
Seminars
TechHelp
Fast Tips
Templates
Topic Index
Forum
ABCD
 
Home   Courses   Seminars   Templates   TechHelp   Fast Tips   Forums   Help   Contact   Join   Order   Logon  
 
Home > Courses > Access > Templates > Search > Instructions >
Access Search Template

Microsoft Access Search Template. Sort. Filter.


 S  M  L  XL  FS  |  Slo  Reg  Fast  2x  |  Bookmark Buy Now

Introducing the Access Search Template from Access Learning Zone. This template has everything you need to be able to search and sort by any field in a Microsoft Access continuous form.

It includes one of the most popular features from my very successful Access Search Seminar. Lots of people tell me they want this functionality, but they don't want to watch nine hours of video. So, here's the most popular feature from that Seminar in a quick, easy-to-use Template.

Videos

Sample Database

If you'd like to download a sample copy of the database template, you can do so here. This is a non-editable ACCDE version of the template which will let you see it work in action. You can enter/edit data, but you cannot access the design of the forms, reports, VBA, etc. The sample database requires 64-bit Access 2013 or higher. If you're still using 32-bit Office, read this. Be sure to watch the Introduction video (above) to see how to use it.

Full Developer Database

Once you have purchased the full developer database template, come back to this page and click on the Download button below. This will give you access to the ZIP file containing the Template ACCDB file. The full version will run on 32-bit or 64-bit Access 2007 or higher. Be sure to watch the Integration Instructions video (above), and visit the Instructions page.

Links

 

 

Order Now

Contents

The Search Template includes one of the most popular features from my Access Search Seminar. You can sort any field with a single click (click again to sort descending). Filter any field (equals, like, or range search). Triple-state checkbox for yes/no fields.

Sort by any field with a single click.

Click again to sort descending.

Filter by any field, multiple fields. Select And/Or conditions.

This is not a seminar, so I don't explain all of the source code and how it was written. I do, however, include step-by-step integration instructions, both in writing and as a video. This will allow you to set up your database to use my code. It's just configuring your fields, copying & pasting some code, and putting the pieces in place where I show you. Easy to do.

 

So that's the Access Search Template. This template is easy to integrate into your existing databases. There are 13 steps which are all written out and explained in a video. I do strongly recommend you at least watch my free Intro to VBA tutorial before purchasing this template so you have a basic understanding of VBA.

As of right now, I don't have any plans to make videos showing how the code was written, as there is a lot of high-end VBA in it. If you are interested in me releasing this as a Seminar where I show how it was constructed (or at least walk thru the code) I would be happy to make one if there is enough interest. Post a comment below.

Order Now

License

For internal use only. This template does NOT come with a royalty-free license. You may only customize the template for your business needs and for use within your organization at one location ONLY. You may not resell or distribute any form of this template to others without express written permission. Contact me for additional information on obtaining a license to distribute if you plan on including this template in a product you are reselling. Additional licenses are required if you plan on using this template with more than ten (10) employees or in multiple locations within your organization.

Customize For Your Needs

If you would like to discuss customizing this template for your needs, and integrating it into your current setup, please see my consulting page for details. While I no longer accept custom jobs that are specific to a single user, I may include your features in a future version of this template if they have mass appeal. If you are looking for custom enhancements made to this template just for you, visit my Developer Network.

Technical Support

Please note that technical support is NOT guaranteed for any of my courses, seminars, or templates. If you require help with modifying this template, you may post a question in the Forums, however an answer to your question is not guaranteed. If this template comes with an accompanying Seminar, then you should purchase that Seminar to see how the database was constructed. If not, then you should have taken the suggested courses. Most of my templates are designed on a Developer level and you should have a thorough understanding of SQL and VBA before attempting to modify them. 

Questions?

Got sales or customer service questions about this template? Feel free to contact me. If you have technical "how do I" questions about this template, you discover a bug, or want to suggest a new feature, then please post your comments below.

Keywords

microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, #template, find records, locate records, search, filter, sort, ascending, descending, search in microsoft access, search and filter in microsoft access, search criteria, search box, search form, search by text box, example, download, free template, vba search form, search form multiple fields, go to specific record

 

Comments for Access Search Template
 
Age Subject From
25 daysCombo BoxRamona Woitas
46 daysNaughty VBA CodeNathan Shepard
6 monthsTable Names in Search TemplateRichard Dobson
6 monthsJust an observationBob Wolinski

 

Start a NEW Conversation
 
Only students may post on this page. Click here for more information on how you can set up an account. If you are a student, please Log On first. Non-students may only post in the Visitor Forum.
 
Subscribe
Subscribe to Access Search Template
Get notifications when this page is updated
 
 

Check out these other pages that may be of interest to you:

11/25/2022Application Title
11/24/2022Full HTML Editor in Access
11/24/2022Change Database Title
11/23/2022Other Names
11/21/2022Check Icon File
11/21/2022Check Icon File
11/18/2022Archive Records
11/17/2022InStr Function
11/16/2022Numbers As Text
11/15/2022Merge Tables
 
 

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
amicron@gmail.com
Blog RSS Feed    Twitter

YouTube Channel    LinkedIn
Keywords: templates access find records, locate records, search, filter, sort, ascending, descending, search in microsoft access, search and filter in microsoft access, search criteria, search box, search form, search by text box, example, download, free template,   PermaLink  Microsoft Access Search Template