Tips found in this section are a collection of information that was developed in-house, read from books and found in newsgroups. We only ask that you acknowledge the original author when using their code by including the tag line indicating the source of the code, where noted. Thank you!
= Click to download file (An unzipping program is required)
= This means the file and/or has been updated or is new
There is no free support for the tips offered on these pages; use at your own risk. You may eMail for broken links (see lower right) or corrections. However, ( please ) no personal eMails for assistance or support. You will be charged if you send unsolicited eMail requesting support.
For free support or assistance please visit one of the many newsgroups, a few of which are listed below:
Simulate a Drop Down box (not a Combo Box) as seen on Web Pages (Access 2007 and higher)
The difficult I do immediately, the impossible takes a little bit longer.
Customize the Quick Access Toolbar (Access 2007 and higher)
How to use Windows System Colors (Access 2003 and earlier)
Where are the Options? (Access 2007 and higher)
Options for Current Database (Access 2007 and higher)
Trusted Location (Access 2007 and higher)
Export Specifications (Access 2007 and higher)
Import Specifications (Access 2007 and higher)
Make Controls resize with a form (Access 2007 and higher)
My favorite since the NNTP's went away!
(All samples in Access 2003 unless otherwise specfied.)
Switch Windows (Access 2007 and higher)
Navigation Pane Options (Access 2007 and higher)
"Little else matters than to write good code."
= Sometimes code lines can be very long! Where as, I have to break a line of code to have it fit better on a page. So when you see the symbol, to the left, it is to indicate that the line below is a continuation and that the code should be written as a single line. So this..
If you found this site helpful then...
= Data Model
Last modified on February 17, 2013
© 2011-2013 Regina Whipp
Site designed and maintained by Regina Whipp
...for old (and new) tips.
= Click to provide us feedback
<blah, blah, blah, blah,
<blah, blah, blah, blah, blah, blah>
Is there a Data Model you would like to see here? Click the ballon...
Object Designers (Access 2007 and higher)
"You can watch the Office 15-Minute Webinars live, or view them later. They run 9:15 am to 9:30 am Pacific time on Tuesdays with a live Q&A session to follow."
Send eMail to Multiple Recipients (using DoCmd.SendObject)
Set Subdatasheet to [None] (Access 2003 and higher)