header image

Archive for November, 2009

Add Access record

Posted by: | November 23, 2009 | No Comment |

We’ve seen how to create a database and a table. Now we need to know how to add a record to that table. 001 002 003 004 005 006 007 008 function Add-AccessRecord { param (     [string]$sql,     [System.Data.OleDb.OleDbConnection]$connection )     $cmd = New-Object System.Data.OleDb.OleDbCommand($sql, $connection)     $cmd.ExecuteNonQuery() } This takes a SQL INSERT statement and executes it against the table […]

under: Office 2010, PowerShell original, PowerShellV2

Adding a Table to an Access database

Posted by: | November 23, 2009 | No Comment |

  After reviewing the function I produced in the last post I realised i had made it over complicated.  I’m working with Office 2010 and 2007 predominantly so I should have the 2007 format as my default.  If I do that and change the switch parameter so it is used to create an Access 2003 […]

under: Office 2010, PowerShell original, PowerShellV2

Creating an Access database

Posted by: | November 22, 2009 | No Comment |

I’ve blogged a bit about using SQL Server with PowerShell, and using Word and Excel through PowerShell.  I realised that I hadn’t seen much about using Access. Access is part of the Office suite and is present on many desktops. It forms a handy data store for using with PowerShell. In this series of articles […]

under: Office 2010, PowerShell original, PowerShellV2

Windows 7 – Pet Hate #1

Posted by: | November 21, 2009 | No Comment |

I’ve been using Windows 7 since January and as I’ve reported several times I have been really happy with it.  One source of irritation has arisen – the Action Center. This is a reporting system for system issues such as security (firewall turned off) or maintenance (backups not configured).  This is fine but the thing […]

under: Windows 7

WMICookbook: Read Routing Table

Posted by: | November 20, 2009 | 1 Comment |

When we need to troubleshoot networking problems we will sometimes need to read the routing table on a machine. The routing table contains the information on the routes known to the network interfaces. This can be created automatically or manually . On the local machine we can use the route command to find this information […]

under: PowerShell and WMI, PowerShellV2

Excel 2010 beta

Posted by: | November 19, 2009 | No Comment |

  The beta still allows those of us that aren’t in the USA to use the simple method of creating a new spreadsheet using PowerShell. 001 002 003 $xl = New-Object -comobject "excel.application"  $xl.visible = $true $xlbooks =$xl.workbooks.Add()   Makes life easier. In case you are wondering – if you don’t have your machine set to US English and you are using […]

under: Office 2010, PowerShell original

PowerShell v2 cmdlets

Posted by: | November 19, 2009 | No Comment |

Jonathan has started a series of posts at http://www.jonathanmedd.net/ on all of the new cmdlets in PowerShell v2.  If you are just starting with v2, or want more information on whats new, this is a good place to start. Technorati Tags: PowerShell v2,cmdlets

under: PowerShellV2

Office 2010 – fixed in beta

Posted by: | November 18, 2009 | No Comment |

A couple of issues that I noticed with the Office 2010 TP have been fixed in the beta: Word documents will now download from the Internet and open One undocks back to normal view correctly I did notice that in the Visio 2010 beta the Window title still says Technical Preview.  All the other components […]

under: Office 2010

Reminders via WPF

Posted by: | November 18, 2009 | No Comment |

If I am working on my home machine I don’t necessarily have Outlook or any other application that gives me calendaring capability open. There are times when I need a simple reminder to do something. For some reason I always seem to have PowerShell open so I thought of using the eventing system to give […]

under: PowerShell original, PowerShellV2

Reminders

Posted by: | November 18, 2009 | No Comment |

If I am working on my home machine I don’t necessarily have Outlook or any other application that gives me calendaring capability open. There are times when I need a simple reminder to do something. For some reason I always seem to have PowerShell open so I thought of using the eventing system to give […]

under: Events, PowerShellV2, WPF

« Newer Posts - Older Posts »

Categories