NEW Ezy Documenter Premium Edition v5.4

The Premium Edition allows user customization of each Ezy Documenter Database Report.

NEW Beta Application Ezy Access Launcher

Automatically opens Access files in the appropriate version. Try it

NEW Database Application Executive Assistant

The Ultimate Executive Diary Management System. Try it

Office 2003 News

Five things You should know about Office 2003

Office System 2003 Accelerator Program

STOP PRESS:
Visual Studio Tools for the Microsoft Office System 2003 Ships
Microsoft has put another nail in the coffin of VBA, by confirming that it will survive only the version after Office 2003. Just in time for my retirement...

Handy Shortcuts In a module, when using IntelliSense, press <Ctrl>+<Shift>+<J> to display/redisplay the relevant arguments/constants. When coding the constants for the MsgBox function, hit the + key to add constants to the buttons argument. More tips, samples, articles & code on the Access Utilities CD New v4.0 XP Icons In WinXP, get XP-style icons from the file, shell32.dll, in the /System32 folder, using a freeware app like Icon Sucker: Find that code FAST! If you are like me, you have sample code all over your hard drive, and when you need a certain snippet, you can't remember where it is :) I have found X1 indispensable in locating "lost code". X1 locates files on your hard disk fast. It works by indexing all files on your HDD, and returning not only files where the file name contains the search string, but also all files containing the string, with a preview pane of the contents of each file highlighting each instance. There is a basic freeware version that suits most users, and a Pro version that supports over 150 file types. Weekday Date Validation This validation rule limits entries to weekdays: DatePart("w",[HireDate],7)>2 The DatePart function returns a number from 1 to 7, corresponding to the days of the week. A Saturday date returns 1, and a Sunday date returns 2. Therefore, checking for a value that's greater than 2 eliminates any entry that equals 1 or 2. Latest Versions of Access:   Office 2000 Office 2000 SR1 Office XP Office XP SP1 Office XP SP2 msccess.exe 9.0.0.2719 9.0.0.3822 10.0.2627.1 10.0.3409.0 10.0.4302.0 Speed up your Access 2000 Forms A tip from Mark Plumpton of www.customdata.co.nz I have a form that took 85 seconds to save. After applying the technique below it reduced the save time to just a couple of seconds. It also reduced my compacted database size from 5mb to 4mb after applying this technique. This is the tip: Load the form, subform, combobox and listbox record sources at run-time. That's it. You will achieve dramatic performance improvement and reduced database size. Here's the technique: Delete the SQL from the RecordSource and RowSource properties of the form, subforms, comboboxes and listboxes. Now in the Form_Load event load the appropriate SQL as follows ... Private Sub Form_Load()     Me.RecordSource = "qryLargeTable"     Me.txtSomeField.RowSource = _         "SELECT SomeField " & _         "FROM qryLargeTable " & _         "GROUP BY SomeField " & _         "ORDER BY SomeField;" End Sub It also pays to clear the record sources in the Unload event as sometime these get saved with the form in Access 2000. Private Sub Form_Unload(Cancel As Integer)     Me.RecordSource = ""     Me.cboFindRecord.RowSource = "" End Sub

http://www.softwaremonster.com/

http://www.planet-source-code.com/vb/

http://www.codeproject.com/

http://www.quepublishing.com/
Search "accesss"

Insider Code

Thanks to Jacques Soudan of www.troisj.com for this compilation of undocumented constants for the SysCmd function:

SysCmd(7) 'Detects the Access VERSION number

For Access 97:

SysCmd 603, PathMdb, PathMde 'convert MDB -> MDE
SysCmd 602, PathMdb, PathMdb 'compact DB
SysCmd 555 'create MSysIMEX... tables
SysCmd(504, 16483) 'save and compile code
SysCmd(504, 16484) 'save code without compiling
SysCmd(501, i) 'list of references, i = 0, 1, ... n
SysCmd(500) 'count of references

For Access 2000+:

SysCmd 603, PathMdb, PathMde 'convert MDB -> MDE
SysCmd 602, PathMdb, PathMdb 'compact DB
'You must use in this case following method, example:
    Dim accApp As Access.Application
    Set accApp = New Access.Application
    accApp.SysCmd 603, PathMdb, PathMde
    accApp.SysCmd 602, PathMdb, PathMdb
    Set accApp = Nothing
SysCmd(605, 0) 'convert DB to previous version
SysCmd(605, "C:\Database97.mdb") 'convert DB to previous version
SysCmd(607,"C:\Project1.adp") 'convert DB to ADP project
SysCmd(608, i) '60 tips about Access programming for i=0, 1, ... 60
SysCmd(710, 68486165) 'set Polish keyboard (if installed)
SysCmd(710, 67699721) 'set US keyboard
SysCmd(710, 68748313) 'set Russian keyboard
SysCmd(710, 67634184) 'set Greek keyboard
SysCmd(710, ...) 'set other country keyboard
SysCmd(710,1) 'set next installed keyboard
SysCmd(710,0) 'set previous installed keyboard
SysCmd(711) 'return put keyboard currently
SysCmd(714) 'returns TRUE, if any form, report, macro or module is in design mode
SysCmd(715) 'returns Build number of MSACCESS.EXE file to check Access version or e.g. which Service Pack is installed.

http://www.experts-exchange.com/Databases/MS_Access/

http://members.rogers.com/douglas.j.steele/AccessIndex.html

• Access Copy Protector An Access application that copy protects an .mde, so that it will run only on the machine that it is installed on. 

• Sticky Toolbar - an Access form-based Toolbar that moves with a form.

 

No new articles this month.

 

Download a .Zip File of All Issues 1-24
Incudes a Searchable Compendium of Issues 1-12  

Visit our Link Partner: Superior Software for Windows Access, SQLServer and .NET Downloads www.ssw.com.au

Top

SUBSCRIBE:
To subscribe or unsubscribe from this mailing list, select a choice from combo-box below, enter your e-mail address and click OK:

Have questions or comments?
Send them to me.

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.

Access is a trademark of Microsoft Corporation.

©2001-2003
Anthony D'Ambra.
All rights reserved.

Top