You are here: Advisor.com » Advisor Guides » Microsoft Access Advisor » The Advisor Guide to Microsoft Access database for solution developers and advanced users, covering Microsoft Office Access, Microsoft Office System, Microsoft Excel, Microsoft SQL Server, VB language, MS Access with Microsoft SharePoint, Windows Server System, and more...
My.ADVISOR.com Sign-In
Microsoft Office Access Database Design, Development & Deployment
You can use Access' inline functions to manipulate and extract pieces of data from text fields in order to perform operations (such as sorting) on a part of the data instead of the entire field.
In a previous tip, you got some code to select files. But, what if you're using Access 97 and, therefore, can't take advantage of the Split function. Here's an alternate solution.
Here’s a tool that SQL Server has and Access doesn’t: The ability to generate SQL Scripts that can be used to recreate your table design in SQL Server -- or any other database server.
When your program stops working, you need to know what you've changed. Here's a utility that will let you quickly compare the old and new versions of your code—or any text file—to find out what's different.
You've made a change to your application and, after much work, have realized that it's all been a horrible mistake. How do you get back to the working version?
You can save yourself time in maintaining your applications by reusing subreports to report different data. However, changing the underlying data for a subreport means that you need to determine the order that Access processes your reports -- not an easy task.
The newly available Access Runtime and Access Developer Extensions provide you with a new mechanism for distributing your Access applications. And the good news is: They're free.
The SQL Top query lets you retrieve a subset of your data that you feel is important -- or random records. You can even use VBA to create a Top query that lets you interactively control how may records you will get.
Instead of making design changes to every application you create, you can customize your applications using an options table. One table and a little VBA code can make your life easier.
The first step in managing the user's display is finding out what settings are in effect. Here's a class to get that information for you, along with the underlying Windows' API calls if you want to do it yourself.
Do you distribute your applications using the Access runtime version? If so, find out how you can easily take advantage of the Access 2007 runtime version.
In Access 2003 and earlier, you can build one of the new features of Access 2007: the ability to use e-mail to send data to users -- or to another Access application.
Read the advanced guide to creating custom business database solutions with FileMaker software. Subscribe now to gain access to all the archives and downloads.
Learn the fundamentals of using FileMaker Pro software. Every issue gives you step-by-step instructions on creating the databases you need. Subscribe now!