Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Trouble operating the switchboard

Status
Not open for further replies.

evonk

Technical User
Dec 17, 2003
4
US
I recently converted a 2000 version file to a 1997 file. The switchboard had be working fine on the 2000 but it gave me problems with the conversion. I decide to start from scratch with the switchboard but I'm still getting the same error. The error is when the switchboard form is selected: Compile error: user defined type not defined. the code Private Sub fill options is yellow highlighted and a couple of lines down the code Dim dbs As Database is blue highlighted.
 
Hi!

I think the database still "believes" it's 2000;-)

You can either:
Go to any code module (hit CTRL+G), use Tools | References and check the Microsoft DAO 3.# Library. After that, you'll probably have to find any lines with.

[tt]dim <somevariable> as database
dim <somothervariable as recordset>[/tt]

And change them to:

[tt]dim <somevariable> as dao.database
dim <somothervariable as dao.recordset>[/tt]

I think another possibility is to create a new database, import all objects except the switchboard, and then create the switchboard there.

HTH Roy-Vidar
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top