When developing Access applications, I always start from scratch as all of my databases are unique in what information they store as well as how they store it. However, there are some things that I use from other sources. Take for example the mvps.org website. The Access website that can be found there contains code that I have found to be very useful. A while ago, I found a bit of VBA code on this site in the Access VBA forum that was from Bob Bedell. It was code for a splash-screen form. Now, I needed a splash-screen form for my Music Inventory 2001 database and I got what I needed here. A lot of the things I find relating to VBA code samples are customized to fit my own needs.

  When looking for an already implemented solution, I don't just look on the internet. There are Access databases on my local computer that have what I can re-use. What I do to bring them into my database that I'm working on is this: I just do a copy in the source database, open the destination database and paste it in there. That way, I'm saving myself a lot of headaches.

Ben Horne
Madison Area Technical College - Truax
3550 Anderson Street
Madison, Wisconsin 53704-2599


-------------------------
http://community.webshots.com/user/valerian114

"There are two kinds of people in the world: Those who claim to be Flash junkies and those who actually are Flash junkies"