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.
More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.
This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…