Scripting Blog [archived]

Formerly known as the "Hey, Scripting Guy!" blog

July 2007 - Page 4 of 4 - Scripting Blog [archived]

How Can I List All the Fields and Data Types in an Access Database?

July 10, 2007 Jul 10, 2007 07/10/07
ScriptingGuy1
(image) Hey, Scripting Guy! In a previous column you showed us how to list all the tables in an Access database. How can I list all the fields in those tables, along with the data type of each field?-- MF (image) (image) (image) Hey, MF. As you may or may not know, there’s a Microsoft researcher named Gordon Bell who has devoted his ...

How Can I Replace Null Values in an Array?

July 6, 2007 Jul 6, 2007 07/6/07
ScriptingGuy1
(image) Hey, Scripting Guy! How can I loop through a 12x12 array and replace any null values with a hyphen?-- AM (image) (image) (image) Hey, AM. Sorry for the delay in getting back to you; as it turns out, yesterday was Independence Day (more typically referred to as the Fourth of July) in the good old USA, and the Scripting Guys, along ...

How Can I Change the Local Administrator Password on All My Computers?

July 4, 2007 Jul 4, 2007 07/4/07
ScriptingGuy1
(image) Hey, Scripting Guy! How can I change the local Administrator password on all the computers in my domain?-- AO (image) (image) (image) Hey, AO. You know, according to the now-classic cartoon punch-line, “on the Internet, no one knows if you’re a dog.” To be perfectly honest, the Scripting Guy who writes this column doesn’t ...

How Can I Create a Folder With a Name Based on the Monday and Friday of the Coming Week?

July 3, 2007 Jul 3, 2007 07/3/07
ScriptingGuy1
(image) Hey, Scripting Guy! Every Sunday I need to create a folder with a name similar to this: C:\Test\7-2-2007 to 7-6-2007, with the dates representing the Monday and the Friday of the upcoming week. How can I write a script that will create this folder for me?-- R (image) (image) (image) Hey, R. You, from time-to-time people write to ...