1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

[SOLVED] Automatic assignment of date to database

Discussion in 'Business Applications' started by LinuxGold, Oct 10, 2003.

Thread Status:
Not open for further replies.
Advertisement
  1. LinuxGold

    LinuxGold Thread Starter

    Joined:
    Oct 10, 2003
    Messages:
    109
    Hi all. I'm new in here. I am currently working on access97, and am having hard time trying to have Access97 automatically add current date/time to database, that way the operator wouldn't have to add date every time. How can I do this simple trick? I've searched in Access97's help assistant and that paperclip didn't meet my specific need. Thanks for your help in advance.


    Scott
     
  2. XL Guru

    XL Guru

    Joined:
    Aug 30, 2003
    Messages:
    2,702
    1 - takes a little digging in Help.
    2 - I have Access 2K but it'll probably work.

    In Design Mode,
    Field Name = eg: Input Date
    Data Type = Date/Type

    Under Field Properties (General), Default Value = Date()
    Format to your requirements.

    Rgds,
    Andy
     
  3. LinuxGold

    LinuxGold Thread Starter

    Joined:
    Oct 10, 2003
    Messages:
    109
    Thanks. I tried something to that approximation to no avail. You described them better than that help that I've tried to dig in. Appreciate it.

    Hmm, how do I close this thread since I'm new and all that?
     
  4. XL Guru

    XL Guru

    Joined:
    Aug 30, 2003
    Messages:
    2,702
    >> Hmm, how do I close this thread ...

    ??? But you're not finished.

    I don't really do Access but this seems fairly straightfoward. If you like I could send you a sample file (or vice versa).

    Rgds,
    Andy
     
  5. LinuxGold

    LinuxGold Thread Starter

    Joined:
    Oct 10, 2003
    Messages:
    109
    I got it working on my access97 with your instructions. It worked like a beauty.
     
  6. XL Guru

    XL Guru

    Joined:
    Aug 30, 2003
    Messages:
    2,702
    Sorry, completely misread your message.

    I think to close a post you mark it as (Solved) -- browse back a bit & check. I guess this is something only the original poster can do, somehow.

    Rgds,
    Andy
     
  7. LinuxGold

    LinuxGold Thread Starter

    Joined:
    Oct 10, 2003
    Messages:
    109
    Ah, thanks. I'll figure it out. =)
     
  8. CastleHeart

    CastleHeart

    Joined:
    May 4, 2002
    Messages:
    743
    once you post and are returned to your thread - go up in the top right and hit this ^ report button and say SOLVED. A mod will take it from there.

    - C







    so Andy.....who's the cat?
     
  9. XL Guru

    XL Guru

    Joined:
    Aug 30, 2003
    Messages:
    2,702
    >> hit this ^ report button ...

    Thanks for covering C-H. We adopted the cat years ago, he'd been living in a skip ; scrubbed up quite well but psychologically scarred. He can't go from one end of the room to t'other via the floor, he has to go via available furniture/people. Like the Python "Twin Peaks of Mt. Kilimanjaro" sketch, you must've seen it.

    Rgds,
    Andy
     
  10. LinuxGold

    LinuxGold Thread Starter

    Joined:
    Oct 10, 2003
    Messages:
    109
    Thanks! I just issued the "solved" in report.
     
  11. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/171080

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice