Friday, August 27, 2004

Developing Office 2003 solutions with .NET Get started with a simple VB.NET application from TechRepublic.

Access 2003 Add-in: Source Code Control New MS Access Add-In from MS to support integration between source code control programs and Access 2003 SP1.

Thursday, August 26, 2004

Office 2003 Tool: Smart Tag Developer Tools This MS download contains tools for developing smart tags, including the Smart Tag Explorer and Smart Tag Recognize Tester, and a white paper explaining how to use these tools.

Friday, August 20, 2004

ASP, ASP.NET, Personal Web Servers, and Windows XP Home After discovering that WinXP Home does not support MS Personal Web Server or IIS, I was in a quandary on how to work on ASP pages on a WinXP Home PC.

After Googling around on and off for a few days, I located the following easy to setup and reliable solutions:
  • For ASP install Abyss Web Server XI (freeware) and Selisoft's Active HTML Extensions (shareware)
  • For ASP.NET install Cassini ASP.NET Web Server (freeware: requires .NET Framework 1.1)

For developing web pages accessing MS Access databases try these applications:

  • ASP: DBQwikSite v2.5.2 (Sponsored Version is free)
  • ASP.NET: Microsoft's free ASP.NET Web Matrix (requires .NET Framework 1.1)

Google searches will quickly locate download sites for all these applications.


Wednesday, August 18, 2004

Find Databases Wizard I have today launched this free application, which finds all the MS Access files in the location you select and classifies each file by Access version, lists all the files found in the application, and saves the data in a text-delimited file.

Friday, August 13, 2004

Download VB and VBA Code Samples from Microsoft

101 Visual Basic Code Samples This download includes a master set of Visual Basic code samples demonstrating various aspects of the language in the following areas: syntax, data access, Windows Forms, Web development and Web services, XML, security, the .NET Framework, file system and file I/O, interop and migration issues, COM+, ADO.NET, and advanced topics including graphics with GDI+, remoting, serialization, MSMQ, and Windows services.

VBA Samples for Working with Excel 2003 Worksheets Macros that you can use to add additional functionality to your Excel worksheets.

Wednesday, August 11, 2004

XML Everywhere:

New XML Features of the Microsoft Office Word 2003 Object Model

Transform a MS Word ML Document with XSL

Microsoft Office 2003 XML Reference Schemas

XSLT Articles

DevX: XML Zone

Generating XML Documents from XML Schemas Use the classes in the System.XML.Schema namespace of the Microsoft .NET Framework to build a tool that generates sample XML documents conforming to a given schema.

Sunday, August 08, 2004

New MSDN MS Office-related articles:

Generating XML Documents from XML Schemas
Generate XML Documents from XML Schemas

Office 2003 Tool: FabriKam Solutions Learning Platform
A compiled help file (CHM) for use with the Fabrikam sample files.

InfoPath 2003 Software Development Kit (SDK) Contains sample forms, tools, and documentation to assist with Microsoft Office InfoPath 2003 and InfoPath 2003 Service Pack 1 form development and deployment.

KioskXMLFile KioskXMLFile

Wednesday, August 04, 2004

Access 2003 Conversion Toolkit Use the Toolkit to find and analyze your databases in preparation for switching to the latest version of MS Access.


Need help with MS Access? Try these free resource, support, and forum sites:

Allexperts.com
Volunteer experts answer one-on-one Microsoft Access questions for free.

AxSOS
Submit your MS Access questions and receive responses by email. Has a searchable FAQ.

Experts-Exchange.com: Microsoft Access
Exchange information and solve problems in discussions forums.

OpenITx: Access-L
An email list and archive of all aspects of MS Access development.

QuickTechUSA Discussion Forum
Active forum discussing all aspects of MS Access.

Tek-Tips Microsoft Access Forum
Technical support forums and mutual help system for Access developers.

Utter Access Discussion Forums
Free site with discussion forums and entry level articles about using Access.