Lebans Holdings 1999 Ltd.

 Home ] Feedback ] Contents ] Search ] [ What's New ] Files & Tips ] 

What's New
Home

RETIRED! September 2009

I have officially retired from all things Access. Please do not send Email requesting support as I will not respond.

 

Keep all of your questions to the Newsgroups where everyone will benefit!

 

 


What's New!

Update June 9 /2008 ReportToPDF is a database containing a function to convert Reports and Snapshot files to PDF documents. No PDF Printer driver is required.

ExtractInventoryOLE     Feb 06/2006 update. A2K or higher ONLY! This version saves the entire contents of a table containing OLE Objects to disk. Does NOT require the original application that served as the OLE server to insert the object. Supports all MS Office documents, PDF, All images inserted by MS Photo Editor, MS Paint, and Paint Shop Pro. Also supports extraction of PACKAGE class including original Filename. Contains function to produce a full Inventory of the OLE field including LINKED path and Filenames. Uses Structured Storage API's to read the actual contents of the field. Version BETA 1.56

WindowToBitmapVer1.2 is a database containing a class to allow you to capture and save the entire contents of the Relationships window to a disk based Bitmap file. Added support to allow the user to save the Query Design window to disk. This feature is only available in the A2K version!

 A2KSelectTable/QueryInRelationshipViewWindow is an MDB containing functions to allow the user to select and scroll into view a Table/Query within the RelationshipView window.

UPDATED! ToolTip is a database containing a custom ToolTip class. Updated to support form Header and Footer sections.

AddSQLComments is an MDB containing functions to allow the saving of Comments in the SQL View window.

A97GradientFill is a database containing a function that demonstrates how to enable Gradient Backgrounds for your Forms with a single function call.

WORD contains code to enable the user to Export embedded Images within a MS Word document to disk based Bitmap or Enhanced Metafile format.

MonthCalendar Update! Major modification to the calling function logic including calling Parameter order.  Changed function to return Boolean FALSE and "StartSelectedDate =0"  if user did not select a date from the MonthCalendar. `

MouseHook now correctly handles Tab and Option Group controls. Removed Bug that would at times allow a multiline TextBox control to pass the MouseWheel messages onto the Form. Allows users to Scroll within a ComboBox control. Allows MouseWheel to work in SubForms. Leaves all non Access Form windows alone!  The logic in the DLL was completely rewritten. Works with all Access Form controls.

A2KLoadJpegGifGDIPlus is an update to the function to allow for the Display of Jpeg and Gif files on systems that do not have the Office Graphic Filters installed. TIF and PNG formats are now supported via the Microsoft GDI+ DLL. The GDI+ DLL is freely redistributable and available directly from MS.

TabColors has been updated too allow for the highlighting/coloring of the Current/Active TAB page.

ComboCurrentRow is an MDB containing code showing how to calculate the current row highlighted within a ComboBox control.

 A2KSave-RestoreRelationshipWindow is an MDB containing functions to Save and Restore the Relationships View Window. Allows an unlimited number of different Relationship Window Views to be saved.

OpenFormRelativeToControl is an MDB showing how to open a second Form relative to a control on the parent Form.

Updated Ver. 9.1a MonthCalendar replaces the older MouseWheel subclassing solution. No ActiveX DLL registration issues. One instance handles all forms in your app.

MouseHook replaces the older MouseWheel subclassing solution. No ActiveX DLL registration issues. One instance handles all forms in your app.

Updated Ver. 4.0 JustiDirect is a database containing Functions to produce fully justified text within standard TextBox controls on your Reports.
Allows a standard Access TextBox, bound to a Memo field to not only produce fully justified text, but use the CanGrow/CanShrink properties as well.

Updated Ver 5.0  LoadJpegGif - Developed to allow Access RunTime installations to display Jpeg files in a standard Image Control. Provides functionality to load JPG,GIF,BMP,EMF,WMF,CUR and ICO  files on systems without the Office Graphics Filters loaded.  Supports transparency in Transparent Gifs.  Allows you to resize Images on Forms/Reports at runtime  with no loss of Image quality.

CopyGetRTFfromClipboardA2K demonstrates how to copy and get RTF from the Clipboard. Requires Microsoft Rich Edit ActiveX control to view results but not for full functionality.

RichTextActiveXControl is an ActiveX RTF solution written in VC++. The RTF2 control is a complete editing/printing solution for Access 97 or higher. Autosizing of the RTF2 control is supported for A2K or higher.

A2KRichTextControl is a non ActiveX RTF solution for Access 2K or higher. It creates an RTF control from the Common Controls DLL. This current Beta version only works with Forms. A solution for Reports is in development and should be ready shortly.

A2KCallbackBrowse & A97CallBackBrowse are functions to allow you to specify the opening folder to be displayed when calling the Browser Folder Dialog window.

A2KSHTML is an HTML Editor built around the MS Web Browser control. A2K or higher ONLY!!!!

RecordNavigationButtons is an MDB containing code to replace the standard Navigation Buttons. The custom bottons exactly emulate the standard navigation bar including the autorepeat property.

Utilities is a database containing small code sample projects from my NG postings.

ChangeMDIBackGround is a database containing a function to allow you to specify a color for the background of the main Access MDI window. Updated to allow you to load Images as well.

AutosizeOLE is a database containing functionality to allow for the auto sizing of bound or unbound OLE Frame controls. A2K or A97.

A2KExportOLEtoJPEG   A2K ONLY! This version saves the entire contents of a table containing OLE Object Images to disk based Jpeg files. User selectable compression rate. 

ListBoxColumnResize now supports an Autosizing method for the ColumnWidths property.

VerticalJustificationA2K is a database containing a function to allow for vertical centering of the contents of a Label or TextBox control. Works with both Forms and Reports. Access 2000 only! 

RotateTextWMF has now been updated to work with Win2K.

A2KConditionalFormatting is a sample MDB demonstrating how to programmatically setup Conditional Formatting to simulate:1) Highlighting of the Current Row for a Form in Continuous or Datasheet View. 2) Highlighting of Alternate Rows for a Form in Continuous or Datasheet View

PictureBox has been updated to match the release of the A2K version. I made a mistake at the last update and placed version 8 instead of version 25 on the Web site for A97 only!

ListBoxColumnResize is a Class that allows the user to resize the ColumnWidths of a ListBox at Runtime.

ContinuousFormsCurrentRow is a class that allows you to programmatically access the contents of a bound control, as the user moves their Mouse, but the control does not have the focus. For Forms in Continuous View.

AlternateColorDetailSection is a class to allow for alternate bands of color for Forms in Continuous View.

ListBoxRowNumbers lets you  add Row Numbers to your ListBox or Combo control.

PictureBoxToGif.Zip is a class that allows the user to save the contents of a Picture Box to a disk based Gif file. This is a standard Gif file with compression so please read the Unisys document below. Full Gif patent info is included in the ZIP file you will be downloading

MouseWheelOnOff is a database containing sample code to enable the user/develop to programmatically turn on or turn off the MouseWheel.

TextHeightWidth is a replacement for the Report object's TextWidth and TextHeight methods. It is multiline aware and can work in both Report and Form views.

ToolTip is a database containing a custom ToolTip class. Enhanced features include Selectable delay times for Toolltip to first appear, Selectable delay times for Tooltip to dissappear, Selectable Text Color, Selectable Background Color, Selectable Margins, Specify Tooltip size, Add a title to the Tooltip in Bold
Selectable Icon for the Tooltip, ToolTips for Lines, Boxes, any rectangular area on your Form.

A2K Version of ReportUtilities complete with A2K PrintLines Class! A2KReportUtilities

LineSpacingA2K is a database containing a function to allow the LineSpacing property to function within a CanGrow/CanShrink environment. Access 2000 only! 

PictureBox is a database containing a class to enhance the standard Image control. This allows the control to resemble the standard Visual Basic PictureBox control. Simple drawing methods are directly supported as is Text output with rotation. A handle to a Device Context is exposed to allow the developer to use the full range of Graphic API's.

TabColors is an MDB containing a class to enhance the standard Access TAB control in order to allow for Tabs of any color and Rotated Text.

FormatbyCriteriaSubClass is a database containing functions to allow Criteria based formatting a Form in Continuous Form's View. Unlimited colors and criteria. 

FieldList is a database containing the FieldList control Access uses in its Table Analyzer and Performance Analyzer Wizards. This control is created directly from the ACCWIZ.DLL so no ActiveX registration problems are incurred. I have created a VB like ListBox with 1) CheckBoxes for each row. 2) True Drag and Drop. 3) Conditional Formatting for each Row. 4) AddItem method

LoadSaveJpeg contains a database demonstrating how to use the Intel Jpeg library with Access. Jpeg files are stored in their original compressed state within a Binary OLE avoiding the Ole object "bloat" issue. The contents of the Image control, containing any supported source Image format, can be saved to disk as a Jpeg file.

SetColorBitmap is a database containing a Report that demonstrates how to change the colors of a Bitmap conditionally. 

FormDimensions New Jan. 28, 2001 is a database containing a Form that demonstrates the relationships of the Form and Section Height and Width properties.

ListBoxEnhanced is a working version of an Enhanced ListBox control. This is an early BETA version with minimal functionality. It merely Paints each row of the ListBox with a separate color. Contains a class that adds new Methods and Properties to a standard Listbox control.

SelectAlpha is a database containing a function demonstrating how to use a Label control filled with the Letters of the alphabet to implement a single character filter for your Form.

AnimatedGif Ver 3.0 BETA contains source code for a VB Animated Gif Player. THis version supports Local Color Tables and enhanced Transparency support. No external ActiveX or 3'rd party DLL's required. Jan 23, 2001 New VB6 Source.

WindowToBitmap is a database containing a class to allow you to capture and save the entire contents of the Relationships window to a disk based Bitmap file. This is roughly a 4000 x 5000 pixel window. The Bitmap is saved as a 16 color BMP in order to reduce file size.

RichText is a database containing a class that allows for the display of RTF text within a standard Access Image control. No RTF ActiveX control is required.

AutoColumnWidth is a Database containing functions to enable auto sizing of Columns in Form Datasheet view by clicking on the Column Header. Access offers this function but only for the rows of the Datasheet that are currently in view. AutoColumnWidth checks every row of the Datasheet to calculate the final width required to completely display the contents in every row.

MonthCalendar New Version 3 A database containing a Class that wraps the Microsoft Common Control Month Calendar in an easy to use interface. This is a completely API generated Month Calendar derived directly from the Common Control DLL. What this means is that there are no distribution or versioning issues as there are if you use the ActiveX DatePicker control.

ReportUtilities New OPEN Version!  A suite of utilities to enhance the Report generating ability of Access. Includes functionality export a Report to Microsoft Word as an exact duplicate of the original Report, including all formatting and graphical elements. Also includes ability to print multiple pages per single output page.

PrintLinesClass - Create Vertical lines, Borders and boxes with the addition of a simple to use Class to your project. 

AutoUpDown is a database containing functionality to allow the user to use the "+" or "-" minus keys to increment/decrement the values in a control. Automatically recognizes Numeric, Date and Time formats. Also allows the user to enter/edit a value in a control and continue incrementing/decrementing without first having to save or exit the control.

CommandBars is a database containing functions to allow you to view all of the MS Office CommandBar objects and CommandBarControl objects on your system.

AnimateForm is a database containing a Class that has functionality to animate a Form during opening and closing. Demonstrates use of WithEvents to sink several events on a Form.

AutoSizeFont is a database containing a function to automatically resize a Control's Font to fit the current record's contents. Works in the Form's Current and/or Change events.

New Version 2.0 LimitTextInput is a database containing a functions to limit the input into a TextBox control. Will allow data input that will fit within the current displayable area of the control only.

NEW  CanGrow Ver 1.0 is a database containing functions to simulate CanGrow/CanShrink for Forms in Form View. 

ImageControlToClipBoard is a database containing a function that allows you to copy the contents of a standard Image Control to the ClipBoard.

LoadJpegGif is a database containing a function to allow for the Display of Jpeg and Gif files on systems that do not have the Office Graphic Filters installed. Ver 3.2

AnimatedGif Ver 2.5 is a database containing functions to allow for the display of Animated Gif files in a standard Access Image control. No external ActiveX or 3'rd party DLL's required. May 20, 2000 New VB6 Source.

Transparent is a database containing functions to allow for the conversion of Bitmap, Gif, Jpeg, Enhanced Metafile and Metafile to an Enhanced Metafile format supporting Transparent backgrounds.

SaveOLEtoBitmap is a database containing functions to allow you to save the contents of an OLE Field to a disk based Bitmap file.

SetGetScrollBars is a database containing functions to allow a user to programmatically set the position of a Form's Scrollbar in Continuous Forms or Datasheet view. 

Lady is a database containing functions to allow the developer to mix Bold and Plain formatting within a single Control. Demonstrates how to use the Print method of the Report object..

ControlReports is a database containing functions to allow the developer programmatic control of the Report Print Preview Window. Specifically you can access the ZOOM and Current Page Number Controls.

PrintLines is a database containing functions to show you how to Draw Lines, Grids and tips to interact with the Report Object. New Version 4.0

LeaderDots Ver 2.0 is a database containing functions to allow a user to fill in the space between 2 controls with leading dots. ie. Pop.....$.99

ChooseFontColorDialog is a database containing functions showing how to call the API Font and Color Dialogs. 

NEW - Jan. 27/2000  EnumerateFonts includes a function to enumerate the Fonts on your system and a callback function to fill a ListBox from a source array.

CommandButton is a database containing functions to allow a user defined BackColor and Rotated Text for Command Buttons. 

NEW Ver 3.0 JustiDirect - Fully Justify Text for Memo control's in Reports.

NEW Ver 2.0 Justification - Right or Center Alignment Functions for data in your List or Combo Controls.

NEW   FormatbyCriteriaVer2.zip is a database containing functions to allow Criteria based formatting a Form in Continuous Form's View. 

RotateTextWMF - Updated VBA Rotate Text program. Now use at Runtime!

PaintProgram - The most simple of all Paint Programs! Native VBA no API's.

ImageClass - Wrapper for Image Control allows for drawing at Runtime!

AutoSizeTextBox - Uses On Current event to resize TextBox to fit the data

ZoomInOut - Add Zoom In/out to your Image control & More! 

Baseline - Print Fonts of different sizes on the same BaseLine.

MakeFitSingle - Forces the single line contents of TextBox to fit in a fixed size control.

MemViewer - Hex Display of your Ram

 

What's Next!

Click Here to jump to the What's Next page! 

 

 
 

May 23, 2004 Product Update
 
 
Rich Text ActiveX control. Version 1.8

Click Here!

 

Mar 15, 2005 Product Update
 
MouseHook  Replaces the MouseWheel DLL subclassing solution. Turns On/Off the MouseWheel with one line of code. No DLL registration required. Now supports Logitech mice!

Click Here! 

 

 

 
Home ] 
Stephen Lebans Copyright 2009

Last Modified : 09/11/09 12:03 AM