Thanks to a question in the newsgroups I did some research and updated the Microsoft Access Compatible Compression Solutions page with the below File Compression using the OS and NTFS file system section (And I renamed the web site page from Microsoft Access Compatible Compression DLLs, OCXs, etc.) Given...
Paul asked "I sometimes get frustrated that Access does not always update references between versions...for example a calendar control or Outlook reference" 1) Use a calendar form or the API calls which is what the calendar control uses behind the scenes. See the Calendar Tips page at my web...
Tired of creating forms in Access 2003 with this option? Allen Browne suggests creating default forms, reports and databases. I did get quite irritated about having to switch the form to design view, click on the small black box in the upper left hand corner to get to the form properties and then change...
A number of fellow Access MVPs disagreed with the UI of a multi row tab control. John Mishefske pointed out a excellent page at the Interface Hall of Shame - Tabbed Dialogs . Of course *MY* multi row tab would not look anywhere near as ugly as some of those examples. Yeah, right. I've been thinking...
This is exceedingly minor. However the following example brought two different results. ?Dir("Q:\1 access\Fleet Mgmt\*.key") PD.keyzzzz ?Dir("Q:\1 access\Fleet Mgmt\pd.key") <nothing> Background. For my "shrink wrap" application, the Fleet Management System , I email...
I've always been irritated at how you can't get at the user friendly reference description as displayed in the Access VBA References screen. When you look at the properties of the reference object you can't see the user friendly name you see on the above screen. Sub DebugPrintReferences(...
Say you're creating fields on a table using VBA and the field collections. You're trying to figure out what the possible values are for the field types. And you've managed to figure out something like the following code. Dim dbsupdate As Database, wrkDefault As Workspace Dim tdfUpdate As...
Someone posted a link to a tutorial on using Java, Netbeans and Microsoft Access - Persistence, Binding, Annotations: an example with NetBeans6.0 and Access. Undoubtedly 99.9% of my loyal readers won't care but I thought this was interesting enough. And to be perfectly honest I don't have a clue...
Executing an append query which has a value in the autonumber field can set the autonumber seed to a unwanted high value. Or maybe you had some code running amok, or amuck if you prefer that spelling, which accidentally inserted a lot of records. In Access 2000 and newer, or rather Jet 4.0, as well as...
One reason I much prefer using Access 2003 compared to older versions of Access is the little warning widgets (for lack of a better term) that come up while you are working on forms or reports. These help me, a highly experienced Access developer, work more efficiently. And I'm sure they help many...