Re: Access complains : Update or CancelUpdate without AddNew or Edit

------=_Part_5212_28795547.1206076133660
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

On Thu, Mar 20, 2008 at 10:20 AM, Andreas <maps.on@[EMAIL PROTECTED]
> wrote:


> ... event before update caused an error:
> Update or CancelUpdate without AddNew or Edit


This sounds more like a MS-Access Visual Basic Coding problem.  Any ODBC
related error messages are really PostgreSQL error messages that are
relayed
to you.   What you are describing here doesn't sound any thing like and
ODBC
or PostgreSQL error.

They say they dont do anything special. Just clicking a checkbox or
> trying to jump to the next record would do to trigger the error.
> Later the same action won't cause any trouble, so I can't crack this in
> debug-mode. Here on my box it always works as expected.
>

How are you binding the form to the user controls?  Are you linking from
linked tables, linked DAO recordsets, or linked ADO recordsets?

Could someone here give a hint?
>


I would start by looking for code in the form that might be calling the
form's recordset UPDATE or CancelUpdate method.

Also,  if this is a access problem, I would check out this site for
further
information:  www.utteraccess.com

Regards,
Richard Broersma Jr.

------=_Part_5212_28795547.1206076133660
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

On Thu, Mar 20, 2008 at 10:20 AM, Andreas &lt;<a
href="mailto:maps.on@[EMAIL PROTECTED]
">maps.on@[EMAIL PROTECTED]
>&gt; wrote:<br><div
class="gmail_quote"><div>&nbsp;</div><blockquote class="gmail_quote"
style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt
0.8ex; padding-left: 1ex;">
.... event before update caused an error:<br>
Update or CancelUpdate without AddNew or Edit</blockquote><div><br>This
sounds more like a MS-Access Visual Basic Coding problem.&nbsp; Any ODBC
related error messages are really PostgreSQL error messages that are
relayed to you.&nbsp;&nbsp; What you are describing here doesn&#39;t sound
any thing like and ODBC or PostgreSQL error.<br>
<br></div><blockquote class="gmail_quote" style="border-left: 1px solid
rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
They say they dont do anything special. Just clicking a checkbox or<br>
trying to jump to the next record would do to trigger the error.<br>
Later the same action won&#39;t cause any trouble, so I can&#39;t crack
this in<br>
debug-mode. Here on my box it always works as expected.<br>
</blockquote><div>&nbsp;<br>How are you binding the form to the user
controls?&nbsp; Are you linking from linked tables, linked DAO recordsets,
or linked ADO recordsets?<br><br></div><blockquote class="gmail_quote"
style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt
0.8ex; padding-left: 1ex;">

Could someone here give a hint?<br>
</blockquote></div><br><br>I would start by looking for code in the form
that might be calling the form&#39;s recordset UPDATE or CancelUpdate
method.&nbsp; <br><br>Also,&nbsp; if this is a access problem, I would
check out this site for further information:&nbsp; <a
href="http://www.utteraccess.com">www.utteraccess.com</a><br>
<br>Regards,<br>Richard Broersma Jr.<br>

------=_Part_5212_28795547.1206076133660--