VBA

[ngoz1]

hi every one,
i designed a database for a womens organisation which will be used to record both member and non member details, it will also be used to record all information on services that bring in income i.e member ship registration, training registration and payment details of these services. likwise for expenses made by the company. i also created reports to show a summary of these money transactions,balances outstanding etc

i was able to do all this without using VBA. can someone please tell my how i could have implented the use of VBA in the design of this database or how i could have used it to automate some processes. i am currently trying to learn VBA and would like to use the above existing databse to practice

thanks

 

[jrbarnett]

VBA is a programming language used to create custom applications using Access features. You can use it to bring together various forms, reports etc. If you look at code wizards, they generate basic VBA code.

Over macros, VBA code can have significant error trapping features and functionality.
Effectively VBA can be thought of as the 'glue' that makes components of Access work together. It isn't really used in the database design, more in terms of implementing business logic to help your application work better, maybe streamline it from the users point of view.

However, you have found that it is possible to go a long way without writing any code, and for non programmers that can be an advantage (although many non programmers find that Access is far too advanced for their database needs anyway).

John

 

[mpastore]

I agree with John's points. The advantage of learning VBA or any other programming language is that you will be more empowered to solve a business problem in a way more tailored to your way of thinking. The shortfall with wizards and macros is that they force you to abide by a "cookie-cutter" approach to creating solutions.

Remembr that the basic premise of any programming language lies in sequence, condition, and iteration. Sequence is the order in which tasks are performed. Conditions are the paths that code may take based on if,then,else conditions. Iteration is the way in which the same task is done over and over again until a condition has been satisfied (while,for loops). Macros satisfy program sequence well but are more difficult to use for conditional and sequential logic.

Mike Pastore

Hats off to (Roy) Harper