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

Rocky Smolin rockysmolin at bchacc.com
Wed Jun 6 21:02:38 CDT 2012


True dat.  But this recordset is not empty.

R 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence
Sent: Wednesday, June 06, 2012 3:37 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



More information about the AccessD mailing list