user defined linked table refresh

C

carrie schmid

how can I change to following to reflect the path that I have stored in a
table named "location", field named "server"

extracted from (rogersaccesslibrary)

Function getpath(FileName As String) As String
getpath = Mid(FileName, InStrRev(FileName, "\") + 1)
End Function

I would like the user to be able to use a form to input the link and have it
stored in a table. Any help would be appreciated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

link all tables but one using VBA 1
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
Word macro that can call cells out of Excel for a find and replace 0
Doughnut Chart linked with the slicer in the pivot table 0
Re Linking Tables 2
Extract Text in braquet and list of terms from 2 Docs 3
Modify Linked SQL table in Acess via VBA code 7
Export single rows from a query to excel using a template 1

Top