Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2017
    Posts
    12

    Lightbulb Could I use a Macro to edit a link upon action?

    I store projects on a server and have made it so that the database links directly to Fee Proposals within the project folders.


    Once a project is complete, it is moved to a different place on the same server and this is shown on the database with a tick box.

    Could it be possible that upon ticking this box, the hyperlink changes itself? The only thing I'd need to change would be the drive letter and the rest of the path would be the same.

    Furthermore, we currently have two offices with two servers. So 2 drives with live projects and 2 with closed. If the above is doable, could I then add a variation, so if it's on drive A: it automatically becomes B: wheras C: always becomes D:?

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    Code:
    sub chkBox_afterupdate()
    on error resume next
    VChr=left(txtPath,1)
    vRest =mid(txtPath,2)
    
    Select case lcase(vChr)
       Case "a"
          TxtPath ="b" & vRest
       Case "c"
          TxtPath ="d" & vRest 
    end select
    end sub

  3. #3
    Join Date
    Mar 2017
    Posts
    12
    love this forum. I'll test over the weekend and then come back to confirm.

    Thank you

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

Similar Threads

  1. Replies: 5
    Last Post: 09-19-2016, 01:35 PM
  2. Using the SendKeys action in a Macro
    By john134 in forum Programming
    Replies: 5
    Last Post: 05-27-2014, 01:54 PM
  3. Replies: 7
    Last Post: 08-28-2013, 02:30 AM
  4. PrintOut Macro Action
    By EHittner in forum Access
    Replies: 1
    Last Post: 09-22-2011, 01:27 AM
  5. Macro Action
    By Bakar in forum Forms
    Replies: 1
    Last Post: 01-05-2011, 12:38 PM

Tags for this Thread

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