Recursive Creativity LLC

RECURSIVE CREATIVITY LLC

MISCELLANEOUS

Content listed below are items that do not fit in other menu categories.


Dynamics GP (formerly Great Plains Dynamics)

Accounts Receivable Dashboard

The screenshot shows a dashboard with button that utilizes a Stored Procedure to update the data at the click of a button. The receivables can be sorted in any manner and the "aging" buckets can be customized. For example, the first two aging buckets could be combined to create "00 to 30 Days" bucket, the last bucket could be change to "91 to 120 Days" and a bucket could be added for "over 120 Days".


Trial Balance

The screenshots below are various views of the Trial Balance sorted using the toggle button.

These files will be posted at a later date as will some snapshots of Financial Statements.

Last Updated: November 22, 2011 Top of Page

JavaScript


Examples of useful JavaScripts can be found here: JavaScript Examples.doc

Last Updated: March 6, 2021 Top of Page

Miscellaneous VBA


PowerPoint code is for refreshing linked Excel objects and breaking the links after saving "dated" files. Code automatically adds last Friday's date to file name...it can be changed to any week day or modified to use msdate. Using msdate will date stamp "dated" files with today's date. Thanks to Shyam Pillai, MVP for permission to use and display his code.

Word code is for refreshing linked Excel objects and breaking the links after saving "dated" files. Code automatically adds last Friday's date to file name...it can be changed to any week day or modified to use msdate. Using msdate will date stamp "dated" files with today's date.


The code for the above is found in examples files posted at:

Last Updated: July 17, 2012 Top of Page

VBScript


Examples of useful VBScripts can be found here: VBScript Examples.doc

File includes code (and sample script files) to do the following:
  • Kill, Terminate and Application or Process
  • Get count of folders and files for given path(s)
  • Map a network drive
  • Unmap a networks drive

Last Updated: March 6, 2021 Top of Page

Visual Basic

While Visual Basic 6 was still around I developed one program which automated the WinZip Command Line Tool. Links are provided to a screen shot of the program and the executable file.

Much of the functionality of this program is built into an Excel file I also developed and WinZip blessed.

WinZip thought so much of my ideas they incorporated them into their product!

In short, this program automated WinZipping your My Documents (Windows XP) and allowed user to specify individual paths for WinZipping. Versioning was also supported. Versioning added the YearMonth (YYYYMM) to end of the file name created during the WinZip process.


Screen Shot


Windows XP Windows Vista I have not tested on Windows 7 but the Windows Vista file should work with Windows 7.

Last Updated: October 18, 2011 Top of Page