Calendar Control

[Ant]

Asking about a Calendar control in my previous post on the 14/06/04, I was
advised by Stephen Lebans to:

“Dump the ActiveX control as you can get the exact same control without
the ActiveX distribution/versioning/registration issues here:
http://www.lebans.com/monthcalendar.htm”



This I did and followed the very comprehensive step by step instructions in
a clean test DB. Everything worked fine and I was very impressed so
proceeded to do the same in my live application. I first did a Compile
before the import of the modules (All was fine) and then immediately after
the import of the modules. This time I got the following Compile error :
Variable not defined: dbLong



Start of code:

Public Property Let MultiSelect(ms As Boolean)

' Allo wuser to select a Range of dates instead of just one.

If ms Then

m_MultiSelect = MCS_MULTISELECT

Else

m_MultiSelect = 0

End If

' Update custom property

SetProperty "MultiSelect", dbLong, m_MultiSelect



End Property

End of Code



Being only an enthusiastic amateur and not knowing much about VB can anyone
help me out as I would really like to get this calendar control working?



PS I am using Access 2003



Thanks in anticipation



Ant

 

[George Nicholson]

I'm using XP but dbLong is a DAO constant, so my guess is that you need a
reference to the DAO object library. This is a very common error when
importing objects or code into a new database, since the DAO library is not
selected by default since Access 97, but is still very frequently used.

In the Visual Basic Editor: Tools>References: put a checkmark next to
"Microsoft DAO 3.6 Object Library" (the version number might differ)

HTH,

 

[Ant]

Thats worked just dandy!
Its easy when you know how isnt it?

Thanks

 

[George Nicholson]

Easier, maybe. There's always something new to learn.