Geek Answers Handbook

How to be productive in developing Access VBA + SQL?

I am a rails developer for 80% of rubies, but I still need to do some VBA Access work.

Some of them are very shitty systems that were created centuries ago and were used by a large enterprise all over the world, so most of the work just improves the old system.

Basically, this is MS Access, as an interface, linked table that references the SQL server through ODBC as the back end.

Now I really think I need help, just want to know if there is anyone who can build an elegant VBA application by following the object oriented patten?

Better yet, if you can show me a piece of code to demonstrate how good this is, thanks.

+5
source share
5 answers

Well, the first question to keep in mind is that there is no magic shortcut for teaching MS access. Over the years, Ive studied a variety of development platforms, ranging from mainframe systems, databae systems, all the way to handwritten assembler on a PC. I wrote two payroll systems from scratch (with Canada income formulas for taxes included in these systems). One system from scratch wrote Pascal, where I even wrote my own data engine.

Make no mistake, ms-access is a complex development system.

On access, you can create great search apps. take a look at these screenshots:

http://www.fairsoftware.com/screenshots.aspx

Check out the cool tapes in the screenshots above.

, Unix , Oracle . MS . , , , 4-5- - . , - ms-, vb.net, # .

, , Oracle , MS. MS , .

VB6 - . VB6 , ( 3 ). , , ( ). VB6 ( .net-) . . cancel = true, .

, , . , on-open , ( ). on-open , on-load .

, , , , on-load ( , ), , theres , . , .

, . , . , , , , , , , ? , .

, , . . , on-open, , , , . , . , , , .

, MS, :

http://www.members.shaw.ca/AlbertKallal/Articles/WhyClass.html

API , :

http://www.mvps.org/access/

+8

. VBA - , Ruby. Access; , . , .

, Access . .

+1

, Access, . , , , , , . , , , , , .

+1

Take a look at Embeds expression, that is, polymorphism through interfaces. This is like OO, as VBA gets.

0
source

More articles:


All Articles