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

jm.hwsn jm.hwsn at gmail.com
Wed Jun 6 20:16:29 CDT 2012


Thanks, I appreciate the response.
I'll try it tomorrow when I get to work.
Thanks again.
Jim

-----Original Message----- 
From: Jim Lawrence
Sent: Wednesday, June 06, 2012 7:53 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] FW: E-Z-MRP(tm) Error Report

Hi Jim:

I do not know, but it is always best practice to test for a potential error
and avoid it rather than catching an error and handling it. As you have
found out some systems don't handle errors well. Avoidance is always the
best policy.

If you have ever worked with "C", one such error will bring an application
down in a split second or worse, it just bleeds to death, eventually
bringing your whole system down as well. The error handlers in Access,
especially in the latest versions are not the best...apparently....and most
of Access is still probably just a series of old "C" libraries, written in
the late nineties. The latest versions, I could swear are just being managed
by co-op students. ;-)

Jim

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

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

-- 
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