Access 97 Calendar error after Access 2000 conversion

  • Thread starter Thread starter LLively2
  • Start date Start date
L

LLively2

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<<<<<<<<<<<<<<
Click to expand...
Click to expand...
Click to expand...
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()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.

Reply to group, rather than allenbrowne at mvps dot org.

LLively2 said:
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<<<<<<<<<<<<<<
Click to expand...
Click to expand...
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()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
Click to expand...
 
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
 
Back
Top