Results 1 to 6 of 6
  1. #1
    tehachapi75 is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Feb 2019
    Posts
    3

    Attaching a hyperlink to a dated field.

    Hello,



    I was wondering if there is any way to attach a hyperlink to a date/time field in an access datasheet. I am working on a submittal log, and there are many date/time fields that signify the date that a plan was submitted to the company and when the company sent the plan back out. Each date signifies a different plan that has either been submitted or sent out. But, the submitted and the sent out date/time fields are also part of calculated expressions for other fields, so I cannot just create a hyperlinked field and type in the dates. Also, if I were to just add another hyperlink field for each of the date/time fields, I would need to add another 12 fields to the table.

    Any help would be much appreciated.

    Thank you

  2. #2
    Gicu's Avatar
    Gicu is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    You can add code in the OnClick (or better in the OnDoubleClick) event of the textbox control showing the date(s) to make it open a form, report, file etc. Is that what you mean?

    Cheers,
    Vlad

  3. #3
    tehachapi75 is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Feb 2019
    Posts
    3
    For the record, I am a novice at Access, so I apologize for that knowing much in advance.
    If I add the right code to the OnClick event, would I be transferred to the corresponding plan that the field is dating? If so, what would be the right code for that?

    Thank you for the quick response,

    Niko

  4. #4
    Gicu's Avatar
    Gicu is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    What is the corresponding plan? Is it an Access report, an external file stored somewhere on your computer...

  5. #5
    tehachapi75 is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Feb 2019
    Posts
    3
    Yes, it is.

  6. #6
    Gicu's Avatar
    Gicu is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    Yes it is a report or yes it is a file?

    For report you simply add Docmd.OpenReport ......(https://docs.microsoft.com/en-us/off...cmd.openreport).
    If it is an external file you need to open it using Shellexe - you will need the full name and path - https://www.devhut.net/2010/06/12/ms...a-open-a-file/

    Cheers,
    Vlad

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

Similar Threads

  1. Replies: 8
    Last Post: 03-29-2017, 09:07 AM
  2. Most Recently Dated Record
    By sc6678 in forum Access
    Replies: 2
    Last Post: 12-20-2016, 04:07 PM
  3. VBA to create dated backup file
    By phbryan in forum Programming
    Replies: 2
    Last Post: 03-30-2015, 04:51 PM
  4. Schedule a Future Dated Transaction
    By burrina in forum Forms
    Replies: 21
    Last Post: 12-27-2012, 06:16 PM
  5. Replies: 1
    Last Post: 04-25-2012, 12:36 PM

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