Search results

The report is already open to specific record, not sure that works here.

And it's happening on a few other workstations too. Windows update? Virus protection update?

Yes, I do have a default printer.

I have a print button on a report. Just recently, I'm getting an error when I click the button. When I click it a second time, it prints just fine. Anyone experience anything like this? This just starting happening in the last week or so...

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?