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!
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!" |
|
Get our Drop Down Menu
Designer FREE! |
Saves you hours every time you start a new project
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 Database |
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. |
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
|
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.
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.
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.
* Required
fields
We will send notification
to email address provided.
See our Privacy Policy
The Management.