Results 1 to 2 of 2
  1. #1
    jasonf is offline Novice
    Windows 7 Access 2007
    Join Date
    Jan 2010
    Posts
    1

    Automatically general date when another field is written to

    Hi, apologies if this is in the wrong section.



    I've created a field and set the type to general date.

    What I want to do is have access insert the date when a certain other field is written to. The other field is called notice. When I have written my message in this field, I want access to get the date andtime from the clock and insert it in the date field. I want to do this as in the future I wish to write to the notice field from a website (connected to database via odbc), and when that data is added, I want access to add the additional info to the date field.

    Is this possible?

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2007
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,923
    There are no triggers in Access so you would have to do it yourself. This is best done in a form. I don't know about doing it from a WebSite.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 01-26-2010, 10:36 PM
  2. Replies: 4
    Last Post: 01-19-2010, 05:36 AM
  3. Automatically Reduce Field Size
    By Rebecca in forum Access
    Replies: 4
    Last Post: 01-06-2010, 10:14 PM
  4. General question
    By dollygg in forum Access
    Replies: 7
    Last Post: 12-11-2009, 05:13 PM
  5. General Database question
    By xyzz in forum Access
    Replies: 3
    Last Post: 05-20-2009, 10:28 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums