Search results

[Mlink] = "#\comps\pdf\" & [Msample] & ".pdf#" Msample data looks like this: 12345.SPA, so the above results is: \comps\pdf\12345.SPA.pdf How can I remove the .SPA? So it looks like \comps\pdf\12345.pdf in vba.

ok

Because I just want to make sure the syntax is correct. Easy to miss something and not have it work. That's why I'm asking.

Can you show me how that would look? Thanks.

Could you show me exactly how that would look? Thanks.

I'm using the following code to lookup if a number already exists. Works fine. I would like it to search in three other fields as well. Msamplenumber2, Msamplenumber3, Msamplenumber4 So when it does a lookup, it would look in all four fields. How can I combine those extra three fields below...

(y)

The value for Msample is at the beginning of my code. That part works fine. I'm going to try below. If IsNull([Msample]) Then .Attachments.Add "\\Web\bass1\pdf\" & [Msample] & ".pdf" Else .Attachments.Add "\\Web\bass2\pdf\" & [Msample] & ".pdf"

No, if Msample is null then xxx.pdf else zzz.pdf

Thanks.

I'm using the following... .Attachments.Add "\\Web\bass\pdf\" & [Msample] & ".pdf" I would like to create an if statement for the attachment line. If IsNull([Msample]) Then .Attachments.Add "\\Web\bass1\pdf\" & [Msample] & ".pdf" Else .Attachments.Add "\\Web\bass2\pdf\" & [Msample] & ".pdf"...

thought I did. Works now. Thanks!

Got it.

yes

Yes

Something like this... [Mlink4] = Replace([Mlink1],"normal","custom")

this seems to keep the format. In a query. How can I convert that to vba for a command button? Expr: Replace([Mlink1],"normal","custom")

Sorry... yes, I was simply replacing "normal" with "custom" \\server\testing\normal\12345.pdf file:///\\server\testing\custom\.pdf (after replace)

I'm working with a hyperlink field. I know they can be tricky. I'm trying to do a find and replace but it changes the format? In the past, I had to export to excel but wondering if a better way exists. \\server\testing\custom\12345.pdf file:///\\server\testing\custom\.pdf (after replace)

Thanks