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

Articles

Services
Office Automation Services

Great Offer!
Huge Example Database for MS Access Developers!

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

Link to us
You are welcome to link to articles and tips on our website

  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

  "I just wanted to say that I am absolutely thrilled with the material in your book! It has made me look like a genius at work. The  menus look terrific and some problems I was having putting data into fields was driving me crazy. I have not programmed for a long time and was stumped by some minor things. Your book helped me go over the top. Definitely worth more than an hour of my time. Some of the issues I struggled with for a day and a half. With your help, I solved the problems, and look really good to my boss.  Thanks a million, really!"
K  Gawne   Waterloo, Ontario

 

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 
(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.

New **  Form  Open Code -
 When selecting forms to open from a menu, a previously selected form may be minimized. Normal open code will error out but this function checks to see if it’s open and restores the form.

User Submitted Tip - Shade every other line in a report - use this simple set of instructions to create easy to read reports. Especially helpful in longer reports.  Thanks to Brian Battles of Hartford, CT.

The case for Select - In this example, I use the power of the Select command to loop through my checking records and update the account the record is based on the value of data in another field.  Using the Select command I can loop through the records matching the values in the description field with Cases of the Select command and define the right account to put the record in. 

Find a file with filedialog - use this tool to find a file dialog box you are familiar with. 

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. 

Get our Huge Example DatabaseDisplay your company name on the splash page
 Access Help - Team Purchase Database
access database help, drop down menu designer  Get our Professional Database Example with 100 Forms and dozens of modules, sql, VBA source and more you can learn from!
access database help, drop down menu designer  Learn advanced user interface techniques like splash screens, where used, and dashboards
access database help, drop down menu designer  The last place you will look for hundreds of advanced techniques you can use over and over
access database help, drop down menu designer   This is a multi user advanced professional application that has more tools than you will find anywhere else on the internet and it is 100% Guaranteed.

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.

You may want to tell a friend about this site. Fill in the space below and click the button.  We will send the url to the address you enter. 

Tell a friend:

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.

 Check out our Database products
 Access Help - Database Applications
access database help, drop down menu designer  Customizable database shell - Create an advance user interface in minutes
access database help, drop down menu designer  Job Invoice Database System - manage  your AC or Pool Maintenance jobs, invoices and schedule
access database help, drop down menu designer  Missions Horizon - Mission Trip Management System
access database help, drop down menu designer  PicNamer - Digital Picture Namer
access database help, drop down menu designer  Email Automation Tool - Automate keeping in touch with your customers
access database help, drop down menu designer  Backup Utility - Automate backup of your key files
access database help, drop down menu designer  Team Purchase Database - Multi department purchasing control database

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.

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.

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.

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 - 2008
home l about us l buy l our product l services l contact