A newbie question

  • Thread starter Thread starter Bruceh
  • Start date Start date
B

Bruceh

I'm using an existing Function in an Access file as a template to
write a Function for my database and for some reason VB doesn't
recognize something.

I copied the beginning part...
Public Function ExportDbf()
Dim dbs as Database

But VB doesn't recognize "Database". When I start typing
the string
Dim xxx As Data
The list of available options only shows:
DataAccessPage
DataAcessPages
DataTypeEnum
Date
...

In the other Access file, it autocompletes OK. I'm confused.
 
Bruceh said:
I'm using an existing Function in an Access file as a template to
write a Function for my database and for some reason VB doesn't
recognize something.

I copied the beginning part...
Public Function ExportDbf()
Dim dbs as Database

But VB doesn't recognize "Database". When I start typing
the string
Dim xxx As Data
Click to expand...

You have to include a reference to a DAO library. To do this, click on
Tools, References then scroll down to Microsoft DAO 3.6 Object Library and
check the box then click OK. Now Database will be one of your choices.

Tom Lake
 
Thanks Tom...

Tom said:
You have to include a reference to a DAO library. To do this, click on
Tools, References then scroll down to Microsoft DAO 3.6 Object Library and
check the box then click OK. Now Database will be one of your choices.
Click to expand...
 
Back
Top