NAVIGATING DIFFICULTY

NAVIGATING DIFFICULTY

Showing determination in the face of fear makes us extraordinary....

Read more
STARTING FROM SCRATCH

STARTING FROM SCRATCH

In case you were wondering, yes; ever since I was a school boy, I’ve loved to wear button-up shirts, vests, ties, and...

Read more
MESSAGE IN A BOTTLE CAMPAIGN

MESSAGE IN A BOTTLE CAMPAIGN

Did you know, the first message in a bottle was sent in 310 B.C. by the Greek philosopher...

Read more
Homepage / Technology & Programming / MS Office Suite

Reading Time: 2 minutes Why Access? All of my programming actually happened while I was going to school for accounting. This was back in the day when you had to manually hand-write out your ledgers…yeah. Then along came a program called Microsoft Excel. Once I started playing around with the program I was blown away. All of those pain-staking nights of hand-writing out everything and then I found this automated way of doing the same thing (only I didn’t have to worry about the math being carried over to another ledger incorrectly). Of course, I played and played with Excel and then I learned about VBA! It was like another layer of fun for me because not only could the math still be taken care of but I could begin automating all of the functions as well. Next, I just dove right in (no holding back). I discovered a little fact about me that I didn’t know before and that was the fact that I am a natural at programming. I picked up the code so quickly it even surprised me. Many of my spreadsheets actually began getting so large I had to flip over to databases and then Access entered the scene. I was having so much fun with Excel and the VBA behind the scenes Access came that much faster. Really, now I use them both very often and I love doing anything and everything in VBA (with both Excel and Access). My Projects Currently, I have this one DB to get this page started. I will be adding more projects as time goes on. My Projects(s) Simple Database This database was created to allow for tracking in case the network connection went down at my job (which was pretty often). The fun part is when you start using the VBA (Visual Basic for Applications) because you can do some fun things with your MS Access database. If you would like to poke around at this one, please feel free to download by CLICKING HERE. Helping to Index Everyone wants information and they never want to wait for it. Working in an industry where peoples lives are impacted by your ability to retrieve information quickly I found the shortest database is better than the longest memory! I created a database that I could quickly search/ping for random bits of data. Granted, in this copy I’ve left here for you to download doesn’t have a lot of the more “sensitive” information in there but in the HazMat section you’ll be able to see it working. Feel free to add your own modifications to the file or the code as you need to. I use this one a lot to help me quickly recall different codes, phone numbers, or anything really I would need to put in there here’s a copy for you to download.   Summary of Downloads & Extra Links   Getting Help The Best Help Place My Project Downloads Example of Tracking DB Helping to Index Links I found Helpful Hiding the Access Window Using VBA Information: Limits of the DB Print Preview Before Print

Read more

Reading Time: 2 minutes Why Excel Rocks My discovery of programming actually happened while I was going to school for accounting. This was back in the day when you had to manually hand-write out your ledgers…yeah. Then along came a program called Microsoft Excel. Once I started playing around with the program I was blown away. All of those pain-staking nights of hand-writing out everything and then I found this automated way of doing the same thing (only I didn’t have to worry about the math being carried over to another ledger incorrectly). Of course, I played and played with Excel and then I learned about VBA! It was like another layer of fun for me because not only could the math still be taken care of by utilizing the many cell functions but I could begin automating all of the functions as well. Next, I just dove right in (no holding back). I discovered a little fact about me that I didn’t know before and that was the fact that I am a natural at programming. I picked up the code so quickly it even surprised me. Many of my spreadsheets actually began getting so large I had to flip over to databases and then Access entered the scene. I was having so much fun with Excel and the VBA behind the scenes Access came that much faster. Really, now I use them both very often and I love doing anything and everything in VBA (with both Excel and Access). My Projects I have some of my more fun projects here so you can download and play with the VBA and such. Downloads TNG & TOS Alarm Clock For the Trekies in the house here is a TNG/TOS Alarm Clock. I hope you enjoy! A Basic Countdown Clock This is a basic Countdown clock. Your Current Star Date It takes a little bit of math but you can find out your current star date. An Offical Timesheet I built this for my old job and my boss liked it so much she got it cleared through the proper channels and we all used this time sheet. Sample Test I built this form driven workbook to show a co-worker that you could actually use Excel to aid the people in the training division. Here was the sample test. Fun With API’s This is a basic IMAP weather API in Excel. I liked this one for a while but then it got old. If you are new to playing around with API’s this is a fun exercise. More Excel Automation A supervisor wanted a workbook created to help us tracking certain event logs. So, needless to say I turned to Excel to create this fun row adding workbook. Technically this one should have flipped over to an Access DB but the practice was really fun. I think I came up with this one just before a lot of my assignments at work ended up requiring a DB. Barnsley Fern Fractal Every math nerd ends up playing with fractals and I am no different. Fractals are very fun because of the math involved in them. This Barnsley Fern Fractal is one of my favorites and of course I had to push Excel until I figured out how to create a fractal in the program.

Read more