Rocky Smolin
rockysmolin at bchacc.com
Fri Feb 24 09:03:07 CST 2012
Aha. Well I'm going to move that code to the Load event on the other forms. Oddly it's just in the forms for the purchasing module - the others seem to work OK but haven't thoroughly tested. Thanks R -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Dettman Sent: Friday, February 24, 2012 6:58 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Two problems A2003 vs A2010 Rocky, The code was in the wrong place to start with. Your just lucky it worked in 2003. In On Open, the form is just being opened and the forms record set may or may not be fully populated at any point. You are not guaranteed that it's fully populated until the On Load event. You might have had the same problem with the 2003 version with just moving to a faster/slower PC then what you developed with. Jim. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin Sent: Friday, February 24, 2012 09:28 AM To: 'Access Developers discussion and problem solving' Subject: [AccessD] Two problems A2003 vs A2010 Dear List: I have a simple line of code Docmd.GoToRecord , , acLast which works in A2003 but in A2010 generates a run-time error '2046 - The command or Action 'GoToRecord' is not available now'. The second problem is that the form does not open maximized in 2010 but does on 2003. I moved the maximize and gotorecord code to the Load event from the Open event and it now appears to work. Has anyone seen this? IS this a known 'eccentricity' of 2010? Any guidelines on what is OK in Open and what must be in Load in 2010? MTIA Rocky Smolin Beach Access Software 858-259-4334 www.bchacc.com <http://www.bchacc.com/> www.e-z-mrp.com <http://www.e-z-mrp.com/> Skype: rocky.smolin -- 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