I would like to learn data ase development with VBA and MS Access, can anyone give me any tips. I know basics of VB.NET and SQL. What would be a good place to start?
Many thanks
Many thanks
VBA Developing
If you know BV.NET, then VBA is a piece of cake.
While in the VBA editor, open the help window.
Go to MS visual basic documentation --> Visual Basic Add-in model --> whatever you want to know about.
That will tell you about the diferences between VBA and VB (basicly just some added objects, methods, ect...).
While in the VBA editor, open the help window.
Go to MS visual basic documentation --> Visual Basic Add-in model --> whatever you want to know about.
That will tell you about the diferences between VBA and VB (basicly just some added objects, methods, ect...).
I don't uses VB that often. Nevertheless, when I got assigned a project for a company that was all about windows technologies, I had to use Access and VBA. I found a book that was very helpful:
Alison Balters
Mastering Microsoft Office Access 2003, Sams Publications.
I think this is a very good introduction for programming savvy readers as it gives you a general overview of database programming in the context of Access.
If you HAVE to use Access, as I did, this would be my suggestion. Otherwise, look into MySQL and postgres.
***edit***
I forgot to mention that this is the only female technical author I have in my library.
Alison Balters
Mastering Microsoft Office Access 2003, Sams Publications.
I think this is a very good introduction for programming savvy readers as it gives you a general overview of database programming in the context of Access.
If you HAVE to use Access, as I did, this would be my suggestion. Otherwise, look into MySQL and postgres.
***edit***
I forgot to mention that this is the only female technical author I have in my library.
 |