Search results

I see it now. Thanks!!

Thanks!

I'm using the following code. How to do I get the value "comps" to appear where test is? Because it's wrapped in the quotes, I'm getting just the word test. What am I doing wrong? Dim test As String If ([Mdid] = "COMP32145") Then test = "comps" [Mlink] = "#\test\pdf\" & [Mspectraid1] &...

need to remove the period and characters to the right.

[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")