[AccessD] upgrade problem to Access 2007

Robert robert at servicexp.com
Sun Mar 7 09:39:31 CST 2010


This may actually be a Windows 7 Issue. I have been running an .mde (& .mdb)
in Access 2007 for almost 2 years now on Windows XP machines without any of
these strange bugs. All my troubles started when my program started to be
deployed on Windows 7 Machines..

This bug is nothing compared to some of the others I've found. Windows 7 and
Access 2007 .mde (& .mdb) have, IMO, major issues working together...

The latest major one I've found is on a form/subforms where you have an
OnCurrent event firing to simply requery a list box on the main form, causes
(intermittently) the field the users is in to lockup and display 
"?Name" in the field. This throws some esoteric error.  This problem does
not exist with users on Windows XP Machines...


Getting back to the point at hand.. :-) You may have to setfocus back on the
combobox after the form fully loads and then sometime, for whatever reason,
you may have to hit it twice..


WBR
Robert 





-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
Sent: Sunday, March 07, 2010 2:15 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] upgrade problem to Access 2007

Gotta love 2007.  I don't know, but 2007 is full of those 'quirks'.

What's in the after update event?  And where is the focus when the after
update event completes?  Maybe you could post the after update code.

Can you force the behavior you want by adding a .SetFocus?

Rocky


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gershon Markowitz
Sent: Saturday, March 06, 2010 9:58 PM
To: accessd at databaseadvisors.com
Subject: [AccessD] upgrade problem to Access 2007

I recently upgraded my computer to windows 7 and office 2007.  I have a
small application written in access2003.  Everything works in A2007, except
for one small quirk which I can't figure out.  When I enter the form, my
first combo box gets focus.  After I enter something in the combo box, the
form goes out and returns information.  At this point the combo box gets
focus again.  This works in xp-2003.  But when I upgraded, focus is not set
on the combo box.  Interestingly, If I switch windows view, and then switch
back to Access, the focus is there.  I also noticed that as soon as I click
on the taskbar to switch a window view, the cursor suddenly appears in the
combo box.

Has anyone seen this kind of behavior?

Thanks

Gershon Markowitz
mailto:GershonTikunim at gmail.com



--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list