A
Alex Horn
I just installed Office on a new computer and Acces is
giving me an error on the following code, it is getting
stuck on the Format function. What is the name of the
reference library that needsto be installed or is there
some other problem? this code worked nicely before I
moved to the new machine
Complile Error:
Can't find Project or Library
Private Sub Form_Open(Cancel As Integer)
Dim MyDate, MyDate1, lastval, lastval1 As Date
Dim SQLText As String
MyDate1 = Now() - 1
MyDate = Format(MyDate1, "m/d/yyyy")
giving me an error on the following code, it is getting
stuck on the Format function. What is the name of the
reference library that needsto be installed or is there
some other problem? this code worked nicely before I
moved to the new machine
Complile Error:
Can't find Project or Library
Private Sub Form_Open(Cancel As Integer)
Dim MyDate, MyDate1, lastval, lastval1 As Date
Dim SQLText As String
MyDate1 = Now() - 1
MyDate = Format(MyDate1, "m/d/yyyy")