G goju Registered User. Local time Today, 11:47 Joined Apr 7, 2005 Messages 77 Jul 5, 2005 #1 please see below script error, im' a little lost CDate(Me.ArchiveDate) = invalid use of null Private Sub Form_Activate() Me.TimeSpan = Now() - End Sub
please see below script error, im' a little lost CDate(Me.ArchiveDate) = invalid use of null Private Sub Form_Activate() Me.TimeSpan = Now() - End Sub
B Bat17 Registered User. Local time Today, 11:47 Joined Sep 24, 2004 Messages 1,687 Jul 5, 2005 #2 Me.ArchiveDate is returning null values which cDate can't handle. what do you want to do when there is no date? Peter
Me.ArchiveDate is returning null values which cDate can't handle. what do you want to do when there is no date? Peter
G goju Registered User. Local time Today, 11:47 Joined Apr 7, 2005 Messages 77 Jul 5, 2005 #3 not sure i understand when i archive the information it should take todays date
B Bat17 Registered User. Local time Today, 11:47 Joined Sep 24, 2004 Messages 1,687 Jul 5, 2005 #4 how are you telling ArchiveDate to take todays date? where/how are you using this line? Date(Me.ArchiveDate) Peter
how are you telling ArchiveDate to take todays date? where/how are you using this line? Date(Me.ArchiveDate) Peter