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