Microsoft Access
For better or worse, I’ve spent a great deal of time in my professional life working with Microsoft Access. Most of what I’ve done has involved solving problems or meeting very specific business needs. This page contains a number of sample databases that you can download that demonstrate how to do certain things that I’ve found useful. I’ve made them availble, hoping that others will find some use for them as well.
I should mention that much of what I’ve learned about VBA, Access, and databases in general has been through correspondence in newsgroups and with the aid of other online resources. More specifically, the Microsoft MVP community has been an invaluable resource when I’ve had to figure out how to do various things.
Label Chooser:
Access has a nice wizard for setting up reports to match various commercial label sheet layouts. This is useful for printing batches of address labels but your final sheet often ends up with remaining unused labels. This database demonstrates a solution that that allows a user to select a label position on an Avery 5160 Label Sheet. It uses an Option Group on a form that is laid out to mimick the layout of the label sheet. The same concept could be used for sheets with different column/row layouts. I suppose you could also tweak this to queue more than one label to “finish off” a sheet by selecting a starting position.
