Browse by Tags

All Tags » Access Tips Website Update (RSS)
Mon, Sep 28 2009 12:06

Website Updates - Microsoft Access Email FAQ - CDO aka CDONTS

Added the following to the Microsoft Access Email FAQ - CDO aka CDONTS web page. Collaboration Data Objects, version 1.2.1 Beginning in Exchange Server 2007 and Outlook 2007, CDO 1.2.1 will no longer be provided as a part of the install of the product...
Posted by Tony | 4 comment(s)
Filed under:
Mon, Apr 6 2009 19:31

Ensuring uniform control width on forms and reports

Jim, a good friend and client complained, err commented, that the unit number was too small on one key form in the Granite Fleet Manager . He had increased the number of characters in that field on the table from six to eight. I vaguely recall him mentioning...
Posted by Tony | 1 comment(s)
Filed under: , ,
Mon, Jun 30 2008 17:22

Relinking tables

I was asked the following question "I want a simple approach to relinking all linked tables--yes, it would be nice to relink to more than one back-end--in an application IF they are out of date. Best place to put the code, maybe in the splash screen...
Posted by Tony | with no comments
Filed under:
Tue, Jun 24 2008 20:30

Updated - Microsoft Access Email FAQ - DOS Mailers

I've updated the Microsoft Access Email FAQ - DOS Mailers page. Yes, no one uses DOS any more. <smile>
Posted by Tony | 1 comment(s)
Filed under:
Sun, Dec 2 2007 13:25

Updated the Late Binding page

I've updated the Late Binding in Microsoft Access page on my web site to include conditional compiler constants and directives. These make it much easier to move between early binding for debugging and VBA Intellisense to late binding which eliminates...
Posted by Tony | 1 comment(s)
Filed under:
Sun, Nov 18 2007 15:29

Using data from the previous year

A newsgroup question prompted me to pontificate for a bit. I then decided to create a page on the topic. Using data from the previous year
Posted by Tony | with no comments
Filed under:
Tue, Sep 18 2007 20:23

Using bar codes within an application

I've added Henry Habermacher's excellent links on UPC bar codes to the Using bar codes within an application page. I also removed some dead links.
Posted by Tony | 1 comment(s)
Filed under:
Mon, Sep 10 2007 18:40

Microsoft jet database engine could not find object 'xyz.dbf'...

The following was added to the Some Microsoft Access MDB Corruption Symptoms page 4b) 3011 - Microsoft jet database engine could not find object 'xyz.dbf'... Notice the dbf file extension. A dbf file name needs to be in 8.3 DOS name format. It...
Posted by Tony | 16 comment(s)
Filed under:
Thu, Sep 6 2007 22:08

Why do I sometimes need to set the Subdatasheet property to [None]?

I've noticed that occasionally, and for no apparent reason, Access will sometimes set a few tables SubDatasheet property to [Auto] after I had updated the table definitions. I just shrugged and started running the code as mentioned at BUG: Slower...
Posted by Tony | with no comments
Filed under: ,
Thu, Sep 6 2007 17:52

Setting Startup Options Programmatically in Microsoft Access

I saw a newsgroup request on this and I realized I had all the code in one of my MDBs somewhere. Likely took my longer to find it than it did to create the web page. So I just created Setting Startup Options Programmatically in Microsoft Access page.
Posted by Tony | with no comments
Filed under:
Wed, Sep 5 2007 21:08

Issues ... Access ...Windows Vista (or Windows Server 2008)

See Issues that you may encounter when you open or are using a Microsoft Office Access database on a computer that is running Windows Vista - 935370. Note that this is an SMB 2.0 issue and thus Windows Server 2008 could also have this problem. Looks like...
Posted by Tony | 3 comment(s)
Filed under:
Sun, Sep 2 2007 11:41

Added Microsoft Office Access 2007 Developer Edition FAQ page

I've created a new Microsoft Office Access 2007 Developer Edition FAQ page.
Posted by Tony | 3 comment(s)
Filed under:
Fri, Aug 31 2007 21:27

Playing music severely degrades network transfer performance in Vista

Playing music severely degrades network transfer performance in Vista Now isn't that one interesting. Thanks to David for the posting Vista network problem . Access Performance FAQ page has been updated.
Posted by Tony | with no comments
Filed under:
Tue, Aug 28 2007 21:39

Updated Tony's Table and Field Naming Conventions

Upon some mild prodding and questioning by a fellow MVP I realized I was missing some of the reasons why I do things. So I've did some editing and added text to Tony's Table and Field Naming Conventions
Posted by Tony | 1 comment(s)
Filed under: ,
Mon, Aug 6 2007 14:20

Updated the Microsoft Access (Office) Developer Edition FAQ page

I've updated the Microsoft Access (Office) Developer Edition FAQ page to include more information on the Access 2007 Developer Edition
Posted by Tony | with no comments
Filed under: ,
Thu, Jul 26 2007 18:13

Windows Vista, ODBC and SQL Server 2005

The following has also been added to the Access Performance FAQ page. For the best connection string for a DSN-less connection to SQL Server 2005, switch providers to the SQL Native Client with the following: "ODBC;Driver={SQL Native Client};Server...
Posted by Tony | with no comments
Filed under:
Thu, Jul 26 2007 17:42

Access 2007 design view performance on Windows Vista vs Windows XP

A very interesting thread brought out some interesting differences in the networking stack in Windows Vista. The following paragraph was added to the Access Performance FAQ page. "If I disable autotuning on the TCP stack in Windows Vista I no longer...
Posted by Tony | with no comments
Filed under:
Sun, Jul 1 2007 14:50

Added Locking fields on a form page to my website

Thanks to a newsgroup poster I located the generic code I had created for a client, did some screen shots and have created Locking fields on a form . Requires a little knowledge of VBA.
Posted by Tony | with no comments
Filed under:
Sat, Jun 30 2007 12:45

Updated the Convert Access to Visual Basic, Delphi, Java, ASP or ASP.NET page

I've added AccessForms2Web which converts Access pages to PHP & MySQL to my Convert Access to Visual Basic, Delphi, Java, ASP or ASP.NET page as well as cleaning up old links.
Posted by Tony | with no comments
Filed under:
Thu, Jun 28 2007 19:15

Updated the Calendars and Compression DLLs, OCXs, etc pages

I added the following to the Calendars and Microsoft Access page: Duane Hookum, fellow Access MVP, has an awesome and simple calendar in a report. See the Calendar Reports sample section at Hook'D on Access Samples I added the following to the Microsoft...
Posted by Tony | with no comments
Filed under: ,