Free Access Help and Access Examples
Database Products
Shell Database
Missions
Software
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 - Free Drop Down Designer
Saves you hours every time you start a new project
Create a user interface by simply editing a table
Add 5 Drop down menus that are six selections deep
Build your forms and reports and just add the names
to the setup table for an instant GUI!
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.
Spin 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.
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.