Oct 06

Access Tip: Reference Tab Pages by its PageIndex Rather than Tab Value on Microsoft Access Forms

Here's a simple tip to avoid problems associated with referencing the individual pages (tabs) of a Microsoft Access tab control in VBA.

Tabs are powerful and easy to use on Microsoft Access forms. A tab control contains pages (tabs) with each page identified by its PageIndex property starting with 0. The value determines the order of the tabs. However, if you reference the pages by number, your code may fail if the pages are reordered, new ones added or pages deleted. 

See how you can avoid this problem and read about other tips for creating better and faster Access forms.

Oct 06

FMS Papers Featured on MSDN

MSDNMicrosoft recently added three of our technical papers to their MSDN (Microsoft Developer Network) web site:

We're proud Microsoft recognized our work and look forward to sharing more resources with the developer community.

Aug 03

Total Access Detective Versions X.7 for Access 2003, 2002, and 2000

Microsoft AccessMicrosoft Access Database and Object Comparison ProductTotal Access Detective for Microsoft AccessFind Differences Between Microsoft Access Objects and Databases

With the recent release of Total Access Detective for Access 2007, we're pleased to provide new versions for Microsoft Access 2003, 2002, and 2000 (versions 11.7, 10.7 and 9.7 respectively).

Version X.7 adds many new features including data comparison between two queries, enhanced data comparison options such are comparing two tables when field names are not identical (compare only identical field names or on field order), using the first field as the key field if no key field exists, skipping small numerical data differences, ignoring case differences between modules, improved support for ADP comparisons, etc. Existing customers can upgrade for a nominal fee.

Existing Total Access Detective customers under annual support contracts receive the upgrade for free.

Jul 22

Total Access Detective 2007 Is Shipping

Microsoft AccessMicrosoft Access Database and Object Comparison ProductTotal Access Detective for Microsoft AccessFind Differences Between Microsoft Access Objects and Databases

Total Access Detective makes it easy to find differences between any two Microsoft Access databases or objects. Know exactly what changed with your properties, fields, indexes, controls, sections, macro lines, VBA module code, and data! Find new, deleted, and modified records. You can even merge data from two tables into a new one.

New features in Version 12 include support for Access 2007 and the new ACCDB database format with multi-value fields, data comparison between two queries, enhanced data comparison options, improved support for ADP comparisons, ignoring case between modules, a more modern user interface, and much more!

Version 11.7, is also available as a new version for Microsoft Access 2003.

Jun 24

FMS Offers Custom Microsoft SQL Server Database Consulting Services

Consulting Services for Microsoft SQL Server As you may know, our Professional Solutions Group offers custom Microsoft ASP.NET solutions, but we are also known for providing Microsoft SQL Server consulting services for a variety of clients in the private and public sectors.

We encourage you to read more about our SQL Server database development services. Please contact us for a free assessment of your organization’s requirements.

Jun 10

FMS Offers Custom Microsoft ASP.NET Website Development Services

Consulting Services for Microsoft ASP.NET Over the past year our Professional Solutions Group has delivered some notable ASP.NET web projects, including The HotMommas Project, a case study competition website for women entrepreneurs that has received a lot of press, and a competency and courseware management system for the DoD’s Defense Acquisition University.

We encourage you to read more about our ASP.NET web development services. If you need a quality website, we have an experienced group of business consultants, web developers and database experts that would love to help. Please contact us for a free assessment of your organization’s requirements.

Jun 10

Video: Migrating Your Data Tier to SQL Server: Strategies for Survival

I participated on this panel at the Microsoft TechEd Conference to explore Panel Discussion on Migrating Data to SQL Serverthe different reasons and approaches for migrating applications to Microsoft SQL Server. In addition to moving the data to SQL Server, ideas are presented for transforming applications to offer additional features while maintaining budgets. (43 minutes)

Jun 10

Video on the History of FMS: Surviving Uncertain Times

Video: Surviving Uncertain Times: History of FMSAt the Microsoft TechEd conference. Microsoft’s Mary Chipman conducted a one-on-one interview about the history of FMS and how we’ve survived the economic and technical cycles over our 23 years of existence. Learn more about FMS, our successes and challenges over the years and today. (28 minutes)

Jun 03

Video: The World Turned Upside Down: Development Strategies for Lean Times

Worried about your job or career?  Uncertain about what to do to protect your future? 

Watch this video from my panel discussion at the Microsoft TechEd Conference. Hear me share my experiences at FMS with fiver other developers, and different ways we’ve survived over our careers. Entitled The World Turned Upside Down: Development Strategies for Lean Times, the video is 51 minutes.

May 22

Video: Let’s Talk about Software Consulting as a Business

Here's the video from my panel discussion at the Microsoft TechEd Conference. Taped on May 11th at the Los Angeles Convention Center, hear me share my experiences at FMS with two fellow software consulting firm entrepreneurs. Learn from our efforts over the past two decades, the challenges we face, and how we've been successful. Entitled Let's Talk about Software Consulting as a Business, the video is 54 minutes.