Monday, November 29, 2004

Handling Image Storage in MS Access Databases

Interesting articles with many references from ammara.com, the makers of DBPix, an Image Control for building database applications with picture handling capabilities, such as photo databases and other image management systems:

Images - Access image storage Avoiding overhead and loss when storing images in Microsoft Access.
Pictures in Access Forms & Reports Common Access OLE Object Photo & Image Problems including Access 2003.
Access Image Database Techniques Access image-handling approaches compared.


Multiple Column Reports Sample MS Access Database

Access 2003/2002/2000 Sample: Multiple Column Reports Sample Database The Multiple Column reports sample database for Microsoft Access contains sample reports that demonstrate creating telephone book style multiple column reports.

Thursday, November 25, 2004

Download the Latest MS Office Language References

Discover 15 New MS Office 2003 VBA Language References Customise and integrate Office programs with the new Office 2003 language references for Access, Excel, FrontPage, Office 2003, Outlook, PowerPoint, Project, Publisher, Visio and Word. Also, refences for Office XP And Office 2000.

Related Resources:

Tuesday, November 23, 2004

Ditch that Tired and Boring native MS Access Switchboard!

My latest Access Demo Database featuring cutting edge application navigation:




Maximizes available application space by using these dynamic features:

  • Uses Switchboard Items table created by the MS Access Switchboard Manager
  • Outlook-style navigation
  • Custom combined graphical buttons/hyperlinks
  • Users can hide the Switchboard to maximize form size
  • Users can adjust the width of the Switchboard on the fly...

You can use the demo as a Contacts Manager or buy the source code to use the GUI in your own Access applications.

Download the free SideBar Switchboard Demo
(sidebarswbdemo.zip - 4mb includes MSI Installer)

Friday, November 19, 2004

New Free Office 2003 Add-In

Office 2003 Add-in: Microsoft Outlook SMS Add-in (MOSA) Send SMS text messages through most Global System for Mobile Communications (GSM) mobile phones connected to your PC using Microsoft Office Outlook 2003.

Wednesday, November 17, 2004

Database Design: The Danger of NULL values

Does allowing NULL values in fields introduce a whole new degree of uncertainty into your database? Article

Friday, November 12, 2004

Get up to Speed on New MS Office Technologies #2

Creating an Estimate Solution Using Visual Studio Tools for Office, Version 2005 Learn about a basic order entry system that uses Excel 2003 for data entry, calculation, and charting capabilities, and Word 2003 for the generation of a report.

Enhancing Office 2003 Research Services with Graphics and Fancy Fonts how to jazz up a Microsoft Office 2003 research service by displaying results using graphics and special fonts.

Thursday, November 11, 2004

Get up to Speed on New MS Office Technologies:

New DataSet Features in ADO.NET 2.0 Get performance enhancements and improved functionality in the .NET Framework 2.0 DataSet class, and in the closely related DataTable and DataView classes.

Enhancing Office 2003 Research Services with Graphics and Fancy Fonts How to jazz up a Microsoft Office 2003 research service by displaying results using graphics and special fonts.

Creating an Estimate Solution Using Visual Studio Tools for Office, Version 2005 Learn about a basic order entry system that uses Excel 2003 for data entry, calculation, and charting capabilities, and Word 2003 for the generation of a report.

Wednesday, November 10, 2004

Latest Articles and Sample Applications for MS Office Developers

Excel 2003 Sample: Microsoft Excel 2003 Inside Out Sample files from the book Microsoft Excel 2003 Inside Out.

Excel 2003 Sample: Microsoft Office 2003 Inside Out Sample files from the book Microsoft Office 2003 Inside Out.

Access 2003 Sample: Inside Out Sample Files Sample files from the book Access 2003 Inside Out.

MSDE 2000 Deployment Toolkit (Sample Application) Automates the process of creating an integrated package with both the application and the MSDE database.

From MS TechNet:

Tuesday, November 09, 2004

Microsoft Word Help Center

TechRepublic's MS Word Help Center for one-stop tips and tricks for mastering Word's myriad features.

Microsoft Office 12 is coming... Sources close to Microsoft indicate that the next version of Office is coming to beta in August of 2005 with general release by July of 2006. According to the sources, the next Office will have both desktop and server components, including the "Excel Calculation Server" and the "InfoPath Forms Server" along with updated version of Content Management Server and SharePoint Portal Server.

Friday, November 05, 2004

New MS Office Small Business Release to include New Payroll Functionality

Microsoft is set to launch on November 8 its small-business solutions strategy, one element of which will be a new version of Microsoft Office designed expressly for the small-business manager/owner. The new Office release is expected to include new payroll functionality, an updated version of Microsoft's business-contact-manager technology, and new Web services, according to sources close to the company. Microsoft already sells a small-business version of Office, Office Small Business Edition 2003. That product bundles together Word, Excel, Outlook, PowerPoint, Publisher and the current release of business-contact manager. From microsoft-watch

Microsoft Office Outlook 2003 Inside Out: Using VBA in Outlook Introduction to the VBA environment. Provides examples of simple ways to use VBA within Outlook 2003 to automate common tasks.

Wednesday, November 03, 2004

100 Microsoft Office Tricks:

100 MS Office Tricks: Part 1

100 MS Office Tricks: Part 2

Tuesday, November 02, 2004

Tip: Add (All) to a LookUp Combobox

To add (All) as the first item in the droplist of an unbound combobox, replace the RowSource property with the following SQL string:

SELECT City FROM tblRegions
UNION SELECT "(All)" FROM tblRegions;