Dim Dbs as Database

  • Thread starter Thread starter Frank O'Connor
  • Start date Start date
F

Frank O'Connor

When I wrie the command

"Dim Dbs as Database"

Database is not showing up in the drop down options.

As well, when I go to run it I get an error message saying
that it is an undefined function.

What's up. I've used this code before and I know it works
on other machines.

Frank
 
-----Original Message-----
When I wrie the command

"Dim Dbs as Database"

Database is not showing up in the drop down options.

As well, when I go to run it I get an error message saying
that it is an undefined function.

What's up. I've used this code before and I know it works
on other machines.

Frank
.
Click to expand...
Check your references make sure DAO is checked.
 
When I wrie the command
"Dim Dbs as Database"

Database is not showing up in the drop down options.

As well, when I go to run it I get an error message saying
that it is an undefined function.

What's up. I've used this code before and I know it works
on other machines.
Click to expand...

See:

ACC2000: By Default, New Access Databases Do Not Include Reference to Microsoft
DAO Object Library
http://support.microsoft.com/default.aspx?scid=kb;en-us;225962

References That You Must Set When You Work with Microsoft Access
http://support.microsoft.com/default.aspx?scid=kb;en-us;197110
 
Back
Top