VBA for access
17 months ago
I try to learn this.
How to learn vba
It made me 
"Learning VBA is a great way to start programming, simple, effective and useful"
How I did it: I taught myself VBA based on several years knowledge of BASIC (Which is an acronym for Beginners All-purpose Symbolic Instruction Code).
I started with my knowledge of QBasic, old microsoft DOS version of Basic. I needed to reduce the replication of Microsoft Office Spreadsheets and Access databases. So i started writing subroutines and functions to minimize repetitive actions.
VBA is also the key to adding extra functionality to MS Office documents, such as reports, calculation and cross document information processing.
Lessons & tips: I can teach VBA from Novice (Never ever written one piece of code) through Beginner, intermediate and onto advanced topics, such as Web 2.0/Ajax in VBA.
Main TIP: Keep at it, be open to learning and when you make a mistake, correct it and remember how to correct it.
Resources: PaulTheProgrammer is my own website with lots of free, easy to read tutorials. Its got a top 10 list of online tutorials, plus a very basic beginners guide to learning VBA that you can read, download and send to your friends (or enemies!)
People doing this are also doing these things:
Entries
Not worth it...
2 years ago
I used to think VBA was the best thing ever, making cool little macros and stuff was my hobby, but its better to invest your time into somethign that’s more worthwhile like a Server Side Language or something cool like PHP. If you want to waste your time making custom Access applications, go for it, but its easier to do it with MySQL.
calypte desperately seeking sparkle
Training v. trying
2 years ago
This is where I’ve been for the past couple of days – away on a VBA training course. Correction, we’re not really allowed VBA training (not relevant enough, apparently!) but we do a lot of work using a document cobbled together with more VBA than sticky tape on Blue Peter, and whose creator has since left the building.
SO. Now, I happen to like VBA. Or at least, the possibilities. Why didn’t I know about this years ago!? I’ve taught myself the basics pretty quickly, and was eager to learn. Sadly the course was a bit haphazard, and I don’t feel all that enlightened. A few good tips, but not 2-days worth.
Back to the picking away at it myself.
Incidently, if anyone would like a silly little guessing game in MS Excel, lemme know and I’ll post the code :)
