Results 1 to 2 of 2

Thread: Date time Stamp

  1. #1
    Guest
    I'm developing an application in Access 2000. I need two fields one with date and one with time. These fields our to supposed date time stamp the transaction. What would be the easiest way to do this in access 2000.

    Please hellp me

    Thanks

    Ken

  2. #2
    Lively Member
    Join Date
    Jun 2000
    Posts
    74
    well i don't know if this is the best/efficient way to do it, I'm still learning VB...

    if you're using DAO to access your database, this is what I do to add the date and time, assuming rs is your recordset and date and time is your fields in the table

    Code:
    with rs
       .Add
       ![Date] = Date
       ![Time] = Time
       .Update
       .Bookmark = .LastModified
    end with
    the date and time functions return the current system's date and time respectively

    then you can use the format function to get the desired format

    hope this helps

    [Edited by gin on 11-16-2000 at 09:50 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
  •  



Click Here to Expand Forum to Full Width