problems with new versions of access

  • Thread starter Thread starter Melih Cavli
  • Start date Start date
M

Melih Cavli

Hello,
I made a form and wrote a module in access 97, now I would like to run
it in access xp but it does not recognize some sentences I had
written, such as:
Dim mydb1 As Database
Dim T1 As Recordset
Dim selquery1 As QueryDef
Dim Y1 As Integer
Dim Z1 As Integer
Dim R1
Dim mel1
Dim h3 As Variant
On Error GoTo vedat1:
Set mydb1 = DBEngine.Workspaces(0).Databases(0)
Set selquery1 = mydb1.OpenQueryDef("Yasgunleri2")
----------
the access xp underlines the first sentence for example and urges me
to find it in the library. I think I should download the access 97
library in the access xp program but I do not know where I should
download and which library?
I need help.
Thank You Very Much.
Vedat CAVLI
Istanbul / Turkey
 
Hi,

I think the following might help :

Dim mydb1 As DAO.Database
Dim T1 As DAO.Recordset
Dim selquery1 As DAO.QueryDef

Jan Hx.
 
Back
Top