EAXMPLE 1

Option Compare Database
Option Explicit
Public RiderCode, Back, Destination, Initials, RMunicipality As String
Public Go As Date
Public Unit As Long

Private Sub ActiveXCtlCalendar_Click()
'Assigns the date clicked on the calendar
'to the appointment date
'then sets the focus to TimeGo control before hiding the calendar.

>>>>>>>>>>>[DateAppt].Value = ActiveXCtlCalendar.Value<<<<<<<<<<<<<<
TimeGo.SetFocus
ActiveXCtlCalendar.Visible = False

Cannot jump to 'DateAppt' because it is in a library
'C:\....\....\....' which is not currently referenced.

EXAMPLE 2

Option Compare Database
Option Explicit

Private Sub axcCalendar_Click()

TxtBeginningDate.Value = axcCalendar.Value
End Sub

Private Sub Form_Current()
>>>>>>>>>>>>>>>axcCalendar.Value = TxtToday.Value<<<<<<<<<<<<<
TxtBeginningDate.Value = axcCalendar.Value

End Sub

Cannot jump to 'axcCalendar' because it is in a library
'C:\....\....\....' which is not currently referenced.

What should be done to convert this database properly?

Thanks in advance,

Lynn

The calendar control will break your application when you convert from one
version to another, or move the database from machine to machine.

If the target version happens to have the correct version of the Calendar
control installed, you can open a code window, choose References from the
Tools menu, uncheck the box beside the wrong version, check the box for the
right version, and test if it worked.

Or, you could dump the problem control, and just use a simple Access form
that does not break your application. There are several around, such as this
one:
http://allenbrowne.com/ser-51.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"LLively2" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> EAXMPLE 1
>
> Option Compare Database
> Option Explicit
> Public RiderCode, Back, Destination, Initials, RMunicipality As String
> Public Go As Date
> Public Unit As Long
>
> Private Sub ActiveXCtlCalendar_Click()
> 'Assigns the date clicked on the calendar
> 'to the appointment date
> 'then sets the focus to TimeGo control before hiding the calendar.
>
>>>>>>>>>>>>[DateAppt].Value = ActiveXCtlCalendar.Value<<<<<<<<<<<<<<
> TimeGo.SetFocus
> ActiveXCtlCalendar.Visible = False
>
> Cannot jump to 'DateAppt' because it is in a library
> 'C:\....\....\....' which is not currently referenced.
>
> EXAMPLE 2
>
> Option Compare Database
> Option Explicit
>
> Private Sub axcCalendar_Click()
>
> TxtBeginningDate.Value = axcCalendar.Value
> End Sub
>
> Private Sub Form_Current()
>>>>>>>>>>>>>>>>axcCalendar.Value = TxtToday.Value<<<<<<<<<<<<<
> TxtBeginningDate.Value = axcCalendar.Value
>
> End Sub
>
> Cannot jump to 'axcCalendar' because it is in a library
> 'C:\....\....\....' which is not currently referenced.
>
> What should be done to convert this database properly?
>
> Thanks in advance,
>
> Lynn

Just to let you know...I looked at what you recommended above about the
references and could not make sense of what needed to be re-referenced.
I took the Access 97 database home to my lab and ran it through Access
2003 (which I did not have at the clients) and it converted it to
Access 2000 when first opened and everything worked perfectly without
having to do anything else to it.

Thanks for your response Allen