Search results
-
K
Query Issue
I have a query that returns the following records. I would like it to show Field1, Field2, Field3 (no records where they are all blank and records where a value is in either field1 and/or field2 and/or field3) I'm using the query wizard but can't seem to figure out the correct sequence. -
K
VBA Print Error
But this does not give me the opportunity to select a printer? -
K
VBA Print Error
The report is already open to specific record, not sure that works here. -
K
VBA Print Error
And it's happening on a few other workstations too. Windows update? Virus protection update? -
K
VBA Print Error
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... -
K
combine fields
this is what I tried in a command button strNewConcantenatedstring = "www.abc.com/" & Mid([Text99], InStrRev([Mlink], "\") - 1) Nothing happens... -
K
combine fields
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. -
K
combine fields
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" -
K
combine fields
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" -
K
Or Statement
It just didn't seem correct but yes, it's just what I'm looking for. Thank You! -
K
Or Statement
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