AFTER UPDATE - DATE

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've implemented Allen Browne's code and it works great. The problem I have is in the after update command I had a macro that recorded the date the record was changed. Now that I have that code I can't use that macro because I'm using an event procedure instead

I've inserted PrspDemoChangeDate = Date in the code before and after Allen's. I get a msg though that says the DoMenuItem action was cancelled. Can anyone please help me with this

Also, while I'm at it. Is there a way to do a query that will provide me just the changes that were made to a specific record out of Allen's code. I see it provided the before and after and list the changes but I only want to look at those fields that were actually changed

Much appreciated.
 
We don't know what code it is that you put in place.

It seems to me you would want to update your timestamp on the before update
event. Tha't where I do mine.

have you tried...

PrspDemoChangeDate = Date()


Rick B


I've implemented Allen Browne's code and it works great. The problem I have
is in the after update command I had a macro that recorded the date the
record was changed. Now that I have that code I can't use that macro
because I'm using an event procedure instead.

I've inserted PrspDemoChangeDate = Date in the code before and after
Allen's. I get a msg though that says the DoMenuItem action was cancelled.
Can anyone please help me with this.

Also, while I'm at it. Is there a way to do a query that will provide me
just the changes that were made to a specific record out of Allen's code. I
see it provided the before and after and list the changes but I only want to
look at those fields that were actually changed.

Much appreciated.
 
I've implemented Allen Browne's code and it works great. The problem I have is in the after update command I had a macro that recorded the date the record was changed. Now that I have that code I can't use that macro because I'm using an event procedure instead.

I've inserted PrspDemoChangeDate = Date in the code before and after Allen's. I get a msg though that says the DoMenuItem action was cancelled. Can anyone please help me with this.

Also, while I'm at it. Is there a way to do a query that will provide me just the changes that were made to a specific record out of Allen's code. I see it provided the before and after and list the changes but I only want to look at those fields that were actually changed.

Much appreciated.
Click to expand...

Joe,
I noticed a previous post from you (about 45 minutes ago), in which
you have also started a new thread asking for help concerning an older
thread. It is not a reasonable expectation that someone will search
through dozens of old posts (going back who knows how far) to find out
what it is you are now referring to.

It is to your advantage to keep posts together in their relevant
threads. You will get more answers with better results as new
responders will be able to see from the other responses what worked or
what didn't work.
Other readers will also be able to make better sense out of the
replies and learn from them. That is the purpose of these news group.

To keep new posts within the original thread, click on the Reply to
Group (or Follow Up) button instead of the New Post button.
 
How would I fill in the rest of this syntex to add the system date to a field without impacting the rest of the of the command structure

Call AuditEditEnd("tbl_ProspectDemographics", "tbl_AudTmpProspectDemographics", "tbl_AudProspectDemographics", "PrspDemoID", Nz(Me!PrspDemoID, 0), bWasNewRecord

I've tried PrspDemoDateChange = date and that works fine. But in constuction with the rest of the code from Allen Brown it adds a 3rd entry in the log table

Thanks in advance
 
Back
Top