My MS Access Blog
Tips, tricks, best practices and more about Microsoft Office Access and Visual Basic for Applications (VBA). Links to great articles and posts around the web plus some things I've learned that I'd like to share.
Take a look at these video tutorials on YouTube. Crystal has started a great series of video tutorials. Crystal is an imprtant part of the UtterAccess community, she's a Microsoft Access MVP, and she's posted a great "Access Basics" reference here.
at
6:56 AM | Permalink
|
Tweet this!
| Add This!
| Blog This |
0
comments
Take a look at this Video How-To: Make a query ask for input. It's a great first place to start if you want to learn how to have queries prompt for input, or use a form to provide the criteria for a query.
Quote:
Want to make your query ask for input when it runs? Watch these demos to see how you can add parameters to a query, handle input that is the wrong kind of data, and use a form to collect parameters and then use them with multiple queries.
at
9:23 PM | Permalink
|
Tweet this!
| Add This!
| Blog This |
0
comments
Handling record delete properly can make your applications much more usable. Think about the right confirmation prompt, and about doing any associated clean-up thast goes with the deletes. I've coded some delete functions that considered all of this and truly made sure the user understood what they were going to delete and then, after confirmation, cleaned up all the associated records.
This video how-to from Microsoft walks through some of the basics and will help you get started creating more professional record delete routines
at
9:05 PM | Permalink
|
Tweet this!
| Add This!
| Blog This |
0
comments
Access 2003 resource Centre on MSDN
Access Developer Portal on MSDN
Allen Browne's tips for Microsoft Access Allen Browne is one of the web's leading authorities on Access. Several of his articles are the standard reference for the topic at hand. Allen is also the most often cited cataloguer of Access bugs and the related work-arounds.
The Access Web This site, established way back in '98, features tips and solutions from several Access MVPs. The code samples posted here are always clean and effective. Often you won't find a lot of text, but you will find code that works. The solutions here are cited all over the web as the best way to get things done.
Stephen Lebans' site is the authority on the web for some types of solutions. It's a site every Access developer should know. You'll find tips, plus downloadable working solutions ranging from zooming images in and out, to disabling the mouse scroll wheel, to a calendar, to creating PDF files. In particular I look to Stephen's site first for advanced topics related to forms and reports, especially interacting with the Windows API.
