Category Archives: Total Visual SourceBook

Apr 28

Microsoft Access Video on VBA Programming with Luke Chung at Access DevCon 2017

Posted on by

FMS President Luke Chung was a presenter at the Microsoft Access DevCon 2017 in Vienna, Austria in early April.

Before giving two conference presentations, he was sat down and spoke with Philipp Stiefel of codekabinett.com of Germany. Philipp is creating a series of videos discussing VBA development.

Luke shares the history of how FMS Inc. began working with MS Access and how we now offer 12 products for the Access community, including Total Access Analyzer, Total Access Emailer, Total Visual CodeTools, and Total Visual SourceBook.

They talked about:

  • VBA Best Practices
  • How end-users migrate from Excel to Access, then learn how to code
  • Why people are hesitant to purchase third party products and how FMS overcomes that by showcasing the value we offer
  • Using tools like Total Access Analyzer to catch errors before shipping and learning best practices
  • Using the module code in Total Visual SourceBook to address problems we’ve already solved so you can focus on the unique issues in your applications
  • The value of creating consistent, quality code
  • How to improve code for developers of all backgrounds
  • Being in constant “growth” mode to look for ways to become a better developer

FMS Inc. is proud of the quality of products we have produced for the past 30 years. We are honored to continuously be regarded as a leading expert in the Access community. Thank you for supporting us and we hope you enjoy the 20 minute interview!

 

Nov 05

Total Visual SourceBook 2013 Ships

Posted on by
Total Visual SourceBook Total Visual SourceBook

We are delighted to announce the release of Total Visual SourceBook 2013. Total Visual SourceBook is our royalty-free source code library for Microsoft Access/Office VBA developers and Visual Basic 6 (VB6) developers.

code-explorer-web

The new 2013 version is an upgrade to our Total Visual SourceBook 2007 version. The new version is especially designed for the new features introduced in Microsoft Access/Office/VBA 2013 and 2010. It can also run in Access/Office 2007 and older versions through Access/Office 2000.

New Features

Total Visual SourceBook 2013 includes 35 new modules, 25,000+ more lines of code, enhancements to existing modules including VBA code that’s compatible with 32 and 64-bit versions of Office.

The user code database can now be upsized to SQL Server to simplify sharing code among your developer team. The new version also includes many enhancements to the code browser to simplify your experience in viewing, searching, adding, editing, and applying different error handlers to the source code.

For a complete list of enhancements, visit our New Features page.

Additional Resources

Feb 15

Luke Chung Speaking at Portland Access User Group Conference in May

Posted on by

FMS President Luke Chung will be attending and speaking at the three day Microsoft Access conference sponsored by the Portland Oregon Access User Group.  Join him and other guest speakers including Alison Balter from InfoTech Services Group Inc., Armen Stein from J Street Technology, and Kevin Bell from Microsoft.

Luke will be speaking on the following topics:

  • FMS Products for Microsoft Access Developers and How they Make You Money
  • Microsoft Access and Azure: Working in the Cloud
  • Microsoft Access Disaster Recovery Plans

For complete details visit PAUG 2011 Database Designer Conference and see you there May 14-16, 2011.

May 11

Avoid Using DoEvents to Wait in Microsoft Access, VBA, and VB6

Posted on by

In our Microsoft Access, VBA, and VB6 programs, we often need to pause processing for a certain period of time, or until a specific time, and then continue processing. One common way to do this is to use the DoEvents function in a loop while waiting, however, this method consumes the CPU time and slows down the PC considerably. This is a significant problem when pausing for more than a couple of seconds, when users will notice the slow down. Use the Sleep command instead.

This is available in our Total Visual SourceBook!

May 11

Adding (and Subtracting) Weekdays in Microsoft Access, VBA, and VB6

Posted on by

Microsoft Access, VBA, and VB6 include a wide range of built-in Date functions, including DateAdd, which calculates the difference between two dates. A common need, however, is to add a number of weekdays to a date, without counting weekend dates.

Learn about this and all our royalty-free module code in Total Visual SourceBook where you can also perform business day math with a list of holidays to avoid.

Feb 19

Total Visual SourceBook 2007 Module and Procedure List Is Available

Posted on by

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 25

New Update for Total Visual SourceBook 2007

Posted on by

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 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.