Search results

I thought I could find a simple solution...

this is what I tried in a command button strNewConcantenatedstring = "www.abc.com/" & Mid([Text99], InStrRev([Mlink], "\") - 1) Nothing happens...

Yes, that's what I'm trying do. The field that has the "\files\pdf\abc.pdf" is Mlink and the unbound field is Text95. So, what do I replace for YourFieldNameGoesHere. What goes where? I'm putting the code in a command button.

I just want to use the value after the last "\" which is the abc.pdf value Then I could use something like this: ="www.abc.com/" & "abc.pdf"

I don't follow?

I have a field on a form that has a value of "\files\pdf\abc.pdf How can I create an unbound field that takes just the "abc.pdf" value and combines it. I want the new field value to look like this: www.abc.com/abc.pdf ="www.abc.com/" & "abc.pdf"

It just didn't seem correct but yes, it's just what I'm looking for. Thank You!

Would about this part of the code?

Perfect!

How would the code look with that added?

I'm using the following. Report ID: IIf([Msamplenumber1] Like "*H*" Or [Msamplenumber2] Like "*H*","In Progress",[Mreportid]) How can I add if Mreportid is null, then "Empty" to the above statement? Thanks

Yes, that did it. Thanks!

Here is what's in the command button.

When I click the button manually, it works. It opens another form. When I use Command5_Click I get an error.

What is the vba code for: afterupdate, goto a command button and click it?

Thank You!

Can you explain what each part is doing?

This is perfect. Just what I was looking for. Thanks!

How would I combine these statements? Default for image1 is not visible. If Me.Mdid = "ABC123" Then Me.image1.Visible = True Else Me.image1.Visible = False If Me.Mdid = "DEF123" Then Me.image1.Visible = True Else Me.image1.Visible = False If Me.Mdid = "GHI123" Then Me.image1.Visible = True...