Access & VBA

Here's another picture of my 1976 Datsun 280Z. I still can't decide on how much it's worth. You can see that it still looks in pretty good shape, but looks can be deceiving. Datsun's are notorious for having rusty frames and this one is no exception. Although I have seen kits to repair this type of damage, the labor would be costly. But for someone with a big checkbook, who is looking for a classic sports car restoration project, this would be the ticket.

This week, I spent most of my time working with Microsoft Access to create a database to help me manage AV equipment. I do have some sql database experience, but have never created a database with Access. Fortunately, I found a good book (Access 2003 for Windows Visual QuickStart Guide) that got me started. They don't have a lot of Visual Basic code examples in the book, but by looking at examples on the Internet, I was able to build some automation into my forms. I was scratching my head at times as I tried to get seemingly simple things to work. Once I got one thing working, I would go onto the next. By the end of the week, I had loaded all of my AV data into tables and created a form that would pull in data from those tables and email the information to people assigned to specific projects. Access is a very capable solution for anyone who's data has outgrown Excel in a small office.