[AccessD] FW: E-Z-MRP(tm) Error Report

Ooh, good catch.  It doesn't persist then past the Open event?

R 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust
Sent: Wednesday, June 06, 2012 9:21 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] FW: E-Z-MRP(tm) Error Report

You might have to store the OpenArgs value to a module level variable.
I've had instances of it evaporating otherwise.

Charlotte Foust

On Wed, Jun 6, 2012 at 9:17 PM, Rocky Smolin <rockysmolin at bchacc.com> wrote:

> Well, there's a theory.  In the open if there's an openarg (a PK 
> passed by a calling program) I do a find first else I just move to the 
> last record.
>
> I could move the whole shebang from the open event to the Load event.
>
> R
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte 
> Foust
> Sent: Wednesday, June 06, 2012 9:09 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] FW: E-Z-MRP(tm) Error Report
>
> Can you even use that command in the Form_Open event?  I didn't think 
> the recordset was loaded at that point.  Thought you had to wait for 
> the Load event.
>
> Charlotte Foust
>
> 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