Calendar Control

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 he
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

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: ToolsReferences: put a checkmark next to
"Microsoft DAO 3.6 Object Library" (the version number might differ)

HTH,
--
George Nicholson

Remove 'Junk' from return address.


"Ant" wrote in message
...
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 he
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

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

Thanks

"George Nicholson" wrote in message
...
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: ToolsReferences: put a checkmark next to
"Microsoft DAO 3.6 Object Library" (the version number might differ)

HTH,
--
George Nicholson

Remove 'Junk' from return address.


"Ant" wrote in message
...
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 he
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

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

--
George Nicholson

Remove 'Junk' from return address.


"Ant" wrote in message
news:li3Ac.208$Fb4.33@newsfe5-win...
Thats worked just dandy!
Its easy when you know how isnt it?

Thanks

"George Nicholson" wrote in message
...
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: ToolsReferences: put a checkmark next to
"Microsoft DAO 3.6 Object Library" (the version number might differ)

HTH,
--
George Nicholson

Remove 'Junk' from return address.


"Ant" wrote in message
...
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 he
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