Reference
- AdminRecordset (object) Tabliz's root Object
- Properties
- ActionPerformed
As Integer
- Description: It is possible to check the action performed by tabliz. So you can write code for specific actions such as send mails or write a log file
- Sample
- Calendar
As calCalendar
- Description: The Calendar Object used for Date fields
- ConnectionString
As String
- Description: Any valid ADO connection string. Use this property if you are using TaBliz with datasources different from Access, such as SQL Server or Oracle
- Sample
- CriptoPrefix
As String
- Description: Used in the request to avoid the risk of field names equal to internal parameters
- DatabasePath
As String
- Description: Absolute Path of an Access mdb File
- Sample
- DebugMode
As Boolean
- Description: Displays a better formatted HTML source code and additional informations.
- Remarks: Leave to false in production environment
- EditForm
As HTMLEditForm
- Description: The Edit form object
- EditingList
As HTMLEditingList
- Description: The Editing List object
- ErrNotASupportedField
As String
- Description: The Error Message that appears once insted of displayong the data of not supported field
- FileFields
As Collection
- Description: Collection of File Fields
- Remarks: TaBliz will generate the File Manager button in the editform for this fields.
- Sample
- FileMan
As filFileMan
- Description: The File Manager Object
- Sample
- MaxSelectLenght
As Integer
- Description: The maximum lenght a HTML <SELECT> can reach in forms
- Recordset
As String
- Description: Sets or retrive the current recordset
- Remarks: Could be a Query or a Table
- Sample
- RequiredFields
As Collection
- Description: Collection of Required Fields
- Remarks: TaBliz automatically detects required fields. If you want to add in asp code other required fields simply add them to this collection. TaBliz will generate for you javascripts for required fields.
- ResultPage
As HTMLResultPage
- Description: The ResultPage object
- SearchForm
As HTMSearchForm
- Description: The Search Form object
- Methods
- AddNew ()
As Nothing
- Description: Generates an Editing Form ready for data input.
- Remarks: Database and Recordset properties shold be set before to call this method
- Sample
- AddRelation (FieldName as String, RelatedField as String, RelatedTable as String)
As Nothing
- Description: Force a relation in the whole TaBliz interface.
- Remarks: The relation is added to the SearchForm.RelatedRecords, to the EditingList.RelatedRecords and to the EditingList.RelatedRecords collections.
- AliasField (Alias As String, FieldName As String)
As Nothing
- Description: Renames a field for the whole TaBliz interface.
- Remarks: The Alias is added to the EditForm.FieldAliases, to the EditingList.FieldAliases , to the EditingList.RelatedRecords.FieldAliases and to the SearchForm.FieldAliases collections.
- DeleteItem (sWhereCriterion As String)
As Nothing
- Description: Generates an EditForm with the record specified in the sWhereCriterion parameter ready to be deleted.
- Remarks: The sWhereCriterion parameter must identify a single record otherwise an error will occur.
- Sample
- DoBaseTemplate ([FilePath], [Overwrite As Boolean])
As String
- Description: Generates a template that you can use as a base to personalize.
- Remarks: The template could be generated as a return value or as a file written in the path passed as parameter. Optionally you can specify if the file shold be overwritten
- Sample
- DoEditingList ([sWhereCriterion As String])
As Nothing
- Description: Generates an editing list based on the current Database and recordset.
- Remarks: You can filter records using the optional sWhereCriterion parameter.
- Sample
- DoReport ()
As Nothing
- Description: Generates a paginated report based on a template
- Sample
- DoSearchForm ()
As Nothing
- Description: builds a Search Form based on the current recordset
- Remarks: Use the filter property of the SearchForm Object to limit results to certain records
- Sample
- EditItem (sWhereCriterion As String)
As Nothing
- Description: Generates an EditForm with the record specified in the sWhereCriterion parameter ready to be edited.
- Remarks: The sWhereCriterion parameter must identify a single record otherwise an error will occur.
- Sample
- HideField (FieldName As String)
As Nothing
- Description: The field Is Hidden In the whole TaBliz's Interface
- Remarks: You call this method with one field name as parameter and the field is added to the editform.HiddenFields, to the EditingList.HiddenFields , to the EditingList.RelatedRecords.HiddenFields and to the SearchForm.HiddenFields collections.
- Sample
- RegisterProduct (UserName As String, Password As String)
As Nothing
- Description: Register TaBliz
- Remarks: Use this function to register your copy of TaBliz once you have your registration's username and password
- ShowRegitrationInfo ()
As Nothing
- Description: Show informations about the registration status of TaBliz
- calCalendar (object) The Calendar Object
- Properties
- FromYear
As Integer
- Description: The starting year of the calendar
- m1
As String
- Description: Label for month #1
- m10
As String
- Description: Label for month #10
- m11
As String
- Description: Label for month #11
- m12
As String
- Description: Label for month #12
- m2
As String
- Description: Label for month #2
- m3
As String
- Description: Label for month #3
- m4
As String
- Description: Label for month #4
- m5
As String
- Description: Label for month #5
- m6
As String
- Description: Label for month #6
- m7
As String
- Description: Label for month #7
- m8
As String
- Description: Label for month #8
- m9
As String
- Description: Label for month #9
- ShowHours
As Boolean
- Description: Should calendar use hours?
- ShowMinutes
As Boolean
- Description: Should calendar use minutes?
- ShowSeconds
As Boolean
- Description: Should calendar use seconds?
- ToYear
As Integer
- Description: The last year of the calendar
- filFileMan (object) The File Manager Object
- Properties
- AllowDelete
As Boolean
- Description: Decide if it is possible ore not to delete files from the file manager
- AllowEditingOfFilesInUse
As Boolean
- Description: Enable or disable the file in use check
- Remarks: The files in use mechanism checks if the file is in use. Be aware that files used in other fields or in other recorsets are NOT detected
- AllowRename
As Boolean
- Description: decide if it is possible to rename files
- AllowSelect
As Boolean
- Description: decide if it is possible to select files
- Remarks: leave this to true for proper operation
- AllowSendFile
As Boolean
- Description: Decide if it is possible to send new files
- AllowView
As Boolean
- Description: The view selector appears on the file list
- AlphabeticalIndexFoot
As String
- Description: the HTM foot for the index
- AlphabeticalIndexHead
As String
- Description: the HTM heat for the index
- AlphabeticalIndexSeparator
As String
- Description: the html between each single letter
- BackCaption
As String
- Description: Button Caption for Back Button
- CloseCaption
As String
- Description: Button Caption for Close Window Button
- ConfirmDelete
As String
- Description: Button Caption for delete confirmation
- ConfirmRename
As String
- Description: Button Caption for rename confirmation
- ConfirmSendFile
As String
- Description: Button Caption for Send File
- ConsoleFoot
As String
- Description: The HTML footer for the Console frame
- ConsoleHead
As String
- Description: The HTML header for the Console frame
- DeleteCaption
As String
- Description: string in file list inside the href for delete
- DeleteSuccess
As String
- Description: String For the User if delet file OK
- DoAlphabeticalIndex
As Boolean
- Description: enable or disable the alphabetical index in the console
- FileCaption
As String
- Description: String in console
- FileExistError
As String
- Description: String if file exist
- FileInUseError
As String
- Description: The errora that appears if tryng to edit a file detected as in use
- Remarks: see FileInUseWarning
- FileInUseWarning
As String
- Description: The waring that appears if tryng to edit a file detected as in use
- Remarks: this warning appears only if AllowEditingOfFilesInUse is enablead otherwise the FileInUseError appears
- ImagesExtensions
As Collection
- Remarks: By default Extesion parsed as Images are :"GIF" "JPG" "JPEG" "BMP" "PNG" if you want to add other extensions use the following statement ImagesExtensions.Add "EXT"
- InvalidExtensionError
As Collection
- Description: The error that apperas if an invalid extension is detected
- InvalidExtensions
As Collection
- Remarks: By default all extension are allowed except "EXE" "CGI" "BAT" "PIF". If you want to disallow other extentions use InvalidExtensions.Add "EXT"
- ItemFoot
As String
- Description: The HTML after each single File Item in the File List
- ItemHead
As String
- Description: The HTML before each single File Item in the File List
- ListFoot
As String
- Description: The HTML footer for the File List
- ListHead
As String
- Description: The HTML header for the File List
- MaxFileBytes
As String
- Description: Maximum file size in bytes
- Remarks: leave to 0 for no limits
- MaxFileBytesError
As String
- Description: Error if file is too big
- Remarks: see also MaxFileBytes
- NewNameCaption
As String
- Description: String For The user before the name inputbox while renaming
- Remarks: in TaBliz 6.0 there is a misspell with this property and it is named NewNameCapition... keep an eye on this if you migrate from 6.0
- NoFileSentError
As String
- Description: Error string if no file was sent by the user
- OverWriteFiles
As Boolean
- Description: Decide if it is possible to OverWrite Files
- Path
As String
- Syntax: .Path = "/FILES"
- Description: set the path of the web ehere you manage files
- Remarks: It is important that you set full control for the IUSR_ for the phisical folder
- Sample
- RenameCaption
As String
- Description: string in file list inside the href for rename
- RenameSuccess
As String
- Description: String For The user if file rename is OK
- Remarks: in TaBliz 6.0 there is a misspell with this property and it is named NewNameCapition... keep an eye on this if you migrate from 6.0
- SelectCaption
As String
- Description: string in file list inside the href for select
- ShowThumbnails
As Boolean
- Description: Use or not the image preview for known Image Files
- SuccessUpload
As String
- Description: String for the visitor if upload OK
- ValidExtensions
As Collection
- Remarks: if you want to allow only certain extensions and disallow all others
use: ValidExtensions.Add "EXT"
- ViewCaption
As String
- Description: string in file list inside the href for view
- HTMLEditForm (object)
- Properties
- AllowDefaultValues
As Boolean
- Description: You can disable the use of Access's default values by setting this property to false.
- Remarks: Remember that if you leave this property to true and some of the default values is setted in the recordset you manage, you will use one autonumber each time you call the AdminRecordset.AddNew method
- ButtonAddCaption
As String
- ButtonDeleteCaption
As String
- ButtonEditCaption
As String
- FieldAliases
As Collection
- Syntax: Filedaliases.Add "Alias", "FieldName"
- Description: Add an Item to this collection if you want a different Name for a given field
- FixedValues
As Collection
- Syntax: FixedValues.Add "FixValue","FieldName"
- Description: Add an item to this collection if you want a Fix value for a given field
- HiddenFields
As Collection
- Description: Add a field name to this collection if you don't want to see it in the Edit Form
- Sample
- HideAutonumbers
As Boolean
- Remarks: If you set this to true you can hide Field of Type Autonumber in the Edit Form.
- Sample
- JavaScripts
As HTMLJavaScripts
- RelatedRecords
As HTMLRelatedRecords
- RequiredFieldMarker
As String
- Description: String to be displayed ate the right on the filed name if the field name is required
- Table
As HTMLTable
- TestareaRows
As Integer
- Description: Sets the numbers of rows as textarea has
- TextareaCols
As Integer
- Description: Sets the numbers of columns a textarea has
- TextFieldsAsTextarea
As Boolean
- Remarks: by setting this to true a textarea is generated for each text field instead of a simple <input>
- TransparentFields
As Collection
- Remarks: A field added to this collection will be visible by the final user but not editable
- UseCalendar
As Boolean
- Description: Decide if use or not calendar for date fields in edit form
- HTMLEditingList (object)
- Properties
- AllowDelete
As Boolean
- AllowEdit
As Boolean
- BetweenEditAndDelete
As String
- BottomText
As String
- ButtonDeleteCaption
As String
- ButtonEditCaption
As String
- EditTitle
As String
- ErrNoCurrentRecord
As String
- FieldAliases
As Collection
- Syntax: Filedaliases.Add "Alias", "FieldName"
- Remarks: Add an Item to this collection if you want a different Name for a given field
- Filter
As String
- Description: Set this propery in order to filer the results in the Editing List.
- HiddenFields
As Collection
- Remarks: Add a field name to this collection if you don't want to see it in the Editing List
- Sample
- OnATotalText
As String
- PageSize
As Integer
- PageText
As String
- RecordText
As String
- RelatedRecords
As HTMLRelatedRecords
- ShowRecordCount
As Boolean
- ShowSQLText
As Boolean
- Table
As HTMLTable
- TopText
As String
- ToText
As String
- HTMLJavaScripts (object)
- Properties
- CheckIsNumeric
As Boolean
- Description: Set this to true to check whether a numerical field was filled with a number.
- Remarks:
- CheckMaxLenght
As Boolean
- Description: Set this to true to check whether fields lenght is OK.
- CheckRequired
As Boolean
- Description: Set this to true to check data for a required field.
- Sample
- IsNumericErrorMessage
As String
- Description: JavaScript alert message that appears if a non numerical value is found for a numerical field.
- MaxLenghtErrorMessage
As String
- Description: JavaScript alert message that appears if a field lenght is greater then the maximum allowed.
- RequiredErrorMessage
As String
- Description: JavaScript alert message that appears if a required field is missed.
- HTMLRelatedRecords (object)
- Properties
- AllowDelete
As Boolean
- Description: If true a delete button appears in the form
- AllowEdit
As Boolean
- Description: If true a Edit button appears in the form
- BetweenEditAndDelete
As String
- Description: Text between the Delete and Edit buttons
- ButtonDeleteCaption
As String
- Description: Caption for the Delete Button
- ButtonEditCaption
As String
- Description: Caption for the Edit Button
- FieldAliases
As Collection
- Syntax: Filedaliases.Add "Alias", "FieldName"
- Description: Add an Item to this collection if you want a different Name for a given field
- Filters
As Collection
- Syntax: relatedrecords.filters.add "FilterExpression", "FieldToFilter"
- Description: Manage filters for the related records
- Remarks: Add items to this collection in order to filter data in the related records.
- HiddenFields
As Collection
- Syntax: HiddenFields.Add "FieldName"
- Description: Add an Item to this collection if you want to hide a field
- Sample
- HideAutonumbers
As Boolean
- Description: Set this to true to hide autonumber fields
- Show
As Boolean
- Description: Set this to true if you want to see related records values.
- Table
As HTMLTable
- Methods
- Add (FieldName As String, RelatedField As String, RelatedTable As String)
As Nothing
- Description: Add a relation.
- Remarks: At the moment it is possible to add only relations that are'nt removed previously.
- Remove (FieldName)
As Nothing
- Description: Remove a relation
- Remarks: At the moment removing a relation means only that if a relation is found on the field it will be ignored. So Remove works only with relations defined in the database or not yet adedd
- HTMLReport (object)
- Properties
- Filter
As String
- Description: Set this propery in order to filer the results in the Report
- Remarks: TBLZ.report.filter = "ID >5" will display only records whose ID is greater the 1
- HtmlEncodeFields
As Boolean
- PageSize
As Long
- ReplaceVbCrLf
As Boolean
- Template
As HTMLTemplate
- WhereClause
As String
- Remarks: You can set this to something like "WHERE FIELD = PARAMETER ORDER BY FIELD " in order to select the records you want to display in the report.
- HTMLResultPage (object)
- Properties
- BottomAddNewText
As String
- BottomModifyText
As String
- DeleteText
As String
- RelatedRecords
As HTMLRelatedRecords
- Description: Related Records in result page
- Table
As HTMLTable
- TopAddNewText
As String
- TopModifyText
As String
- HTMLSearchForm (object)
- Properties
- Action
As Integer
- Remarks: This can be set to tblzShowEditingList (0) or tblzShowReport (1). So search results will be displayed in a report or in the Editing List
- Sample
- CriterionTitle
As String
- FieldAliases
As Collection
- Remarks: Add an Item to this collection if you want a different Name for a given field
- HiddenFields
As Collection
- HideOrderByRow
As Boolean
- HideTopDistinctRow
As Boolean
- RelatedRecords
As HTMLRelatedRecords
- ResetCaption
As String
- SelectText
As String
- SubmitCaption
As String
- Table
As HTMLTable
- HTMLTable (object)
- Properties
- DataTD
As String
- DataTDClose
As String
- DataTitle
As String
- DataTitleTD
As String
- DataTitleTDClose
As String
- EvenTR
As String
- EvenTRClose
As String
- LabelTD
As String
- LabelTDClose
As String
- LabelTitle
As String
- LabelTitleTD
As String
- LabelTitleTDClose
As String
- OddTR
As String
- OddTRClose
As String
- SubmitTD
As String
- SubmitTDClose
As String
- SubmitTR
As String
- SubmitTRClose
As String
- TableTag
As String
- TableTagClose
As String
- TitleTR
As String
- TitleTRClose
As String
- HTMLTemplate (object)
- Properties
- BeginLoopKey
As String
- EndLoopKey
As String
- FirstRecordInPageKey
As String
- LastRecordInPageKey
As String
- PaginationKey
As String
- Path
As String
- RecordCountKey
As String
- TotalRecordsKey
As String
As you can see some of these members are
documented an some not, this is a matter of time. We promise that
we 'll put here something as soon as we have a little time and as
soon as we get a little of money. In the meantime you can use the latest
version of customtabliz.inc as a
reference for the use and the
meaning of all TaBliz's properties and methods.
Graphic Schema
|
