|
vb123.com |
|
|
Home Contact Us Order our Software RSS &
Newsletter
Get Good Help
The
Workbench
Find out who has your database open, start the
correct version of Access, easy compacting and backups, change startup
options, mde compile, shutdown database
Read and
Download Garry's Blog
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 |
Is Your Database Corrupt ?
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 |