Feb 19

Total Visual SourceBook 2007 Module and Procedure List Is Available

Microsoft Access ModulesTotal Visual SourceBookMicrosoft Access Modules

The complete list of modules and procedures in our Total Visual SourceBook professional source code library is now available for your review. From the list of Microsoft Access/Office/VBA/VB6 modules, you can click on any item to get its details.

194 royalty-free modules and classes are available covering all aspects of application development. Learn more about what's available, so you can simply use our code rather than writing your own. It's all open source, so you can learn from it or enhance it to your specific needs.

Jan 27

Considering Cloud Computing with Microsoft Azure?

The Microsoft Azure platform is now available for production use!

We’ve been using Azure over the past year for web/asp.net hosting and SQL Server solutions. We have been very impressed with its features and capabilties. We believe it will revolutionize how we create and deploy applications, and look forward to providing commercial and custom solutions and services with Azure.

We’re already working on several projects including the merging of the Windows desktop/Microsoft Access/Office with the web. We look forward to sharing more with you in the near future.

What do you think about Azure and cloud computing?

Jan 25

New Update for Total Visual SourceBook 2007

Microsoft Access ModulesTotal Visual SourceBookMicrosoft Access Modules

Total Visual SourceBook is the most popular professional source code library for the Microsoft Access/VBA/VB6 community. This huge library of powerful, well tested, and documented VBA/VB6 source code is available for your projects royalty free! Eliminate the drudgery of writing code that already exists. Simply insert our code into your project and run it.

As part of our commitment to quality, we are pleased to announce that we have released a new update for Total Visual SourceBook 2007. This update resolves all known issues since their original release.

The updates are available free of charge to registered owners who were notified via email. If you did not receive instructions, please contact us so we can update your information. 

Jan 22

Microsoft Access Percentile Calculations with Total Access Statistics

Total Access Statistics
is the world’s most popular data analysis program for Microsoft Access. It runs as an Access add-in to let you extend the numerical analysis capabilities of Microsoft Access queries.

A common need among MS Access users and developers is the need to calculate percentiles. We’ve created a new page providing more details on how to Calculate Percentiles in Microsoft Access with Total Access Statistics. Percentiles can be generated on the data from your table or query, and are provided in three ways:

  • A new table with each percentile value as a separate field
  • A new table with each percentile value as a separate record
  • Updating a field in your table with the percentile value corresponding to the data in your record

Download the Total Access Statistics trial version to see for yourself on your own data.

Jan 06

The HotMommas 2009-2010 Case Study Competition Has Begun

The HotMommas Project

Professor Kathy Korman Frey at the George Washington University School of Business has kicked off the 2009-2010 HotMommas Case Study Competition. It is a unique project that takes the stories of the women and makes them teachable in a “case study” format, thus providing scalable, global access to role models and virtual mentors. You may recall us mentioning our work on this project not long ago.

If you want to nominate someone (yourself included) for the 2009-2010 competition, go to the HotMommas Facebook page or send an email with their information.


The HotMommas Project

Why Role Models Matter for Women and Girls

Hot Mommas Project Everyday Revolutionaties

Washington Post article

Dec 12

Microsoft Access/SQL Server Query Tip: Finding Records in One Table but Not Another with “Not In” Queries

Here’s another resource in our ongoing coverage of query techniques:

Learn how to create queries to find all the records in one table that don’t have corresponding records in another table. If you’re not familiar with the difference between Inner Join, Outer Join, Left Join and Right Join, check out our paper on Microsoft Access Outer Join Query: Finding All Records in One Table but Not Another and Creating “Not In” Queries on these important query feature. It’ll save you tons of time trying to code this yourself and will surely give you new ideas on how to better retrieve and analyze your data. The techniques apply to both Microsoft Access and SQL Server queries.

Dec 04

Microsoft Access Delete Query SQL Syntax

Delete Query in Microsoft Access Could not delete from the specified tables.JPG

Here’s an additional paper related to our ongoing coverage of queries. This time we’re covering DELETE query syntax in Microsoft Access. In addition to the basics of deleting data and the SQL for DELETE queries, we also cover an interesting situation when DELETE queries fail during multi-table links on non-keyed fields.

If your query fails to delete any records with this message: “Could not delete from the specified tables”, learn why and how to fix it with the DISTINCTROW syntax or setting the Unique Records property to Yes.

For more information on queries in general, read our paper on Microsoft Access Query Tips and Techniques.

Oct 23

Access Tip: Simulating the Microsoft Access Runtime Version during Development

The Microsoft Access runtime version allows you to distribute your Access applications to users who do not have a full license of Access. The runtime is similar to the full version of Access, but several of the features that exist in the full version are not available in the runtime. To test your users’ experience, you can simulate the runtime with a command line.

To learn more, read our tip: Simulating the Access Runtime during Microsoft Access Development.

Oct 23

Update Query and SQL Syntax in Microsoft Access

Related to our detailed paper on Query Tips and Techniques, we added extra information on the basics and syntax of an Update Query in Microsoft Access.

We also have a related article on dealing with non-updatable queries: Error 3073: Operation must use an updatable query: Dealing with Non-Updateable Queries and the Use of Temporary Tables in Microsoft Access.

Oct 09

Speaking at Office Devcon 2009 in Australia Oct 31 – Nov 1

I’ll be giving several presentations on Microsoft Access application development and our products at the Office DevCon 2009 conference in Brisbane, Australia at the end of the month. Hosted at the University of Queensland, St. Lucia campus, I hope you see you there!

For more information, visit our Upcoming Events page.