A new Beta v1.3 of Ezy SQLis currently being tested, and will be released shortly. New features include the Unformatter Wizard, which parses a formatted SQL string variable from the clipboard or a module selection into SQL text.
I am indebted to my two Ezy SQL collaboraters, Mark Plumption (customdata.co.nz) and Jacques Soudan (troisj.com), for their invaluable input and testing.
Mark coded the SQL Parser Class in Ezy SQL that creates a formatted SQL string from SQL text.
Jacques has launched a new Access add-in, 3J-The Procedure Creator, the best such tool I have seen, and which also incoporates sophisticated error-handling options. Give it a try.
FreeAccess Access Control Center
FreeAccess Access Control Center Beta v2.5 will be available soon. To my suprise, there are still many legacy Access2/95 databases out there that still require maintenance. In response to developer demand, the functionality for Access2/95/97 has been customised in Beta v2.5 to deal with such issues as .ini files and short filenames. The Beta v2.5 should be out before the end of the month.
Paste Controls Where You Want! To paste a control near where you want to place it and not in the top left-hand corner of a section, before pasting, select the nearest existing control, and then paste. The new control will be pasted immediately below the selected control.
Get more tips, samples, articles and code from the
Arithmetic and logical operators are evaluated in the following order of precedence:
Arithmetic
Comparison
Logical
Exponentiation (^)
Equality (=)
Not
Negation(–)
Inequality (<>)
And
Multiplication and division (*, /)
Less than (<)
Or
Integer division (\)
Greater than (>)
Xor
Modulus arithmetic (Mod)
Less than or equal to (<=)
Eqv
Addition and subtraction (+, –)
Greater than or equal to (>=)
Imp
String concatenation (&)
Like
Is
Custom Text and Memo formats
Create custom text and memo formats by using the following symbols as the Format property of fields or controls:
@ Text character (either a character or a space) is required & Text character is not required < Force all characters to lowercase >Force all characters to uppercase
Other Custom formats
You can use the following symbols in custom formats for any datatype:
Symbol Meaning
(space) Display spaces as literal characters.
"ABC" Display anything inside quotation marks as literal characters.
! Force left alignment instead of right alignment.
* Fill available space with the next character.
\ Display the next character as a literal character. You can also display literal characters by placing quotation marks around them.
[color] Display the formatted data in the color specified between the brackets. Available colors: Black, Blue, Green, Cyan, Red, Magenta, Yellow, White.
NB: When you have defined an input mask and set the Format property for the same datatype, the Format property takes precedence when data is displayed and the input mask is ignored.
Input Mask Characters
You can define an input mask by using the following characters:
Character Description
0 Digit (0 to 9, entry required, plus [+] and minus [–] signs not allowed)
9 Digit or space (entry not required, plus and minus signs not allowed)
# Digit or space (entry not required; spaces are displayed as blanks while in Edit mode, but blanks are removed when data is saved; plus and minus signs allowed)
L Letter (A to Z, entry required)
? Letter (A to Z, entry optional)
A Letter or digit (entry required)
a Letter or digit (entry optional)
& Any character or a space (entry required)
C Any character or a space (entry optional)
. , : ; - / Decimal placeholder and thousand, date, and time separators. (The actual character used depends on the settings in the Regional Settings Properties dialog box in Windows Control Panel)
< Causes all characters to be converted to lowercase
> Causes all characters to be converted to uppercase
! Causes the input mask to display from right to left, rather than from left to right. Characters typed into the mask always fill it from left to right. You can include the exclamation point anywhere in the input mask.
\ Causes the character that follows to be displayed as a literal character (for example, \A is displayed as just A)
Search for "InputMask Property" in Access Help for more information.
Save the Trees: Use Multi-Column Reports
To create a multi-column report:
In Report Design View, select <File>, <Page Setup...> from the Menubar
Select the Columns tab in the Page Setup dialog
Enter the number of columns
Optionally, set the row and column spacing properties
CLCL is a compact tool (only 100 KB download) that monitors your clipboard and automatically saves all the data transferred through it. It supports all clipboard formats.
IconXP is a neat litle (120kb download) icon editor, and an essential tool for tweaking icons so that they are transparent in Windows XP.
The following code finds which currently MS supported versions of Access (ie. 97/2000/2002), if any, are installled using the Word.Application object. The code can be used in any Office application or a VB executable.
Public Function OfficeDir(OffVer As String) As String On Error GoTo ErrorTrap Dim objWord As Object Set objWord = CreateObject("Word.Application") Select Case OffVer Case "acc97" OfficeDir = objWord.System.PrivateProfileString("", _ "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\8.0", _ "BinDirPath") & "\msaccess.exe" 'Debug.Print OfficeDir Case "acc2k" OfficeDir = objWord.System.PrivateProfileString("", _ "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\9.0\Access\InstallRoot", _ "Path") & "msaccess.exe" Debug.Print OfficeDir Case "accxp" OfficeDir = objWord.System.PrivateProfileString("", _ "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\10.0\Access\InstallRoot", _ "Path") & "msaccess.exe" Debug.Print OfficeDir Case Else End Select objWord.quit Set objWord = Nothing Exit Function ErrorTrap: objWord.Close Set objWord = Nothing MsgBox "Error " & Err & ". " & Err.Description & ".", vbCritical Exit Function End Function
XML Explorer Add-In Explore XML documents with this Access Add-In. As XML documents are structured as trees of data, with this tool you can dig down into XML data using a Windows Explorer like interface.
Sticky Toolbar - an Access form-based Toolbar that moves with a form.
This newsletter may contain links to sites or files on the Internet which are owned and operated by third parties. AAD CONSULTING is not responsible for the content of or files from any such third-party site.
Any files are provided "as is", without warranty of any kind. AAD CONSULTING does not assume any liability for use or the consequences of use.
To subscribe or unsubscribe from this mailing list, select a choice from combo-box below, enter your email address and click OK:
aadconsulting.com_ 
Office 2003 News