Full Version: Cant Find Library
UtterAccess Discussion Forums > Microsoft® Access > Access Date + Time
Everettc4
I get an error when I open a older timeclock database I built in 2003 version now opening on a 2010 version does this mean anything to anybody???

The code has problems with the =Format(Now(),

Private Sub Form_Timer()
' Update the clock's time value
Me.lblDisplay.Caption = Format(Now(), "dddd mmmm d, yyyy h:nn:ss AMPM")
End Sub

Thanks
MikeLyons
QUOTE (Everettc4 @ Jul 22 2011, 01:39 PM) *
I get an error when I open a older timeclock database I built in 2003 version now opening on a 2010 version does this mean anything to anybody???

The code has problems with the =Format(Now(),

Private Sub Form_Timer()
' Update the clock's time value
Me.lblDisplay.Caption = Format(Now(), "dddd mmmm d, yyyy h:nn:ss AMPM")
End Sub

Thanks


In your VBA editor go to Tools > References and see if any are marked MISSING.

Mike
Everettc4
Whats Odd is references is grayed out???
MikeLyons
QUOTE (Everettc4 @ Jul 25 2011, 04:30 PM) *
Whats Odd is references is grayed out???


That is odd. Have you tried a Compact and Repair?

Oh, and make sure your code is stopped, not in Break mode, when you attempt to look at References.

Mike
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.