|
vb123.com |
|
|
Home Contact Us Order our Software
RSS &
Newsletter
Get Good Help
Is Your Database
Corrupt ?
DryToast Garry's Blog Like FMS Products?
About The Editor
Garry Robinson
writes for a number of popular computer magazines, is now a book author
and has worked on 100+ Access databases. He is based in Sydney,
Australia or try our new site built with
SharePoint Designer |
The
The Toolbox
Graf-fx ... Callable Microsoft Access Functions, Procedures and Subroutines
Graf-FX is a
shareware application written entirely in all current versions of Microsoft Access. This
document summaries the library that can be used with the Graf-FX data mining product.
| procedure | Description |
|---|---|
| FirstWord_FX | This function returns the first word in a text string |
| LastWord_FX | This function returns the last word in a text string |
| AMPM_FX | This function returns either AM or PM on time data |
| CalMM_FX | Returns the calendar month number that relates to this date |
| CalQ_FX | Returns the calendar quarter number that relates to this date |
| CalWW_FX | Returns the calendar quarter number that relates to this date |
| CalYY_FX | Returns 2 digit calendar year number that relates to this date |
| CalYYMM_FX | Returns 5 char calendar year-month text for any date |
| CalYYQ_FX | Returns 3 char calendar year-quarter text for any date |
| CalYYWW_FX | Returns 5 char calendar year-week text for any date |
| CalYYYY_FX | Returns 4 char calendar year text for any date |
| CalYYYYMM_FX | Returns 7 char calendar year-month text for any date |
| CalYYYYQ_FX | Returns 6 char calendar year-quarter text for any date |
| CalYYYYWW_FX | Returns 7 char calendar year-week text for any date |
| Days_FX | Returns the day number in the week for any date |
| FinMM_FX | Returns the financial month number that relates to this date |
| FinQ_FX | Returns the finaancial quarter number that relates to this date |
| FinYY_FX | Returns 5 character financial year text (96/97) for this date |
| FinYYMM_FX | Returns 8 char financial year-month text for any date |
| FinYYQ_FX | Returns 7 char financial year-quarter text for any date |
| FinYYYY_FX | Returns 9 character financial year text (1996/1997) for dates |
| FinYYYYMM_FX | Returns 12 char financial year-month text for any date |
| FinYYYYQ_FX | Returns 11 char financial year-month text for any date |
| Hr24_FX | Returns 2 char 24 hourly time any date data between 01 and 24 |
| Cumu1_FX | Adds a number to the last number that was passed to this function |
| Cumu2_FX | Adds a number to the last number that was passed to this function |
| Cumu3_FX | Adds a number to the last number that was passed to this function |
| Cumu4_FX | Adds a number to the last number that was passed to this function |
| Cumu5_FX | Adds a number to the last number that was passed to this function |
| Cumu6_FX | Adds a number to the last number that was passed to this function |
| Cumu7_FX | Adds a number to the last number that was passed to this function |
| Cumu8_FX | Adds a number to the last number that was passed to this function |
| Histo_FX | Classifies numbers into ranges eg Class of 10 would turn 58 into 50 |
| ResetGlobs_FX | Must be called before using the cummulative functions in queries |
| EncloseField_FX | Enclose date with "#" and text with "'" and numbers AsIs |
| whatFieldType_FX | Find field type in comma delim text list |
| closeStak_FX | Close all the Open Graf forms ( denoted by "GT=" in Tag Property Of Form) |
| openDeadGraf_FX | Opens a graf form without requering the data |
| openLiveGraf_FX | Opens a graf form and requeries the data |
| closeStak_FX | stack the grafs from back to front |
| clearField_FX | Clears the current (Active) field |
| zoom_FX | Opens the zoom box on the current field/control |
| database_FX | Opens the database container |
| ActiveReturn_FX | Returns a text string to the active control |
| FlashBuild_FX | Fires up the appropriate function builder |
| removeBlanks_FX | Removes any blank characters from a text string |
| qryColWid_FX | changes the width of a query column to width of twips (1440 to an inch) |
| qryColWidMulti_FX | changes the width of a number of query columns to width of twips |
| isFormOpen_FX | returns true or false if a form is open or not |
| delSqB_FX | Removes any remove any square brackets from a text string |
| fixQryDec_FX | fixes the number of decimal places for a field in a query |
| getFieldType_FX | returns Date or Number or String for Access column type number |
| QueryProperty_FX | will return a specific query property like the filter string |
| quickAdvice_FX | will display a text string in the quick advice form |
| repChr_FX | Replace a one character string with another .. turn "GR-FX" into "GR_FX" |
| replaceQuery | Replace a query (if it exists) with a new one defined by SQL |
| sysFieldnames_FX | Returns text strings of field names for combo boxes or new queries |
| sysTabnames_FX | Return a string of table and query name ready for combo boxes |
| tableProperty_FX | will return a specific query property like the filter string |
| qryFixReal_FX | will set all numeric fields to a fixed format with set decimal places |
| grafToolBar_FX | Brings the graf-fx toolbar to the front |
| launchPadHelp_FX | Brings the launchpad help screen to the fore |
| stakGraphs_FX | Brings the launchpad help screen to the fore |
| closeGrafs_FX | Close all the currently open grafs |