FMS Facebook Page
Jump: Search:

Total Visual SourceBook

Total Visual SourceBook CD and Printed Manual

Microsoft Access 2007/2010 Version
is Shipping!

New features in Total Visual SourceBook for Access, Office 2007 and VB6

Supports Access/Office 2010 (32 bit), 2007, 2003, 2002, 2000, and
Visual Basic 6.0!

Also available for:
Access 97/95

View all FMS products for Microsoft AccessAll Our Microsoft Access Products

SourceBook Info:

Why SourceBook?

 

"The code is exactly how I would like to write code and the algorithms used are very efficient and well-documented."

Van T. Dinh, Microsoft MVP

 

 

 

 

 
Royalty free source code library modules for Microsoft Access, VB6, VBA, OfficeRoyalty free source code library modules for Microsoft Access, VB6, VBA, OfficeVBA and VB6 Source Code Library Download the free trial version of Total Visual SourceBook for Microsoft Access, Office, VB6 and VBA
Category: Database : Access/Jet
Description: Microsoft Access Jet databases and their objects (MDB and ACCDB database formats)

Module: modJetTableInfo

Access/Jet table information

Procedure Name

Type

Description

(Declarations) Declarations Declarations and private variables for the modJetTableInfo module
FieldTypeString Procedure Convert a field type ID (number) to a string
GetColumnHistory Procedure In Access 2007 format databases (ACCDBs), the AppendOnly property for Memo fields allows you to store a history of the changes (set AppendOnly = Yes to collect column history). This code returns the ColumnHistory for the specified Memo field.
IndexFieldsToArray Procedure Fills an array with a list of fields in an index
IndexFieldsToString Procedure Populates a string with a delimited list of fields in an index
IsSytemTable Procedure Determines if the table in the specified database is a system table
IsTable Procedure Determines if the table in the specified database exists
IsTableFieldRichText Procedure Determines if the Format property of a memo field is set to Rich Text In Microsoft Office Access 2007, you can store rich, formatted text in a database. You do this by using a memo field and setting the field's TextFormat property to RichText. You can apply formatting to all or part of the contents of the field by editing the field through a bound control in a form, or when the field is displayed in a datasheet. You can also apply formatting to all of a field when viewing a report in Layout View.
IsTableLinked Procedure Determines if the table in a named database is a linked table
IsTableOrQuery Procedure Determines if name is a table or query within the specified database
LinkedTableDatabase Procedure Determines the linked database for a table in a named database
LinkedTableSource Procedure Retrieve a linked table's actual table name from its linked back-end database. Usually the table is the same name, but it may be different.
TableFieldDescription Procedure Returns the description for a field from a table in the specified database The description property does not exist if a description hasn't been assigned.
TableFieldsToArray Procedure Populates an array with a list of fields in a table
TableFieldsToArrays Procedure Populates three arrays with a list of fields, types, and descriptions from a table
TableFieldsToString Procedure Populates a string with a delimited list of fields in a table from an existing database object
TableFieldType Procedure Returns the field type ID for a field from a table in the specified database The description property does not exist if a description hasn't been assigned.
TableIndexesToArray Procedure Fills an array with a list of indexes for a table
TableIndexesToString Procedure Creates a string with a list of indexes for a table
TableType Procedure Retrieve the table's linked type

Overview of Total Visual SourceBook

The source code in Total Visual SourceBook includes modules and classes for Microsoft Access, Visual Basic 6 (VB6), and Visual Basic for Applications (VBA) developers. Easily add this professionally written, tested, and documented royalty-free code into your applications to simplify your application development efforts.

Additional Resources
Feedback

Contact Us  l   Web questions: Webmaster   l   Copyright © FMS, Inc., Vienna, Virginia
Celebrating our 26th Year of Software Excellence