• Add-In to format SQL for use in code and reports
• Easy Uploading/Downloading/Browsing using an FTP server
• Array sorting techniques in VBA
• File System Class Modules (Copy, Move, Delete, Recycle)
• Recursive scan of folders and subfolders
• Automatic line numbering for Tabular Forms
• Line Printer Class Module
• Progress bar drop-in subform
• Ordered list selection drop-in subform
• Send email messages and attachments using the CDO library
• Accept files dragged from Windows Explorer

Format SQL for use in code

Converts SQL from:

SELECT tblDemo.Field1, tblDemo.Field2, tblDemo.Field3, tblDemo.Field4, tblDemo.Field5, tblDemo.Field6, tblDemo.Field7, tblDemo.Field8, tblDemo.Field9, tblDemo.Field10
FROM tblDemo
WHERE (((tblDemo.Field4)=False))
ORDER BY tblDemo.Field2;

To (Code friendly):

    s = "SELECT tblDemo.Field1,"
    s = s & "tblDemo.Field2,"
    s = s & "tblDemo.Field3,"
    s = s & "tblDemo.Field4,"
    s = s & "tblDemo.Field5,"
    s = s & "tblDemo.Field6,"
    s = s & "tblDemo.Field7,"
    s = s & "tblDemo.Field8,"
    s = s & "tblDemo.Field9,"
    s = s & "tblDemo.Field10"
    s = s & " FROM tblDemo"
    s = s & " WHERE (((tblDemo.Field4)=False))"
    s = s & " ORDER BY tblDemo.Field2;"

Also to (Printer friendly):

SELECT tblDemo.Field1,
    tblDemo.Field2,
    tblDemo.Field3,
    tblDemo.Field4,
    tblDemo.Field5,
    tblDemo.Field6,
    tblDemo.Field7,
    tblDemo.Field8,
    tblDemo.Field9,
    tblDemo.Field10
FROM tblDemo
WHERE (((tblDemo.Field4)=False))
ORDER BY tblDemo.Field2;

FTP Client

FTP Client is an Access 2000 class module to provide easy FTP upload, download and browsing facilities to an application. Fires events 'FileFound' and 'FolderFound' (among others).
A small mdb is included to demonstrate it's abilities.

Sequence Dancing

Sequence Dancing is an Access 2000 database which demonstrates various array sorting algorithms. Watch the sorts at work using an on-screen bar graph composed of Access label controls.

File System Class Modules

This demo mdb file contains three Access 2000 class modules:

• sjmFileDialog - Windows File Open/Save dialogs
• sjmFileOp - Windows File Operations (Copy, Move, Rename, Delete/Recycle)
• sjmFolderDialog - Windows Folder selection dialog

Automatic line numbering

A small Access 2000 mdb to demonstrate an automatic line numbering technique for use with tabular forms. Also renumbers item lines following a deletion.

Line Printer is an Access 2000 class module to provide easy character-mode printing to a local or remote printer via the Windows Print Spooler. Sends raw binary data, including escape sequences. A small mdb is included to show the syntax.

Contains a re-usable subform to provide progress (percentage) bar functionality to any form.
A test form is supplied to demonstrate usage.

Contains a re-usable subform to provide ordered list selection functionality (using two listboxes) to any form. A test form is supplied to demonstrate usage.

Send email messages and attachments using the CDO library

clsCDO is a class module to enable easy access to the CDOSYS library for sending email messages via SMTP. A small mdb is provided to demonstrate the syntax.

FsRecurse is an Access 2000 class module to provide fast recursive scanning for files inside folders including subfolders. A small mdb is included to show the syntax.

Dragdrop is a sample mdb containing 3 importable items: sfrmDragDrop, modDragDrop and clsDragDrop. Between them, they allow Access apps to accept items (folder and file paths) dragged from Windows Explorer.
Also contains a sample form to demonstrate the technique.