jm.hwsn
jm.hwsn at gmail.com
Wed Jun 6 18:53:02 CDT 2012
I have a similar problem with .MoveNext The database crashes (shuts down) at the .MoveNext line. What is strange to me, is that the form works... including the .MoveNext line IF the form is opened using the Navigation Pane. But, if the form is opened from a command button on another form it crashes. Will this fix that problem also? Thanks, Jim -----Original Message----- From: Jim Lawrence Sent: Wednesday, June 06, 2012 5:36 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] FW: E-Z-MRP(tm) Error Report Hi Rocky: After I would have just opened a recordset, the first command would be something like: With rsMyRecordset If .BOF = False Or .EOF = False Then .MoveLast ... Else glEmployeeNumber = 0 'M/T End if End With I always validate first with .BOF and .EOF or a movement within a M/T recordset will produce an error. Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin Sent: Wednesday, June 06, 2012 2:28 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] FW: E-Z-MRP(tm) Error Report This is the real mysterious part "in Design view." - that should never come out of an mde should it? Not the most obscure Access message I've seen in the last 12 years. But it's up there in the top 10. R -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin Sent: Wednesday, June 06, 2012 2:22 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] FW: E-Z-MRP(tm) Error Report That was my first thought, but no - there's records there. R -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Steele Sent: Wednesday, June 06, 2012 1:09 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] FW: E-Z-MRP(tm) Error Report Empty record set? Doug On Wed, Jun 6, 2012 at 12:55 PM, Rocky Smolin <rockysmolin at bchacc.com>wrote: > How could an mde generate this error on the line of code: > > DoCmd.GoToRecord , , acLast > > MTIA > > Rocky Smolin > Beach Access Software > 858-259-4334 > www.bchacc.com > www.e-z-mrp.com > Skype: rocky.smolin > > > > -----Original Message----- > From: Victor Garcia [mailto:victor.hugo.garcia at prometalmexico.com] > Sent: Wednesday, June 06, 2012 10:03 AM > To: rockysmolin at bchacc.com > Subject: E-Z-MRP(tm) Error Report > > Error: 2499 - You can't use the GoToRecord action or method on an > object in Design view. > In: frmSOPackingList.Form_Open > > > > -- > 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 -- 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com