Results 1 to 3 of 3
  1. #1
    denknee is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Oct 2014
    Posts
    2

    Convert to DD:HH:MM:SS

    Reference https://www.accessforums.net/access/...-ss-24130.html

    I am a novice so please excuse my ignorance, where and how do I implement this code into my database.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,930
    The referenced thread shows a VBA custom function, probably placed in a general code module. Then the function can be called from mostly anywhere in the database - a query or textbox or in other VBA code.

    To start learning about programming in Access, review https://support.office.com/en-US/Art...rs=en-US&ad=US
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    denknee is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Oct 2014
    Posts
    2
    Thanks for your quick reply and for pointing me in the right direction will have a read and hopefully make some sense of it.

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

Similar Threads

  1. convert zero to NULL
    By deso in forum Queries
    Replies: 7
    Last Post: 01-24-2013, 11:19 PM
  2. Convert seconds to DD:HH:MM:SS
    By rockcliff15 in forum Access
    Replies: 6
    Last Post: 04-23-2012, 01:27 PM
  3. Can you convert .mdb to .wdb??
    By DeeMax45 in forum Access
    Replies: 2
    Last Post: 01-22-2012, 06:11 PM
  4. Need help to convert data.
    By Karan in forum Access
    Replies: 2
    Last Post: 04-30-2011, 12:35 PM
  5. How to convert a db to txt
    By Joliet_Jake in forum Import/Export Data
    Replies: 5
    Last Post: 11-01-2010, 12:07 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