Browse by Tags

All Tags » bug (RSS)
Sun, Sep 13 2009 15:22

FindExecutable API call fails for ACCDB file extensions

The API call "FindExecutable: Find Exe Associated with a Registered Extension" fails on a file with the ACCDB extension.   The API call does work fine with the MDB extension.   Clicking on an ACCDB file in Windows Explorer...
Posted by Tony | with no comments
Filed under: , ,
Fri, May 1 2009 20:33

Navigation Pane Description missing - Access 2007 SP2

"Use MS ACCESS 2007 to manage large volume of accounting data, and have many tables and queries. I enter a description in these tables and queries to help me remember what they all do. MS OFFICE Service Pack 2 was released into my machine last night...
Posted by Tony | 1 comment(s)
Filed under: , ,
Sun, Apr 5 2009 19:54

"Object or class does not support the set of events." error message

I start getting the following message when opening a form after doing some minor changes to it. "The expression On Open you entered as the event property setting produced the following error: Object or class does not support the set of events."...
Posted by Tony | 9 comment(s)
Filed under: , ,
Sat, Jan 24 2009 20:58

"Type Mismatch" bug and line numbers in the Auto FE Updater

I've been getting intermittent email reports of a "Type Mismatch" error message in the Auto FE Updater. However the problem just wasn't making any sense. Thankfully the most recent person who emailed me was quite persistent and so the...
Posted by Tony | 1 comment(s)
Filed under: ,
Sun, Jan 18 2009 20:06

"Out of memory" or "Object not found" while importing reports?

Just trying to figure out some weird problems with a clients medium sized front end. I isolated the above messages while importing reports to having PDF Creator as my default printer. Once I switched my default printer to my HP Laser Jet printer I was...
Posted by Tony | with no comments
Filed under: ,
Thu, Dec 4 2008 15:26

Unusual software bugs

Thanks to fellow Access MVP Graham R Seach for showing that these kinds of bugs really do have a name. And that it's not just me. " Unusual software bugs are a class of software bugs that are considered exceptionally difficult to understand and...
Posted by Tony | with no comments
Filed under: , ,
Tue, Nov 11 2008 0:40

Losing the [Event Procedure] on a command button

I just added a tab control to my standard File Locations form in the Granite Fleet Manager program. I added the tab control and cut and pasted all the controls from the form to the page on the tab control. I then discovered that I had lost all the [Event...
Posted by Tony | 1 comment(s)
Filed under: , , ,
Fri, Oct 3 2008 16:57

Access 2003 - "Please wait while Windows configures Microsoft Office Professional Edition 2003"

GaryS started a thread titled All Applications work but Access . I was stumped but he did some more sleuthing and figured out that the Access 2003 post-Service Pack 3 hotfix package: December 18, 2007 solved the problem. To GaryS - thanks for posting...
Posted by Tony | 3 comment(s)
Filed under: ,
Fri, Jun 27 2008 14:06

Compile error: Sub or Function not defined

As a follow up to my previous blog entry Compile error: Method or data member not found here's the identical VBA IDE problem but due to a function name not found. In the above screen shot CalcPrice is the undefined function yet the VBA showed the...
Posted by Tony | with no comments
Filed under: ,
Mon, Jun 16 2008 1:49

Compile error: Method or data member not found

I'd forgotten about this bug in Access 2003 VBA. I was getting the message Compile error: Method or data member not found but the me. control was just fine. In fact I could see the control in the line above. I spent about 10 minutes trying things...
Posted by Tony | 2 comment(s)
Filed under: ,
Thu, May 29 2008 18:41

KB article 950812: Compact and repair might delete your database (Access 2007)

If you're reading my blog then you should also be subscribed to the MS Access team blog. Nevertheless this is an important notice for Access 2007 foilks so here you go. KB article 950812: Compact and repair might delete your database (Access 2007...
Posted by Tony | 3 comment(s)
Filed under: ,
Sat, May 10 2008 22:56

Bug in ADO, SQL Server and latest OS SPs

On a computer that is running Windows Vista, Windows Server 2008, or Windows XP, an incorrect value is returned when an application queries the identity column value of a newly inserted row in various versions of SQL Server 2005 and of SQL Server 2000...
Posted by Tony | with no comments
Filed under: , ,
Wed, Apr 23 2008 0:40

The expression On Click you entered ...

I was getting the below error message in Access 2003 when I clicked on a command button. Likely because I was working on a form module and possibly saved it while the form was in regular view and not in design view. "The expression On Click you entered...
Posted by Tony | 16 comment(s)
Filed under: ,
Sun, Jan 13 2008 17:54

Getting Your "Favorite" <Microsoft Product> Bug Fixed

A very interesting article describing how Microsoft personnel decides which bugs get fixed first. Getting Your "Favorite" SQL Server Bug Fixed . This does apply to other products within Microsoft. Allen Brown, of course, has done a fine job...
Posted by Tony | with no comments
Filed under: ,
Thu, Dec 20 2007 15:05

Access 2007: "This database is in an unrecognized format"

An accde or mde created in Access 2007 SP1 can't be read in Access 2007 no SP. Error message when you try to open a compiled database file or a compiled project file in Access 2007: "This database is in an unrecognized format" Some Microsoft...
Posted by Tony | 14 comment(s)
Filed under: ,
Wed, Nov 7 2007 16:13

Access 2003 SP3 bug on bit data type field in a linked SQL Server table

We've been seeing reports of this in the newsgroups. Here's Microsoft's KB article: After you install Office 2003 SP3, you encounter various problems in an Access project when you work with a Bit data type column in a linked SQL Server table
Posted by Tony | with no comments
Filed under: , ,
Wed, Jun 13 2007 11:31

Running Access on a Windows Vista peer to peer network?

Are you running Access on a Windows Vista peer to peer network? That is the back end MDB is on a Windows Vista machine. And the front end is also on a Windows Vista box. Wierd things are happening? Performance is terrible or Access crashes? The problem...
Posted by Tony | with no comments
Filed under: ,
Mon, May 14 2007 13:55

Interesting bug in column headings of list boxes in Access 2007

A client asked why some code behind a list box suddenly started updating 57386 records in a table instead of the expected 38 records. Turns out the problem is a difference in behavior between Access 2007 and previous versions of Access. The following...
Posted by Tony | 1 comment(s)
Filed under: ,