Thursday, May 03, 2007

Keep Your Custom Access Application Icon Loaded

The Access StartUp dialog file path entry for a custom icon is hard-coded, so if you distribute your application and the absolute path is not be replicated in the user's PC, your custom icon will not load with your database.

The following code in a module will allways load your custom Icon provided the ICO file is in the same folder as your application database:

Option Compare Database
Option Explicit

Public Function fnAddAppIconProp()
'Call this function from the OnLoad Event of your StartUp form

Dim intX As Integer
Const DB_Text As Long = 10
intX = AddAppProperty("AppIcon", DB_Text, CurrentProject.Path & _
"\myapp.ico")
Application.RefreshTitleBar

End Function

Function AddAppProperty(strName As String, varType As Variant, varValue _
As Variant) As Integer

Dim dbs As Object, prp As Variant
Const conPropNotFoundError = 3270

On Error GoTo AddProp_Err

Set dbs = CurrentDb
dbs.Properties(strName) = varValue
AddAppProperty = True

AddProp_Exit:

Exit Function

AddProp_Err:

If Err = conPropNotFoundError Then
Set prp = dbs.CreateProperty(strName, varType, varValue)
dbs.Properties.Append prp
Resume
Else
AddAppProperty = False
Resume AddProp_Exit
End If

End Function

Save as PDF or XPS Add-In for Office 2007

XPS is a file format, like PDF, that preserves document formatting in a fixed layout and ensures that when the document is viewed or printed, it will retain the exact original format. You can save documents in XPS format in Office 2007 programs after installing the Microsoft Save AS PDF OR XPS Add-In for Office 2007 programs, which you can download here.

Office 2007 Terms You Should Know

Mini-Glossary: Office 2007 Terms You Should Know From TechRepublic.com

Monday, April 30, 2007

NEW v1.2 Ezy StartBar for Windows
A faster more versatile Start Menu for your Desktop



Ezy StartBar for Windows v1.2 is now available. After feedback from users, I have updated this very popular download, which has been listed by many software sites.

Ezy StartBar adds a supplemental Start Menu SideBar to your Windows Taskbar, and provides quick access to groups of menu items. It offers more flexibility than the standard Windows Start Menu, and the number of links is virtually unlimited. You can manage Ezy StartBar exclusively using your mouse.

Ezy StartBar behaves like the standard Start Menu, but also allows you to create groups of shortcuts, which can be added, edited and deleted on the fly, with full drag and drop functionality. You can drag shortcuts onto any group in the SideBar when Ezy StartBar is pinned to your Desktop.

A link to any program, file, folder, shortcut, or URL can be added to the Ezy StartBar SideBar by either pinning the SideBar and dragging and dropping a file or a shortcut onto a group, or by using the SideBar's File Open dialog whether the SideBar is pinned or un-pinned.

A group or an item can be renamed, edited, or removed from the SideBar by right-clicking the SideBar and using the commands available from the popup menu. The order of the items in a group can be arranged by dragging and dropping them to the preferred position within a group or from one group to another.

Unlike the standard Windows Start Menu, a SideBar link item created from a shortcut that is subsequently moved or deleted will still work, as the
Ezy StartBar link points to the actual file location not the shortcut.

Download (500kb)

New features and fixes include:
  • System-wide Hot Key
  • Default skin is now the user's Windows scheme - custom skin option removed
  • URL link source not lost when source shortcut is deleted
  • Launch bar now fully repositions and resizes with Taskbar position and size
  • Launch bar now visible when Taskbar is set to auto-hide
  • Menubar replaced by graphical toolbar

Friday, April 27, 2007

Office 2003 SP3 to provide Office 2007 Security Features

Microsoft plans to make some of the security improvements and features built into Office 2007 available for Office 2003, a company representative said Thursday. Service Pack 3 for Office 2003 will be focused on security. Joshua Edwards, a technical product manager for Office at Microsoft said: "We're not going to take everything, but we will take as much as we can."

Microsoft hasn't yet set a release date for the Office 2003 update, which like other service packs will be available as a free upgrade.

More from Source: news.com.com

Thursday, April 26, 2007

Windows SharePoint Services 3.0 Application Templates

Windows SharePoint Services 3.0 Application Template Documents: All Application Template Datasheets This download combines all of the datasheets for the Application Templates for Windows SharePoint Services 3.0 into one convenient package.

Monday, April 23, 2007

AutoRuns for Windows v8.61

This utility from MSDN goes way beyond the MSConfig utility bundled with Windows. Autoruns is the most comprehensive startup monitor I have seen and shows which programs are configured to run during system bootup or login, and the entries in the order Windows processes them, including applications in your startup folder, Run, RunOnce, and other Registry keys. You can configure Autoruns to show other locations, including Explorer shell extensions, toolbars, browser helper objects, Winlogon notifications, auto-start services, and more.

Autorun's Hide Signed Microsoft Entries option lists third-party auto-starting images that have been added to your system, and supports the auto-starting images configured for other system accounts. Also included in the download package is a command-line equivalent, Autorunsc, that outputs in CSV format.


Friday, April 20, 2007

Download the Office 2007 Formats Compatibility Pack

Microsoft Office Compatibility Pack for Word, Excel, and PowerPoint 2007 File Formats
Open, edit, and save documents, workbooks, and presentations in the file formats new to Microsoft Office Word, Excel, and PowerPoint 2007.

Thursday, April 19, 2007

Training presentation: Get up to speed with Office 2007

Download this Powerpoint template of training content about the new look of the Office 2007 and its new tools and benefits. This content is geared for a corporate trainer to present to a group.
Version: PowerPoint 2000 or later
Download size: 1350 KB (5 mins @ 56 Kbps)

Office 2003 and 2007:
MSDN Technical Articles, How-To Content, and Code Samples

MSDN have researched the MSDN Library – Office Solutions Development Node and pulled tons of useful links and categorized them by content type. MSDN will update these pages as more content is published.

These are all new resources pages that compile links to articles, code samples, and how-to articles for Office 2007:

They have also built some resource pages for Office 2003:

Source: Erika Ehrli's MSDN Blog - Adventures in Office Development and .NET


Wednesday, April 18, 2007

Connecting to Oracle With MS Access

These are helpful walkthroughs on using Access to connect to Oracle back-ends. The first article also addresses the differences between Oracle SQL and Access SQL:

Monday, April 16, 2007

Up-sizing from Access to SQL Server

A useful resource portal from MS Gold Certified Partner ssw.com.au on the rationale for up-sizing from Access to SQL Server and managing the up-size process. You can download an up-sizing plan template and these white papers:
  • What’s New and Different when Moving Your Backend from Access to SQL Server 2000
  • How to Migrate Your Backend from Access to SQL Server 2000
Fifty Ways to Improve Your Visual Basic Programs

An excellent article from VB author J.P. Hamilton on 50 things you can do to make your VB [and VBA] code more effective and easier to maintain.

Sunday, April 15, 2007

It's Official: Don't Deploy Access Database on Windows Vista

From Access KB Article No. 935370 issued by Microsoft on 10 April 2007:

When you open or are using a Microsoft Office Access database on a computer that is running Windows Vista, you may encounter one or more of the following issues:

Applies To

• Microsoft Office Access 2007
• Microsoft Office Access 2003
• Microsoft Access 2002 Standard Edition
• Microsoft Access 2000 Standard Edition
• Windows Vista Business
• Windows Vista Enterprise
• Windows Vista Home Basic
• Windows Vista Home Premium
• Windows Vista Ultimate

Symptoms


Access appears to stop responding.

Access responds very slowly.

Access exits unexpectedly or crashes.

An event that resembles the following is logged in the Application log:
Log Name: Application
Source: Application Hang
Logged: Date_and_Time
Event ID: 1002
Task Category: (101)
Level: Error
Keywords: Classic
User: N/A
Computer: Computer_Name
Description: The program MSACCESS.EXE version Version_Number stopped interacting with Windows and was closed. To see if more information about the problem is available, check the problem history in the Problem Reports and Solutions control panel. Process ID: Process_ID Start Time: Hexadecimal_Time Termination Time: Hexadecimal_Time

After you encounter one or more of these issues, you receive the following error message the next time that you open the database: The document Database_Name caused a serious error the last time it was opened. Would you like to continue opening it? When you open the database, you encounter the following issues:


All data in tables and queries shows as "#Name?"

You no longer see any objects in the navigation pane.

This problem may occur if the following conditions are true:


The database that you are using is a shared database that resides on a Windows Vista-based computer.

Two or more Windows Vista-based computers are trying to use the database at the same time.

Note If you run the beta versions of Windows Server Code Name "Longhorn," you may also experience this problem.

Cause

This problem is related to issues with Server Message Block (SMB) 2.0 when SMB 2.0 is running on a Windows Vista-based computer.

Workaround

You can temporarily work around this problem by sharing the database from a computer that is not running Windows Vista or a beta version of Windows Server "Longhorn." We do not recommend this method as a permanent solution. You should check this article periodically for a permanent solution.

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section. Microsoft is currently working on a more permanent solution to this problem and will update this article when that information is available.

Monday, April 09, 2007

SQL Server Analysis Cubes and Excel 2007 Pivot Tables

Excel 2007 Document: Designing SQL Server 2005 Analysis Services Cubes for Excel 2007 PivotTables This MS document outlines how to improve the end-user experience by optimizing the cube design for Microsoft Office Excel 2007 PivotTable dynamic views.

Friday, April 06, 2007

MSDN April 2007 Library Available for Download

MSDN Library (April 2007) The MSDN Library provides access to essential programming information, including technical reference documentations, white papers, software development kits, and code samples necessary to develop Web services and applications.

Wednesday, April 04, 2007

New SQL Server Hosting Downloads

SQL Server Database Publishing Services 1.1 SQL Server Database Publishing Services can be deployed by shared hosting providers to enable publishing of SQL Server databases over the Internet.

SQL Server Database Publishing Wizard 1.1 The SQL Server Database Publishing Wizard provides a way to publish databases to T-SQL scripts or directly to supporting hosting service providers.

Monday, April 02, 2007

PS: Help File for CodeGuru ZIP Library

I have compiled a Help file for the CGZipLibrary.dll, using the excellent freeware tool HTML Help COM Assistant from DevComponents.com. The CHM file documents all objects, methods and properies in the DLL.
Zip And UnZip In Access Without WinZip

Not all users will have WinZip on their PC. The following VBA code using the OpenSource CodeGuru Zip DLL library offers a simple and effective way to manage ZIP files during application installation and within applications. I have used this basic code in an application without mishap.

1. Download the DLL's and source code from: http://www.codeguru.com/vb/gen/vb_graphics/fileformats/article.php/c6743/

2. Deploy the DLL, CGZipLibrary.dll, to the application folder or to the .../Windows/System32 folder

3. Add a Reference to the DLL

4. Use VBA code based on the following sample Access form module:

' Unzip/Zip Client program for the CGZipLibrary ActiveXDLL
' Based on VB6 Code by Chris Eastwood, July 1999
Option Explicit

Private Declare Function GetTempPath Lib "kernel32" Alias "GetTempPathA" (ByVal nBufferLength As Long, ByVal lpBuffer As String) As Long

Private Function GetTempPathName() As String
Dim sBuffer As String
Dim lRet As Long

sBuffer = String$(255, vbNullChar)
lRet = GetTempPath(255, sBuffer)
If lRet > 0 Then
sBuffer = Left$(sBuffer, lRet)
End If
GetTempPathName = sBuffer
End Function

Private Sub cmdUnZip_Click()
On Error GoTo vbErrorHandler

' Unzip the ZIPTEST.ZIP file to the Windows Temp Directory'
Dim oUnZip As CGUnzipFiles
Set oUnZip = New CGUnzipFiles
With oUnZip
' Which Zip File ?
.ZipFileName = "C:\ZIPTEST.ZIP"
' Where are we zipping to ?'
.ExtractDir = GetTempPathName
'Keep Directory Structure of Zip ?'
.HonorDirectories = False
' Unzip and Display any errors as required
If .Unzip <> 0 Then
MsgBox .GetLastMessage
End If
End With
Set oUnZip = Nothing
MsgBox "\ZIPTEST.ZIP Extracted Successfully to " & GetTempPathName

Exit Sub
vbErrorHandler:
MsgBox Err.Number & Err.Description
End Sub

Private Sub cmdZip_Click()
On Error GoTo vbErrorHandler

Set oZip = New CGZipFiles
With oZip'
' Give Zip File a Name\Path
.ZipFileName = "\ZIPTEST.ZIP"
.UpdatingZip = False ' ensures a new zip is created
' Add in the files to the zip - in this case - all the files in the current directory
.AddFile App.Path & "\*.*"
' Make the zip file & display any errors
If .MakeZipFile <> 0 Then
MsgBox .GetLastMessage ' any errors
End If
End With
Set oZip = Nothing
MsgBox "\ZIPTEST.ZIP Created Successfully"

Exit Sub
vbErrorHandler:
MsgBox Err.Number & Err.Description
End Sub

Sunday, April 01, 2007

NEW Ezy StartBar for Windows
A faster more versatile Start Menu for your Desktop



I have just launched my latest freeware application: Ezy StartBar for Windows.

Ezy StartBar adds a supplemental Start Menu SideBar to your Windows Taskbar, and provides quick access to groups of menu items. It offers more flexibility than the standard Windows Start Menu, and the number of links is virtually unlimited. You can manage Ezy StartBar exclusively using your mouse.


Ezy StartBar behaves like the standard Start Menu, but also allows you to create groups of shortcuts, which can be added, edited and deleted on the fly, with full drag and drop functionality. You can drag shortcuts onto any group in the SideBar when Ezy StartBar is pinned to your Desktop.

A link to any program, file, shortcut, or URL can be added to the Ezy StartBar SideBar by either pinning the SideBar and dragging and dropping a file or a shortcut onto a group, or by using the SideBar's File Open dialog whether the SideBar is pinned or un-pinned.

A group or an item can be renamed, edited, or removed from the SideBar by right-clicking the SideBar and using the commands available from the popup menu. The order of the items in a group can be arranged by dragging and dropping them to the preferred position within a group or from one group to another.

Unlike the standard Windows Start Menu, a SideBar link item created from a shortcut that is subsequently moved or deleted will still work, as the
Ezy StartBar link points to the actual file location not the shortcut.

Download (500kb)


Sunday, March 25, 2007

Application Development Tips

From Aivisto.com:

User Interface Bug Tests Test your application for common bugs in the User Interface (GUI). This article shows 10 quick ways to find nasty bugs.

Optimize string handling in VB6 - Part II Get to know the performance of VB string functions. Learn the fast functions and the slow ones to avoid. Learn to call the Windows Unicode API functions and to build really, really huge strings without crashing your app.

InStr Function
InStr is a powerful string function. It's the perfect way to search and test strings in robust applications. This article shows how to call InStr to perform advanced text processing tasks quickly.


Friday, March 16, 2007

VBA Tip: Use PrtDevMode to set Printer Settings in Access 2 to Access 2000

Office XP introduced the VBA Printer object, but it is not widely know that you can use the PrtDevMode property of a form or report object in VBA to set/return printer properties such as page size and orientation. Search for PrtDevMode in Access Help.

Thursday, March 15, 2007

Administering SQL Server 2005 Express Edition

Download: Administer SQL Server 2005 Express Edition In this sample chapter from Mastering Microsoft SQL Server 2005 Express Edition, learn how to: get up and running quickly, use the interface to administer data and services as well as to keep track of what's happening on your server, and more.

Custom SQL Server 2005 Notifications

Create custom notifications with SQL Server 2005 Build a small custom notification system with SQL Server that allows you to send a message to the correct people when a problem occurs.

Monday, March 12, 2007

March 2007 is SQL Server Month at MSDN TechNet Magazine

You can also download the magazine as an HTML Help file.

New Tools to Diagnose Index Health To get the best performance out of SQL Server, you need to oversee and maintain healthy indexes. New dynamic management views and functions give you a window into SQL Server to help you better understand how your indexes are functioning and discover potential performance issues.

Achieve High Availability for SQL Server SQL Server 2005 offers a number of options to improve database availability, from replication to clustering to log shipping. We’ll take a closer look at the various options for configuring SQL Server and help you find out which ones are right for your environment.

Simplify Database Maintenance with Table Partitions In the past, working with partitions and very large tables was a burdensome and tedious task, but with SQL Server 2005, table partitioning has gotten much simpler. Now you can easily create multiple partitions, move those partitions around, drop old partitions, and even change the way data is partitioned. Here’s how.

Top Tips for SQL Server Clustering A server cluster provides failover capabilities, ensuring more uptime for your critical operations. But for a cluster to be effective, it must be implemented properly. Here are some key tips that will help you get your cluster up faster and keep it functioning reliably.

Sunday, March 11, 2007

Sample Data Models for Access Relational Databases

Databasedev.co.uk has a wide range of relational database data models for free download. The models are fully structured and normalised.

Thursday, March 08, 2007

New Office Sharepoint Server 2007 Add-Ons

Business Data Catalog

Business Data Catalog
Business Data Catalog is a new business integration feature in Microsoft Office SharePoint Server 2007. It is a shared service and it enables Office SharePoint Server 2007 to surface business data from back-end server applications without any coding. Business Data Catalog bridges the gap between the portal site and your business applications and enables you to bring in key data from various business applications to Office SharePoint Server 2007 lists, Web Parts, search, user profiles, and custom applications.

Business Data Catalog provides built-in support for displaying data from databases and Web services. That is, you can use Business Data Catalog to display data from your SAP, Siebel, or other line-of-business (LOB) application via Web services or databases.

Read the article

Knowledge Network

Knowledge Network
Knowledge Network is a new add-on for Office SharePoint Server 2007 that many people don’t know about yet. It automates the discovery and sharing of undocumented knowledge and relationships, enabling you to quickly locate who knows whom and who knows what within your constantly changing organization.

Read more...

Tuesday, March 06, 2007

Urgent Microsoft Patch for SQL Server 2005 SP2

SQL Server 2005 SP2 Update Download an update to the initial release of SQL Server 2005 SP2. This update resolves an issue with maintenance plan cleanup tasks intervals, whereby legacy data is inadvertantly deleted.

Monday, March 05, 2007

Updated Office 2003 XML Schema Reference

Updated Download: Office 2003: XML Schema Reference This download contains documentation on a number of XML schemas for Microsoft Office 2003 Editions.
Download SQL Server 2005 SP2

SQL Server 2005 SP2 Download Service Pack 2 for Microsoft SQL Server 2005.
Office Open XML Videos: Visual How To's

Office Open XML Formats: Retrieving Lists of PowerPoint 2007 Slides How to retrieve a list of PowerPoint 2007 slide titles.

Office Open XML Formats: Retrieving Excel 2007 Cell Values How to retrieve values from an Excel 2007 worksheet.

Office 2007 Developer References - Now Available!

Find conceptual overviews, programming tasks, samples, and references to guide you in developing solutions based on the Microsoft Office 2007 System:

  • Access 2007 Developer Reference
  • Excel 2007 Developer Reference
  • InfoPath 2007 Developer Reference
  • InfoPath 2007 XSF Schema Reference
  • Object Library Reference for the 2007 Microsoft Office System
  • Outlook 2007 Developer Reference
  • Project 2007 Developer Reference
  • SharePoint Designer 2007 Developer Reference
  • Word 2007 Developer Reference
  • Saturday, March 03, 2007

    Code Tip: Use Custom Cursors In MS Access

    Using VBA in Access, apart from the Hand cursor for a Hyperlink control and using the Hourglass method of the DoCmd object, you can only use the MousePointer property of the Screen object to specify a mouse-pointer, with the cursor types limited to:
    • Default Arrow
    • Text Select (I-Beam)
    • Vertical Resize (Size N, S)
    • Horizontal Resize (Size E, W)
    • Busy (Hourglass)
    However, there are two API calls that allow you to use your own custom cursors or Windows system cursors in your Access applications. You can even use animated cursors.

    Place the following code behind an Access form to see how the API calls work. A sample MDB is also available for download.

    Option Compare Database
    Option Explicit

    ' Declarations for API Functions
    Private Declare Function LoadCursorFromFile Lib "user32" _
    Alias "LoadCursorFromFileA" (ByVal lpFileName As String) As Long
    Private Declare Function SetClassLong Lib "user32" Alias_
    "SetClassLongA" (ByVal hwnd As Long, ByVal nIndex As Long, _
    ByVal dwNewLong As Long) As Long
    Private Declare Function LoadCursor Lib "user32" Alias_
    "LoadCursorA" (ByVal hInstance As Long, ByVal lpCursorName As Long) As Long

    ' Declare Windows API Constants for Windows System cursors
    Const GCW_HCURSOR = (-12)
    Const IDC_APPSTARTING As Long = 32650&
    Const IDC_ARROW As Long = 32512&
    Const IDC_HAND As Long = 32649
    Const IDC_HELP As Long = 32651
    Const IDC_IBEAM As Long = 32513&
    Const IDC_ICON As Long = 32641&
    Const IDC_WAIT As Long = 32514&
    Const IDC_UPARROW As Long = 32516&
    Const IDC_SIZEWE As Long = 32644&
    Const IDC_SIZENWSE As Long = 32642&
    Const IDC_SIZENS As Long = 32645&
    Const IDC_SIZENESW As Long = 32643&
    Const IDC_SIZEALL As Long = 32646&
    Const IDC_SIZE As Long = 32640&
    Const IDC_NO As Long = 32648&

    ' Declare handles for cursor
    Private Const GCL_HCURSOR = (-12)
    Private hOldCursor As Long
    Private hNewCursor As Long

    Private Sub Form_Load()
    'Load cursor
    'Comment out code not required:
    'Load system cursor
    hNewCursor = LoadCursor(ByVal 0&, IDC_HAND)
    'Load cursor from file
    hNewCursor = LoadCursorFromFile(CurrentProject.Path & "\cool.cur")
    'Load animated cursor from file
    hNewCursor = LoadCursorFromFile(CurrentProject.Path & "\APPSTART.ani")
    hOldCursor = SetClassLong(Me.hwnd, GCL_HCURSOR, hNewCursor)
    End Sub

    Private Sub Form_Unload(Cancel As Integer)
    'Unload cursor
    hOldCursor = SetClassLong(hwnd, GCL_HCURSOR, hOldCursor)
    End Sub




    Thursday, March 01, 2007

    How To Install Access Menu Add-Ins in Windows Vista

    Thanks to Jeanette Noble and Tim Getsch at Microsoft for this update.

    Under Vista you have to run an application as administrator to have the rights to set an HKLM registry key.

    Workarounds to Install Menu Add-Ins on Vista:
    • Run msaccess.exe as administrator and then use the Add-In manager. This workaround should work for previous versions of Access as well.

    • Manually set the registry keys for the add-in. Access 2007 now supports Menu Add-In registrations under HKLM or HKCU.

    • For Access 2007 only the best solution is to change the capitalization of “Menu Add-Ins” in the USysRegInfo table of the MDA or ACCDA. This is just like previous versions only you have to have Menu Add-Ins capitalized exactly as shown or the Add-In Manager will try to set the registry keys under HLKM and fail on Vista.

    Setting up Database Mail in SQL Server 2005

    Setting up Database Mail in SQL Server 2005 SQL Server 2005's Database Mail is completely
    SMTP based, allowing you to send e-mails with attachments, format HTML e-mails, and more. Tim Chapman from TechRepublic.com fills you in on the advantages of Database Mail and explains how to set it up in your environment.

    Wednesday, February 28, 2007

    Access 2007 Books List

    The MSDN Blog, What's New in Access 2007, has put together a comprehensive Access 2007 Books List, with titles for all levels of experience. From a complete Access reference like Microsoft® Office Access 2007 Inside Out to the more targeted such as The Rational Guide to Microsoft® Office Access 2007 Templates, and beginner titles such as Access 2007 for Starters : The Missing Manual, to the expert with Access 2007 VBA Programmer 's Reference.
    Go Beyond Macros in MS Access

    Another freebie. For those of you that want to go beyond macros in Access and need an introduction to VBA, this sample chapter from Access VBA Programming is a solid primer.

    Tuesday, February 27, 2007

    MS Access: Blocking Bad Data

    Oreilly's have provided a free sample chapter, for their just released book, Access 2007: The Missing Manual. The free download is a good introduction to data validation and data integrity techniques in Access, and covers the essential set of Access data validation tools:

    • The basics - including duplicates, required fields, and default values.
    • Input masks - formatting ordinary text into patterns, like postal codes and phone
    numbers.
    • Validation rules - to lay down strict laws for unruly fields.
    • Lookups limit values to a list of preset choices.
    Icon Constructor GiveAway

    Icon Constructor converts images of any format into Windows icons for use in your applications. It supports Windows XP icons in 32-bit color depth with an alpha channel, so you can create semi-transparent XP icons easily. With just a few clicks, any image can be turned into an icon.

    This is a really cool tool. With a few mouse clicks I created the icon set below from this JPG:






    The program is available for $29.95, but it will be free to visitors to giveawayoftheday.com as a time-limited offer for today only!
    NEW Versions of the NATIVE SideBar MS Access Switchboard

    Check out my completely revamped Native SideBar Access Switchboard, which now comes with two themes: Windows XP and Access2007 Vista. Click on the images below to zoom in for full screenshots:





    These Demo Databases feature:
    • Outlook-style application navigation using only native Access controls
    • Seamlessly use the native Switchboard Items table created by the Access Switchboard Manager
    • Outlook-style navigation
    • Custom Icons for each Switchboard Bar and Switchboard Item
    • Two Switchboards for the price of one!
    You can use the demos as a Contacts Manager or buy the source code to use the GUI in your own Access applications. Download the fully-functional demos.

    Wednesday, February 21, 2007

    Download All 40 Sharepoint Services 3.0 Templates in One Package

    Windows SharePoint Services 3.0 Application Templates: All Templates This download package includes all forty of the Application Templates for Microsoft Windows SharePoint Services 3.0 plus the Application Template Core solution, which is required to deploy server administration templates.

    Tuesday, February 20, 2007

    New Office Developer Portal

    MSDN has launched the Office 2007 Developer How-to Center. The portal compiles task-based samples that will help you learn the new features of the 2007 Microsoft Office system programs, servers, services, tools, and technologies. Each sample is a short walkthrough that showcases one feature. By integrating several of these code samples together, you can start building Office Business Applications on the Microsoft Office 2007 platform.
    Latest Articles & Resources for Office 2007: 14 Links!



    Creating Custom Task Panes Using Visual Studio 2005 Tools for Office The 2007 release of the Microsoft Office system introduces enhanced custom task panes that you can use to provide contextual assistance to your users. Learn how to create custom task panes with Visual Studio 2005 Tools for Office.

    Managing Task Panes in Multiple Word and InfoPath Documents VSTO 2005 SE samples that provide code examples for the management of task panes in Microsoft Word 2007 and InfoPath 2007.

    InfoPath 2007 Developer Reference This reference contains conceptual overviews, programming tasks, samples, and references to guide you in developing solutions based on InfoPath.

    SharePoint 2007 Sample: User-Defined Functions for Excel 2007 and Excel Services Sample Solution Contains sample user-defined functions (UDFs) and supporting files.

    SharePoint Server 2007: Extending the Excel Services Programmability Framework Optimize version 1 of the Excel Services programmability framework to extend Microsoft Office Excel 2007 and Excel Services functionalities to work with Microsoft Office SharePoint Server 2007 lists, query tables on Excel Services, external workbook references, SQL write-back, and user-defined functions (UDFs).

    Conditional Formatting: Adding Customized Data Bars to Excel 2007 Summary: Data bars give you an opportunity to create visual effects in your data that can help you see how the value of a cell compares with other cells. Learn how to implement and manipulate data bars programmatically through the user interface.

    Improving Performance in Excel 2007 Learn about the increased worksheet capacity in Excel 2007 and techniques that you can use as you design and create worksheets to improve calculation performance.

    Video: Working with Content Controls in Word 2007 Walk through on using content controls in Word 2007.

    Office Visual How to: Building Word 2007 Documents Using Office Open XML Formats The Office Open XML Formats are based on XML and ZIP archive technologies. The new file format in Microsoft Office Word 2007 divides the file into document parts, each of which defines a part of the overall contents of the file. You can easily create, change, add, or delete data in a Word 2007 file programmatically or manually.

    Microsoft Architect Journal: Building Office Business Applications The 2007 Microsoft Office system provides a set of servers, clients, and tools to make it easier for enterprises and software vendors to build and deploy composite applications in the enterprise. These solutions, called Office Business Applications (OBAs), are quick to build and deploy; empower end users through extensive personalization capabilities; are easy to change when business needs require; and are built using familiar Microsoft Office tools and applications. This paper shows how to architect composite applications, and how the 2007 Microsoft Office system provides a good platform—familiar to end users—for building such applications.

    Using XML to Write a Trip Report Are you a salesperson who spends time on the road visiting customers? Are you part of a marketing team that tracks sales visits? Find out how you can make creating trip reports easier with Word XML features.

    Video: Building Documents from Scratch Using the Office XML File Formats An 8 minute demo around the Open XML formats, including the key things that go into building a document.

    Integrating Visio 2007 and Access 2007 Use Automation code to create a Visio drawing from data defining the contents of a drawing and the connectivity between shapes stored within Access tables.

    Monday, February 19, 2007

    Latest SQL Server 2005 Resources (February 2007)

    SQL Server 2005 Samples and Sample Databases (February 2007) Download over 100 samples and five sample databases for SQL Server 2005.

    SQL Server 2005 Books Online (February 2007) Download an updated version of the documentation and tutorials for Microsoft SQL Server 2005. See the "Additional Information" section for an update on SQL Server Express Books Online.

    Readme Files for SQL Server 2005 SP2 and SQL Server 2005 SP2 Express Editions and Tools
    Before you install SQL Server 2005 Service Pack 2 (SP2), download, extract, and read the SP2 Setup documentation (sqlhotfix_setuphelp.exe), and review the SP2 readme file. Before you install SQL Server 2005 SP2 Express editions and tools, read the related readme files.

    Sunday, February 18, 2007

    Latest Access Knowledge Base Articles

    Courtesy of KbAlertz.com:

    Access 2000

    895751 Description of the Jet 4.0 Database Engine post-837001 hotfix package: April 12, 2005
    927844 Users experience problems when they try to use Internet Explorer or a shortcut to open an Access database if the database is already opened by a user
    927417 A table field appears incorrectly in Datasheet view when you add the field by using the Microsoft DAO Object Library and you set the OrdinalPosition property in Access
    920906 Description of the security update for Office 2000, for Office 2000 MUI, and for Project 2000: February 13, 2007
    929062 Description of the security update for Office 2000 and for Project 2000: February 13, 2007

    Access 2002

    920816 Description of the security update for Office XP, for Project 2002, and for Visio 2002: February 13, 2007
    929063 Description of the security update for Office XP, for Project 2002, and for Visio 2002: February 13, 2007
    931665 Description of the Access 2003 post-Service Pack 2 hotfix package: January 26, 2007
    920813 Description of the security update for Office 2003, for Project 2003, and for Visio 2003: February 13, 2007
    931808 Description of the Office 2003 post-Service Pack 2 hotfix package: January 30, 2007
    929064 Description of the security update for Office 2003: February 13, 2007
    931662 Description of the Office 2003 post-Service Pack 2 hotfix package: January 26, 2007
    931663 Plot lines that contain labels disappear when you edit a Microsoft Excel chart or a Microsoft Graph chart in an Office 2003 program

    Access 2003


    927138 Description of the Office 2003 post-Service Pack 2 hotfix package: October 23, 2006
    919029 Description of the update for Office 2003: November 14, 2006
    926259 Description of the Office 2003 post-Service Pack 2 hotfix package: October 11, 2006
    926903 Description of the Access 2003 post-Service Pack 2 hotfix package: October 17, 2006
    924886 Description of the update for Office 2003: December 12, 2006
    931665 Description of the Access 2003 post-Service Pack 2 hotfix package: January 26, 2007
    927417 A table field appears incorrectly in Datasheet view when you add the field by using the Microsoft DAO Object Library and you set the OrdinalPosition property in Access

    Tuesday, February 13, 2007

    Security Update for Office XP

    Security Update for Office XP (KB920816) Microsoft has released a security update for Microsoft Office XP, addressing a vulnerability that could enable malicious code execution. Other fixes are included.

    Wednesday, February 07, 2007

    NEW from aadconsulting.com: Ribbon Switchboard for Access 2007


    Click on the image to zoom in...

    I have just launched my latest Access Switchboard. Ribbon Switchboard for Access 2007 is a new space-saving application navigation paradigm that utilizes the flexible new Ribbon Bar GUI and tabbed MDI option in Access 2007, as well as dispensing with traditional Access switchboard and hiding the Access 2o07 Navigation Pane.


    Features:

    • Fully customisable set of context-sensitive Custom Ribbons
    • Access 2007 Database Window, Navigation Pane, and Menus fully hidden
    • MDI interface with popup dialogs for Add Only forms
    • Illustrated instructions and resource links.

    Download the demo.

    Friday, February 02, 2007

    STOP PRESS: Access 2007 Runtime and Developer Extension will be Free!

    You heard it first from Access Extra.

    This morning MS announced that the developer extensions and runtime for Access 2007 will be available for FREE! Previously Access developers to build and deploy runtime solutions had to purchase the ODE for pre-Access 2003 versions and Visual Studio Tools for Office for Access 2003. VSTO cost US$800 for the full version and US$550 for the upgrade.

    This really is great news for Access developers :)

    A release date has yet to be announced.

    Thursday, February 01, 2007

    Download Three Sample Add-Ins for Outlook 2007

    Outlook 2007 Add-Ins: RulesAddin, TravelAgencyAddin, and PrepareMeAddin These sample add-ins demonstrate many of the new and enhanced features of the Outlook object model.

    Wednesday, January 31, 2007


    Comparison Chart for Office 2007 Suites


    Find out which flavor meets your needs. Click on the Chart to zoom in:



    Full details from the Office 2007 Portal.




    Tuesday, January 30, 2007

    Managing Task Panes in Word 2007 and InfoPath 2007 Using Visual Studio Tools for Office

    Visual Studio Tools for Office 2005 Second Edition Sample: Managing Task Panes in Word 2007 and InfoPath 2007 Using Visual Studio Tools for Office (VSTO) 2005 SE VSTO 2005 SE samples that provide code examples for the management of task panes in Microsoft Word 2007 and InfoPath 2007.

    Get Started Tabs for Office 2007

    Again nothing for Access 2007 :(

    Excel 2007 Add-in: Get Started Tab for Excel 2007 Adds a Get Started tab to the Microsoft Office Excel 2007 Ribbon. Commands on this tab give you easy access to free content on Office Online that helps you learn Excel 2007 quickly.

    PowerPoint 2007 Add-in: Get Started Tab for PowerPoint 2007 Adds a Get Started tab to the Microsoft Office PowerPoint 2007 Ribbon. Commands on this tab give you easy access to free content on Office Online that helps you learn PowerPoint 2007 quickly.

    Word 2007 Add-in: Get Started Tab for Word 2007 Adds a Get Started tab to the Microsoft Office Word 2007 Ribbon. Commands on this tab give you easy access to free content on Office Online that helps you learn Word 2007 quickly.

    Advanced Security Features in SQL Server 2005

    Advanced Security Features in SQL Server 2005 This updated MSDN article discusses:

    • Granular permissions and the principle of least privilege
    • Controling metadata visibility
    • Separation of users and schemas
    • Execution context and encryption in the database

    18 New Templates for SharePoint!

    Something for every one here:

    Windows SharePoint Services 3.0 Application Template: Disputed Invoice Management The Disputed Invoice Management application template for Microsoft Windows SharePoint Services 3.0 helps accounts payable departments track open invoices including the potential savings associated with paying the invoice early.

    Windows SharePoint Services 3.0 Application Template: Sports League The Sports League application template for Microsoft Windows SharePoint Services 3.0 helps an intra-company league administrator manage a baseball league.

    Windows SharePoint Services 3.0 Application Templates: All Site Admin Templates This download package includes all twenty site admininstration Application Templates for Microsoft Windows SharePoint Services 3.0.

    Windows SharePoint Services 3.0 Application Template: Board of Directors The Board of Directors application template for Microsoft Windows SharePoint Services 3.0 provides a single location for an external group of members to store and locate common documents such as quarterly reviews, shareholder meeting notes and annual strategy documents.

    Windows SharePoint Services 3.0 Application Template: Equity Research The Equity Research application template for Microsoft Windows SharePoint Services 3.0 helps teams collaborate on researching stocks and other equities.

    Windows SharePoint Services 3.0 Application Template: Classroom Management The Classroom Management application template for Microsoft Windows SharePoint Services 3.0 helps instructors and students organize and store information related to a particular class.

    Windows SharePoint Services 3.0 Application Template: Employee Training Scheduling And Materials The Employee Training Scheduling and Materials application template for Microsoft Office SharePoint Services 3.0 helps instructors and employees manage courses and related materials.

    Windows SharePoint Services 3.0 Application Template: New Store Opening The New Store Opening application template for Microsoft Windows SharePoint Services 3.0 helps a team manage the opening of new store locations or remodeling of existing store location.

    Windows SharePoint Services 3.0 Application Template: Employee Activities Site The Employee Activities Site application template for Microsoft Windows SharePoint Services 3.0 helps manage the creation and attendance of events for employees.

    Windows SharePoint Services 3.0 Application Template: Manufacturing Process Management The Manufacturing Process Management application template for Microsoft Windows SharePoint Services 3.0 helps teams to model and track manufacturing processes as well as tasks and issues that arise in the upkeep of these processes.

    Windows SharePoint Services 3.0 Application Template: Competitive Analysis Site The Competitive Analysis Site application template for Microsoft Windows SharePoint Services 3.0 helps teams organize information about competitors and their products.

    Windows SharePoint Services 3.0 Application Template: Discussion Database The Discussion Database application template for Microsoft Windows SharePoint Services 3.0 provides a location where team members can create and reply to discussion topics.

    Windows SharePoint Services 3.0 Application Template: Request for Proposal The Request for Proposal application template for Microsoft Windows SharePoint Services 3.0 helps manage the process of creating and releasing an initial RFP, collecting submissions of proposals and formally accepting the selected proposal from amongst those submitted.

    Windows SharePoint Services 3.0 Application Template: Product and Marketing Requirements Planning The Product and Marketing Requirements Planning application template for Microsoft Windows SharePoint Services 3.0 enables teams to manage the process of collecting and documenting requirements for new products.

    Windows SharePoint Services 3.0 Application Template: Business Performance Reporting The Business Performance Reporting application template for Microsoft Windows SharePoint Services 3.0 helps organization managers track the satisfaction of customers through a combination of surveys and discussions.

    Windows SharePoint Services 3.0 Application Template: Timecard Management The Timecard Management application template for Microsoft Windows SharePoint Services 3.0 helps teams track hours spent working on various projects.

    Windows SharePoint Services 3.0 Application Template: Employee Self-Service Benefits The Employee Self-Service Benefits application template for Microsoft Windows SharePoint Services 3.0 provides tools for an organization to inform employees about available benefits as well as enabling them to enroll for each benefit.

    Windows SharePoint Services 3.0 Application Template: Case Management for Government Agencies The Case Management for Government Agencies application template for Microsoft Windows SharePoint Services 3.0 helps case managers track the status and tasks required to complete their work.

    Sharepoint Services 3.0 Get Up to Speed

    These new guides from MS provide a valuable introduction to Sharepoint technology:

    Windows SharePoint Services 3.0 Document: Microsoft Windows SharePoint Services Quick Reference Guide This quick reference guide provides helpful tips and tricks for using Microsoft Windows SharePoint Services while highlighting new features in Version 3.0.

    Windows SharePoint Services Document: Collaboration on the Go This article introduces some of the new features in Microsoft Windows SharePoint Services 3.0 that provide added flexibility, enabling teams to take full advantage of workspace-based collaboration—even on the go.

    Friday, January 26, 2007

    New Video Series: SQL Server 2005 Express Edition for Beginners

    Getting Started with SQL Server Express Learn the basics of how to create, manage, and connect to SQL Server Express databases with this series of 9 hours of video-based instruction that walks SQL Server beginners through the steps of learning about SQL Server databases to actually connecting a SQL Server database to a Web application. From MSDN.

    Introduction
    Learning Video 1: What is a database?


    Designing Tables
    Learning Video 2: Understanding Database Tables and Records
    Learning Video 3: More about Column Data Types and Other Properties
    Learning Video 4: Designing Relational Database Tables


    Database Functions
    Learning Video 5: Manipulating Database Data
    Learning Video 6: More Structured Query Language
    Learning Video 12: Creating and Using Stored Procedures
    Learning Video 13: Enabling Full-Text Search in your Text Data


    Creating and Using Reports
    Learning Video 10: Getting Started with Reporting Services
    Learning Video 11: Embedding, Packaging and Deploying SQL Server Express Reporting Services


    Database Security
    Learning Video 7: Understanding Security and Network Connectivity


    Database Management
    Learning Video 9: Using SQL Server Management Studio Express


    Publishing to the Web
    Learning Video 8: Connecting your Web Application to SQL Server 2005 Express Edition
    Office 2007 Interactive Command Reference Guides

    Nothing for Access 2007 yet :(

    Word 2007 Guide: Word 2003 to Word 2007 interactive command reference guide
    Excel 2007 Guide: Excel 2003 to Excel 2007 interactive command reference guide
    PowerPoint 2007 Guide: PowerPoint 2003 to PowerPoint 2007 interactive command reference guide

    Wednesday, January 24, 2007

    Office 2007 Ribbon Customization: Update

    On the OpenXML.org site there is a link to an applet created by Trang Luu for working with Office 2007 Ribbon customizations stored in Office Open XML documents: Office Custom UI Editor.

    The Editor simplifies the process of extending an Office ribbon by adding new groups and controls, hiding existing ribbon elements, and defining callbacks to handlers in managed code. Other features include inserting custom control icons, generating callbacks, and validating custom XML.

    SharePoint 2007 Development Guide

    Seven Development Projects with the 2007 Microsoft Office System and Windows SharePoint Services 2007 (PDF) This guide highlights architectural underpinnings, the latest enhancements for developers, and code samples for building custom applications and solutions.
    Latest MS Office Resources from Microsoft

    Office Business Applications This book is about composite applications and how they can be developed as OBAs using the 2007 Microsoft Office System.

    Word 2007: Rich Text Format (RTF) Specification, version 1.9 The Rich Text Format (RTF) Specification provides a format for text and graphics interchange that can be used with different output devices, operating environments, and operating systems.

    SharePoint Server 2007 Code Sample: Item-Level Auditing This code sample shows you how to create an item-level auditing view programmatically in three different ways: using a custom SharePoint list, through the Excel client, and by manipulating the open XML file format to display auditing history.

    Microsoft Office Live Code Sample: Contact Map This download will install a sample code mashup for Microsoft Office Live which is designed to map the addresses of all contacts included in an Office Live Business Contact Manager application.

    Conditional Formatting: Adding Custom Conditional Formatting to Excel 2007 Learn about enhancements to conditional formatting and how you can create custom conditional formatting options by using the Ribbon in Microsoft Office Excel 2007.

    Office Space: Building Office Open XML Files This new MSDN column explores how you can extend and customize Microsoft Office System applications and file formats.