+ Reply to Thread
Results 1 to 2 of 2

Adding date and time

  1. #1
    Registered User
    Join Date
    05-19-2015
    Location
    aycliffe uk
    MS-Off Ver
    2010
    Posts
    24

    Adding date and time

    Hi guys

    I have made a simple database which allows people at work to fill in text box with a part number and it retrieves all information about that part from a table. This all works fine but what I also would like to do is record the number the person is inputting(searching for ) with a date and time in a separate table so I can look at that data .Would it be better using a macro or code? I am still new to this so any help is much appreciated

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Adding date and time

    It sounds like you already have code to do the search. So it would be a matter of updating that code to also capture the date/time, and to write the search term plus the date/time to a table.

    Please attach your file, and tell us where you would like the table to go.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Adding time (more than 24 hours) to date time stamp
    By sidapt in forum Excel General
    Replies: 6
    Last Post: 01-06-2014, 04:08 AM
  2. Adding elapsed time to date/time format over 24h
    By KimSenger in forum Excel General
    Replies: 1
    Last Post: 04-02-2013, 06:28 AM
  3. Adding Time to a Date & Time (using workdays only)
    By Buks in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-18-2009, 10:31 AM
  4. Adding Date and Time to Yield Date
    By fengfeng in forum Excel General
    Replies: 1
    Last Post: 01-05-2009, 02:11 PM
  5. [SOLVED] Adding time to date-time formatted cell
    By tawtrey(remove this )@pacificfoods.com in forum Excel General
    Replies: 4
    Last Post: 08-12-2005, 06:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1