Similarities between Access Databases and Projects

Similarities between Access Databases and Projects About indexes Article About indexing fields and records in an Access database (MDB) About indexes (ADP) About keys Article About primary keys (MDB) About keys (ADP) About queries Article About types of queries (MDB) About select and crosstab queries (MDB) About action queries (MDB) About creating queries (ADP) ##Side:Start;Align:left## […]

How can Microsoft fix their problem with mainstream developers?

Resuming Classic VB as a mainstream product would also mean best PR for them, too. The years ago, there were 6 million “professional” VB6 programmers. All of us, no matter what additional tools,languages and platforms are we using today, still have to maintain and extend VB6 applications, and most of us still hold a grunge […]

Don't rewrite old code 'just becase it's old'

http://www.joelonsoftware.com/articles/fog0000000069.html             Joel on Software Things You Should Never Do, Part I by Joel Spolsky Thursday, April 06, 2000 Netscape 6.0 is finally going into its first public beta. There never was a version 5.0. The last major release, version 4.0, was released almost three years ago. Three years is an awfully long time in […]

how to import all the spreadsheets in a folder

I love Access / Visual Basic for importing files.. I just laugh when I talk about doing this same thing in SSIS, it takes MUCH less time to write a simple loop in script than to do it in GUI like SSIS. -Aaron Option Compare Database Option Explicit Public Sub ImportAllSpreadsheets() On Error GoTo errHandler […]