Jan 15

Total Visual SourceBook 2007 Ships for Microsoft Access, Office, and Visual Basic 6

Posted on by

Microsoft Access ModulesTotal Visual SourceBookMicrosoft Access Modules

Total Visual SourceBook, the most popular professional source code library for Microsoft Access, Office and Visual Basic 6 is shipping with an expanded code base and improved code manager. With 194 modules/classes and over 100,000 lines of code, Total Visual SourceBook lets you add our well written, documented, and tested code into your VBA/VB6 projects royalty-free. Includes full support for Access 2007, lots of new code for Outlook 2007, Office 2007, the web, etc. Learn more about Total Visual SourceBook and why so many developers use and learn from our years of experience creating professional quality solutions.

Jan 06

The HotMommas 2009-2010 Case Study Competition Has Begun

Posted on by

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.

Links

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

Posted on by

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

Posted on by

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

Posted on by

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

Posted on by

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 16

Save Your Job, Relationship, or Client by Delaying Your Outlook Messages

Posted on by

Have you ever wished you could bring back a message after you press the Send button in Outlook?  Maybe you forgot to add an attachment, or maybe an email came in while you were writing your message that changes what you want to say.

Or maybe you were a bit too hot headed, and that message really should be deleted. No matter what, Outlook offers a feature that I love, which is the abilty to delay mesages in my Outbox for a few minutes. My two minute delay has saved countless blunders.

Here's our Microsoft Outlook tip on delaying messages that describes how to avoid these career and relationship ending mistakes.

Oct 09

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

Posted on by

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.

Oct 06

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

Posted on by

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.