Browse by Tags

All Tags » bug (RSS)
Friday, June 27, 2008 2:06 PM

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: ,
Monday, June 16, 2008 1:49 AM

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: ,
Thursday, May 29, 2008 6:41 PM

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 | with no comments
Filed under: ,
Saturday, May 10, 2008 10:56 PM

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: , ,
Tuesday, April 22, 2008 10:40 PM

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 | 3 comment(s)
Filed under: ,
Sunday, January 13, 2008 5:54 PM

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: ,
Thursday, December 20, 2007 3:05 PM

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 | 12 comment(s)
Filed under: ,
Wednesday, November 07, 2007 4:13 PM

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: , ,
Wednesday, June 13, 2007 11:31 AM

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: ,
Monday, May 14, 2007 1:55 PM

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: ,