UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
Reply to this topicStart new topic
> Cant Find Library, Office 2010    
 
   
Everettc4
post Jul 22 2011, 03:39 PM
Post #1

UtterAccess Addict
Posts: 168
From: Oregon



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
Go to the top of the page
 
+
MikeLyons
post Jul 22 2011, 05:14 PM
Post #2

UtterAccess VIP
Posts: 1,857
From: BC, Canada



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
Go to the top of the page
 
+
Everettc4
post Jul 25 2011, 06:30 PM
Post #3

UtterAccess Addict
Posts: 168
From: Oregon



Whats Odd is references is grayed out???
Go to the top of the page
 
+
MikeLyons
post Jul 25 2011, 07:00 PM
Post #4

UtterAccess VIP
Posts: 1,857
From: BC, Canada



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
Go to the top of the page
 
+

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 



RSS Go to Top  ·  Lo-Fi Version Time is now: 21st May 2013 - 02:44 PM