I have a CIS degree and work in local Govt = Low $$$ for training. I have learned Visual Basic on my own and would like to find a book that covers the "smart" way to program vs. the "however you can get it to work" way.
For example I am building a set of objects to use for moving and formatting data to/from oracle tables. (beats redeclaring 119 variables each time I write a program to insert data into 1 table!) I know globals are frowned on but wonder how other programmers handle database connections? Is it better to live with some globals than experience a performance loss by passing connections/recordsets all over the place?
So I am looking for a book or site that covers topics such as structured and object oriented programming and performance. Most of the programs I write do not have user interfaces - I use VB because it is quick to write. (we don't have much staff) (something similar in content to the OReilly book "Oracle PL/SQL Programming")
The debugging module of the VB 6 IDE can be accessed by way of the Debug menu item. That menu item can normally be found in the IDE's main menu line as shown in this picture.
There is also a companion Debug Toolbar that looks like the followin…
I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…