The following items cover topics related to Access Forms and their use.
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.
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.
ChangeMDIBackGround is a database containing a function to allow you to specify a color for the background of the main Access MDI window.
AutosizeOLE is a database containing functionality to allow for the auto sizing of bound or unbound OLE Frame controls. A2K or A97.
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
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.
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
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.
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.
FormDimensions is a database containing a Form that demonstrates the relationships of the Form and Section Height and Width properties.
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.
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.
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.
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.
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.
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.
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.
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.
SetGetSB 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.
CommandButton is a database containing functions to allow a user defined BackColor and Rotated Text for Command Buttons.
FormatbyCriteriaSubClass is a database containing functions to allow Criteria based formatting a Form in Continuous Form's View. Unlimited colors and criteria.
PaintProgram - The most simple of all Paint Programs! Native VBA no API's.
ZoomInOut - Add Zoom In/out to your Image control & More!
AutoSizeTextBox - Uses On Current event to resize TextBox to fit the data
ImageClass - Wrapper for Image Control allows for drawing at Runtime. Simulates a Visual basic PictureBox control.
NEW RotateTextWMF - Updated VBA Rotate Text program. Now use at Design or Runtime!
Limit Characters in a Memo Field - Just like it says :-)
Magnify Design View - Magnify area under cursor in Form or Design View
Select A Row in a Form/SubForm - Just like it says :-)
Raw NewsGroup Postings
When I first started seriously with Access I had a
hell of time
Private Declare Function GetFocus Lib
"user32" () As Long
Option Compare Database