Access help - Free, Access Tips and Access tutorials

Free Access Help and Access Examples

Database Products

Team Purchasing Database

Shell Database

Missions Software

Training Products

Services
Office Automation Services

Great Offer!
Huge Example Database for MS Access Developers!

Syndicate Jon's articles on your site! Fast, Easy & Free!

Access Help Examples Ebook *** Now Updated with Ten new examples!
  Take a Look at this mini app that can be found only in our Access Help Examples Ebook.  Our Access Ebook contains 15 mini applications that you can use to enhance your databases.  Take a look at this one to see what I mean. 
Splash Screen with Drop Down Menus
 

Get our Drop Down Menu Designer FREE!Access help - Click to see the UI, Access Tips, Advanced Access help
 Access Help - Free Drop Down Designer
access database help, drop down menu designer  Saves you hours every time you start a new project
access database help, drop down menu designer  Create a user interface by simply editing a table
access database help, drop down menu designer  Add 5 Drop down menus that are six selections deep
access database help, drop down menu designer  Build your forms and reports and just add the names to the setup table for an instant GUI!

free, access help, access examples, access tips
Free Access Help Examples

(No sign up needed just Right click and "Save AS")
Please see our Feedback form at the bottom to be the first to get new tips as they become available.

General Note:  
Any of the Access tips below that use a recordset will require you to activate the Microsoft DAO 3.6 Object Library for them to function correctly.  While the VBA editor is open look for Tools/References on the Toolbar, then check the corresponding box on the pop up form.  These examples were developed with Access 2000 & 2002.

Wildcard match on a number field -
Here is a quick way to do a wildcard match on a number field using a simple query command

Flashing Highlight bar - Make a flashing bar on a form

Highlighting Menu Buttons - Example form and module code that creates menu buttons that highlight as the pointer moves over them.

List Box Select - Example form that shows how to select a record from a list of records displayed in a list box. 

Access Tips - sample Buttons - Example form with Interactive buttons that highlight when given focus.  In this example all the code is contained in the form.

Print Reports - Example form that finds all your reports and displays them in a list box where you can then print the report you want by selecting it and clicking the print button.  

Clear Temporary Tables - Code to clear/delete the contents of temporary tables.

Hide Combo Access Tip - If you have a form with several combo boxes, the dropdown arrows can make it look cluttered, especially if you are using a different background color.  Here's an easy way to hide them.

PopUp Help - Create your own popup help that responds much faster than context help with this Access tip.

Progress bar - Display progress of a loop of commands with this Access example code.

Cash flow /Check Register - Monitor your cash flow events and do "whatifs" based on changing cash flow dates with this Access Example.  Also will work as a check register.

Automate Email - This form will send an email to every customer in the customer table that is in the country that you select on the form before you press the send email button.  The email will take as the body of the form what ever you type in the memo field on the form.  Look at the code in design view for detailed instructions. One of the best Access tips on the page.

Add a button to search the Web - Add a button to a form to allow your users to open a web search based on user input. 

List your database schema to a text file - Need to document your database design?  Use this code to dump the schema to a text file to help you document your design.  Learn several Access tips for coding in this VBA code.

Find all the dates in the same month and year - Instantly filter for all your client birthdates in the same month by clicking on a date.

Display the time on your form - This form has time calculations and has a field that updates every second with the latest system time.  Enter a birth date and it calculates days, hours, minutes, and seconds you have lived.  One of the fun Access examples.

Another way to highlight buttons - Another cool way to highlight buttons as you move the mouse over them.

Check Box All Toggle - Here is a quick way to have a check box on a form toggle to all select or all deselected.

Compact/Repair button for your users - Here is the code to put on a button that will compact and repair your open database so your user applications don't continue to bloat out of proportion.  This is an Access tips got to have.

List Box Multi-select Delete and count - When you have a list box it is handy to be able to multi select to perform some action on multiple items in the list box. Here is a simple set of Access Help instructions to get you started.

Track User Activity -   At times you will find it very handy to know what a user was doing in your application at a specific time.  Follow these 3 simple steps to create a user log table.

20x Speed up for Reports - Use this Access help technique to reduce processing time when querying a large number of records in your database for reporting. This technique works well with Access, MySQL and SQL Server databases as well.

Free Access Help - Random Number Game Access TipSpin to Win Random Generator and game - Get the Access code for this random number generator and learn animation techniques.  Also, spin the numbers and send us your results. If it matches ours you win $100!  It's that easy!  ...One of the fun Access Tips.

 Add some Pizzazz with this Form animation tip - Here is one of our Access tips that could add some pizzazz to your user interfaces in your applications.  This example will let closes a form by shrinking it down dynamically on the screen.  It makes for a really neat affect!

Self Learning  Combo Box - Reduce data entry and input errors with this Access Help tool.

Delete Check - Prevent broken relationships in your database caused by deleting a record that other data is referring to. 

Color Coding a continuous form  Color coding adds value to a form as it easily directs the user's eye to critical data. This is a powerful technique that allows a user to quickly evaluate a pages of data for errors or warning information.

Using variables in the query design form  In this example you are going to learn how to enter or select data in one form and open another form with more data related to the field you just selected by taking advantage of global variables in the query design form.   Instruction and sample mdb included.

Use an array and SQL statements to rapidly create closely related data  In this example I show how to create a table of similar data that may only have a date in difference. 

Self learning Pop Up fill in form   Drop down arrows from combo boxes can become ugly and take up too much screen real estate on a continuous form.  To solve that problem here is a simple tool that helps with data entry and also has the added benefit of minimizing the size of the drop down arrow that you would have from a combo box.

**New**  - Display a Picture   Here is a handy tool you can use to display pictures in a form.  Load pictures and store the filenames in a table.

Here's a tip.  We have provided this service for free for over four years.  Tens of Thousands have downloaded  Access tips and tutorials over that span of time with very few actually buying a product or even giving feedback.  Life is not free.  It costs money to keep this site open.  It takes time and effort that without remuneration means we can't keep this information available.  If you have found a tip or tutorial or newsletter helpful, then please buy a product to help keep this site open. 

                                                                                             

Feedback Form

Please give us your feedback.  We need to know if these examples are meeting anyone's needs and if you are using them. We also want your suggestions for new tips.  Also, if you want the latest new tips in your email box first then please provide the information below.

*Full Name  *City/State
*Email        *How did you find us?

 Please give us your feedback.  What type of tips would help you in the future?
 Are these tips helpful?

                              

* Required fields
 
  We will send notification to email address provided.  See our Privacy Policy

              The Management.

©  BioMation Systems, Inc.  2004 - 2007
home l about us l buy l our product l services l contact