Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-access > #10968

Re: Auto Update Column on Record Update

Show all headers | View raw

<mflynn@scu.edu> wrote in message 
news:44c0029f-66d3-4ad3-997a-0c0ec0f9060d@googlegroups.com...
> Thanks all of you.  In forms I do have
> code in the AfterUpdate event to set the UpdateDate to Now().
> What I was looking for was more Ron's suggestion of something in the 
> backend that runs whenever a record is updated, but I don't know how to do 
> that.
>
> In my setup there's just a front and backend combined, a normal Access 
> .accdb file with the menus, code and data all together.  There's no 
> separate backend, such as SQL Server.
>
>
>

Do some reading on data macros, they are not hard to do.

PS: it is HIGHLY recommended to split your app into a front end and back 
end. 

Back to comp.databases.ms-access | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Auto Update Column on Record Update mflynn@scu.edu - 2015-07-23 11:47 -0700
  Re: Auto Update Column on Record Update Patrick Finucane <patrickfinucanetx@gmail.com> - 2015-07-24 06:09 -0700
    Re: Auto Update Column on Record Update Ulrich Möller <knobbi38@arcor.de> - 2015-07-24 22:00 +0200
  Re: Auto Update Column on Record Update "Ron Paii" <None@none.com> - 2015-07-27 07:47 -0500
    Re: Auto Update Column on Record Update mflynn@scu.edu - 2015-07-28 09:15 -0700
      Re: Auto Update Column on Record Update Ulrich Möller <knobbi38@arcor.de> - 2015-07-28 18:53 +0200
      Re: Auto Update Column on Record Update "Ron Paii" <None@none.com> - 2015-07-29 07:59 -0500
        Re: Auto Update Column on Record Update mflynn@scu.edu - 2015-07-30 09:16 -0700

csiph-web