Unhandled errors can couse this error. Is your system set to break on
unhandled error?
<ALT> F11 then Tools>Options...>General tab
I sometimes set mine to break on all errors to track down problems.
>have converted an Access97 to Access2003 (in 2000 file format) - much is
>working ok but some command buttons are throwing the error:
[quoted text clipped - 15 lines]
>
>advice definitely welcomed...thnx...NTC

Signature
HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.
NetworkTrade - 09 Mar 2007 14:40 GMT
thank you for that - did change to 'all errors' and it now zooms into vb line
error rather than just a general message box....
now my dilemma is why 97 vb code doesn't work in 03 access...
the line in error is: rstQuote.AddNew
preceeding it the rstQuote is defined...and then set...without throwing an
error - and so I guess it is the .AddNew isn't valid....
probably the first of quite a few errors I need to correct and wonder what
is the reference to the correct vb...between older and newer versions ??

Signature
NTC
> Unhandled errors can couse this error. Is your system set to break on
> unhandled error?
[quoted text clipped - 20 lines]
> >
> >advice definitely welcomed...thnx...NTC
Stefan Hoffmann - 09 Mar 2007 14:44 GMT
hi,
> now my dilemma is why 97 vb code doesn't work in 03 access...
> the line in error is: rstQuote.AddNew
In Access 2003 there are two libraries providing a recordset class:
ADODB.Recordset and DAO.Recordset
Add the DAO 3.6 library to your references and change the declarations
of your recordsets to e.g.
Dim rstQuote As DAO.Recordset
then it should compile without errors.
mfG
--> stefan <--
NetworkTrade - 09 Mar 2007 15:43 GMT
thanks for advice Stefan,......will follow on this....

Signature
NTC
> hi,
>
[quoted text clipped - 13 lines]
> mfG
> --> stefan <--