I have declared a variable Private under Option Explicit etc.
I am trying to keep track of when a change occurs.
I have not been able to complete my testing because I get errors.
Private oseasonal as date
If IsNull(Me.[seasonal_updated]) Or Nz(Me.[seasonal_updated]) = "" Then
oseasonal_updated = CDate("00/00/00")
oseasonal_updated = Me.seasonal_updated
I get a type mismatch on this line: oseasonal_updated = CDate("00/00/00")
I get a type mismatch when I have tried oseasonal_updated = " " also.
I have not gotten to the section below that takes the date and converts to string:
If oseasonal <> Me.seasonal Then
midno = mid
blastupdate = olast_updated
bupdateby = oupdated_by
bchange = "Seasonal Updated was " & month(oseasonal) & "/" & day(oseasonal) & "/" & year(oseasonal)
lastupdate = Me.LAST_UPDATED
updateby = Me.UPDATED_BY
change = "Seasonal Updated is " & & month(me.seasonal) & "/" & day(me.seasonal) & "/" & year(me.seasonal)
I do not know if I have approach the date to string correctly.
With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.
QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®.
Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
Entering time in Microsoft Access can be difficult. An input mask often bothers users more than helping them and won't catch all typing errors. This article shows how to create a textbox for 24-hour time input with full validation politely catching …