var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Declaring Variables in Access 2000
I am trying to declare a variable as type 'Database' eg
dim dbs as Database
set dbs = currentdb
but when I compile I get the following compile error:
'user defined type not defined'
dim objdb as database
set objdb = currentdb()
Well, it doesn't work because Access 2000 uses ADO by default. The Database object is part of the DAO model.
So you have to enable DAO support. From the Visual Basic windows select menu Tools/References and enable 'Microsoft DAO 3.6 Object Library'. That's it.
The 'Microsoft DAO 3.6 Object Library' was not enabled.
It's working now!