Access problem!

Article View: a.bsu.programming

Article #86819

#86819

From: First Investment Company
Date: Sat, 07 Aug 1999 00:00

32 lines
2530 bytes

Dear Friends,

I recently upgraded a MS Access 97 database to MS Access 2000. I have faced
a problem since upgrading but I don't know how to solve it. I give below an
extract of the code that gives me this problem. At the bottom you will find
that the exact nature of the problem that I face.

Extract Start

Sub Credit_Click()

   Dim dbsdeal_auto As database
   Dim RSTgl_temp_credit As Recordset
   Dim Charges As Double
   Dim DEN As Double
   Dim Pos As Double

    Set dbsdeal_auto = CurrentDb()
    Set RSTgl_temp_credit = dbsdeal_auto.OpenRecordset("GL TEMP credit",
dbOpenDynaset)

Extract End


The module compiles well without an error. However, when I run the module it
gives a message stating "Run-time error '13' " When I use the debug option,
it goes to the last line (underlined).

I checked help but I am unable to resolve the problem. Should I get to
tools, preference and add-in something or ??? Could one of you folks please
help in overcoming this problem. Your help is much appreciated. Thanks a
lot.

Technical Details

Message-ID: <7ohr43$l0v$1@news.qualitynet.net>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: f5380,ed40809886c85114,start
X-Google-Attributes: gidf5380,public
X-Google-Thread: 127b9d,ed40809886c85114,start
X-Google-Attributes: gid127b9d,public
X-Google-Thread: 10385a,ed40809886c85114,start
X-Google-Attributes: gid10385a,public
X-Google-Thread: 107d8b,ed40809886c85114,start
X-Google-Attributes: gid107d8b,public
X-Google-Thread: 10fb44,ed40809886c85114,start
X-Google-Attributes: gid10fb44,public
X-Google-Thread: 10804c,ed40809886c85114,start
X-Google-Attributes: gid10804c,public
X-Google-Thread: fc8d0,ed40809886c85114,start
X-Google-Attributes: gidfc8d0,public
X-Google-Thread: 102bfa,ed40809886c85114,start
X-Google-Attributes: gid102bfa,public
From: "First Investment Company" <alola@First-Investment.Com>
Subject: Access problem!
Date: 1999/08/07
Message-ID: <7ohr43$l0v$1@news.qualitynet.net>
X-Deja-AN: 509909269
X-Priority: 3
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
X-Complaints-To: usenet@news.qualitynet.net
X-Trace: news.qualitynet.net 934047683 21535 195.226.230.224 (7 Aug 1999 17:41:23 GMT)
Organization: QualityNet
X-MSMail-Priority: Normal
NNTP-Posting-Date: 7 Aug 1999 17:41:23 GMT
Newsgroups: a.bsu.programming,adass.iraf.programming,alt.geo.emblaze-support.creator-support.developer-support,alt.msdos.programmer,alt.mud.programming,alt.sb.programmer,alt.winsock.programming,comp.cad.microstation.programmer,comp.games.development.programmi