The LAST time I published VBA code for Access/SQL Server

The last time I published VBA code for MS Access (in 2001 I believe), I had nearly a quarter-million views of my code within about 5 years.  Unfortunately, FREEVBCODE.com no longer displays how many times people view the code.  http://www.freevbcode.com/ShowCode.asp?ID=4426 Oh well—here is a NEW set of VBA procedures for you all to enjoy.  I […]

Replace underscores in field names throughout SQL Server database

Use this script to generate the other scripts. Copy the results into a new query window, and execute. This method is called Psuedo-Dynamic SQL, and I learned about this from ‘SQL Server 7.0 Secrets’ about 15 years ago. select ‘EXEC dbo.sp_rename @objname = ‘ + CHAR(39) + ‘[‘ + so.name + ‘].’ + sc.name + […]

Replace Spaces in field names throughout SQL Server database

Use this script to generate the other scripts. Copy the results into a new query window, and execute. This method is called Psuedo-Dynamic SQL, and I learned about this from ‘SQL Server 7.0 Secrets’ about 15 years ago. select ‘EXEC dbo.sp_rename @objname = ‘ + CHAR(39) + ‘[‘ + so.name + ‘].’ + sc.name + […]

Visual Basic.Net on the upswing with developers

Although programming languages such as Java, Objective-C, and JavaScript garner the lion’s share of attention these days, don’t count out Microsoft’s Visual Basic .Net (VB.Net), which has been on a mostly upward trend in the Tiobe language popularity index. For the first time ever, VB.Net cracked the Tiobe Index’s 10 most popular languages, grabbing the […]