[AccessD] [SPAM SUSPECT] Field Entry question

Joe Hecht jmhecht at earthlink.net
Wed Feb 8 13:53:48 CST 2006


Bobby,
 I do not think the error number shows. How can I get it?

Joe Hecht
jmhecht at earthlink.net

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Bobby Heid
Sent: Wednesday, February 08, 2006 11:50 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] [SPAM SUSPECT] Field Entry question

Just see what the error number(s) are and in your error
handler so a "resume
next" if the err.number is one of those values.

Bobby

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Joe Hecht
Sent: Wednesday, February 08, 2006 1:53 PM
To: 'Access Developers discussion and problem solving'
Subject: [SPAM SUSPECT] [AccessD] Field Entry question
Importance: Low


I have a subform based on the following sql statement

 

SELECT [20ACCTEXT].MEMO_KEY, [20ACCTEXT].MEMO_LINE,
Left([Memo_Key],5) AS IncNum

FROM 20ACCTEXT;

 

When I try to enter a new record I get an error saying
IncNum (a hidden field used as link to parent records) is an
expression and con not   be edited.

 

If I manually clear the two errors generated everything
continues ok. Is there a way to suppress the two errors.

 

Thanks

 

Joe Hecht

jmhecht at earthlink.net

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