Recordset Helper for Access

Click any text or icon to edit or style it. Use the block parameters to hide/show text or icons and change media size or position.

Integrated Access Toolbar

Quick access to the 2 main features directly from Access

SQL Formatting

The SQL code that Access provides when creating a query is less than ideal and can be downright unreadable. The Recordset Helper provides a much-improved SQL format that is customizable.  From that a string can be generated that you can then place in your code.

Recordset Viewing

You can add the Recordset Helper to your application with just a few simple lines of code.  This allows you to monitor and debug your recordset objects (DAO or ADO) while your code is running.

Screen Snap

Not being able to see forms or tables when you are debugging in Access is a significant limitation.  This Screen Snap tool is similar to the Snipping tool in Windows but is easier and quicker to use. 

The Table Object.

Three handy methods related to easily creating and manipulating a table.

  • Create takes the contents of a Recordet object and creates the table in its image.
  • Append will match any fields (columns) that are the same in the appending recordset and will add those values.
  • PadColumn will add records to the table if a record does not contain the value for the padded column.

Download Setup (.exe)

Includes Help (.chm) and examples

Detailed documentation

Full on-line help

This tool is provided for free.  If you appreciate what it does then please consider supporting

Contact US