Expression Help

[gambitbt]

Good Afternoon,

I am trying to generate a link to a folder based on two fields in my datasheet.

The current expression I have is:

"=(\\ "& "[TOMCAT SERVER Name] "&" \d$\eClinicalWorks\tomcat6_ "& "[Practice Code] "&" \webapp\mobiledoc\jsp\catalog\xml)

When I go to view it, it looks correct but when I click on it, it does not open my folder. I have made the field hyperlink in my table and checked to make sure the properties was Hyperlink always.

I used the formula that I used in Excel with some slight changes.

=IF(U2<>"",HYPERLINK("\\"&U2&"\d$\eClinicalWorks\tomcat6_"&G2&"\webapps\mobiledoc\jsp\catalog\xml"), "no server")

Is there something I missing? Can someone help me please?

Thanks in advance.

 

[GinaWhipp]

I see quite a few spaces and misplaced quotation marks that you probably don't have. So instead of retyping what you have please copy/paste exactly what you are using, it will be easier to troubleshoot.

 

[gambitbt]

Gina, that is copied and pasted from what I am using.

 

[CJ_London]

without knowing the full context around your code, suggest try removing the quotation marks from around your field or control names - you also seem to have some spurious spaces. Try

"=(\\" & [TOMCAT SERVER Name] & "\d$\eClinicalWorks\tomcat6_" & [Practice Code] & "\webapp\mobiledoc\jsp\catalog\xml)"

 

[gambitbt]

CJ_London...I tried that and it gave me #Name?

 

[gambitbt]

CJ_London...I tried that and it gave me #Name?

 

[CJ_London]

Without knowing the context, it could be one or more of many things.
All you have said is what the current expression is, but not where it is or how you are using it. you refer to fields (which are in tables) but you effectively have a calculation, which you use in forms

 

[gambitbt]

Ok in my table I have two fields, Tomcat Server name and Practice Code. I am trying to use an expression to pull the information from those two fields into a form called frmHostingServices, where the user can click on the file path to open the folder. The expression is producing the file path, but when I click on it, it doesn't open it.

So the expression:
=("\\" & [TOMCAT SERVER Name] & "\d$\eCli\tomcat9_" & [Practice Code] & "\webapp\mobiledoc\jsp\catalog\xml") is returning

\\eclinweb\d$\eClin\tomcat9_CLCC\webapp\mobiledoc\jsp\catalog\xml
which is correct. But just doesn't open. Had to take out the hyperlink here.
Is this what you are asking for?