var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Specify path in RunApp Macro with DLookUp
I want to use a RunApp macro to open a Windows Explorer for a folder that relates to the database item I am viewing on the form. The syntax that I have that doesn't work is:
explorer \\server address\ & DLookUp("[Serial]", "[Cases]", "[CaseID] = Form![CaseID]")
If I take away the DLookUp portion of the path the macro works fine but I want to go directly to the folder on my server that has all the files pertaining to the "CaseID".
Dim case_id As Integer
Dim path As String
case_id = DLookUp("[Serial]", "[Cases]", "[CaseID] =" & Form![CaseID])
path = "explorer \\server address\" & case_id
Thanks for your help. Unfortunately, I am an idiot when it comes to VBA, that is why I use Macros. Do you know how to write the syntax as an argument to the RunApp Macro?
Note the bits highlighted above in red; swap the case_id variable with the dlookup and job's a good'un