Search results

Mark this sounds great!! Just a little beyond my skill set to adapt to my project. I do get the concept, but to adapt it, I'm not sure I would be able to. So how would I go about implementing this? I know I would change "tTestData " to my query name (tqryLedger_Detail_SEARCH), and change...

strsearch = "Select * from qryLedger_Detail_SEARCH WHERE DESCRIPTION like ""*" _ & strText & "*"" or VOUCHER like ""*" _ & strText & "*"" or POLICY like ""*" _ & strText & "*"" or ACCOUNT_NUMBER like ""*" _ & strText & "*"" or NOTES like ""*" _...

I have a continuous form that is a search form. A user can input any criteria (text before this question) and the record set of the form would be updated with anything LIKE what was typed into the search box. This all works fine. What I am now trying to accomplish is to add Integers to the...

Gasman, That was it exactly, Thank you for your help!!

That line is commented out

I have a report with a series of command buttons. One of which outputs the report to a PDF. This works fine. What I am trying to accomplish is to move the position of the reports title textbox from one position to another, and then back again. Here is what I have for code: Private Sub...

Also, I had basically this same code working yesterday, but I put it in the On Load event, what would be the difference between that and the On Current?

This code is giving me a run time error 3075: Syntax error (missing operator) in query expression [VOUCHER_NUMBER] = '? Not sure why, looks exactly like the formula (which is working)?

MarkK, On the long side, the text length is 273 characters. (And in this instance, the text box displays it all) And on the short size, the length is 7 characters, and the text box is throwing up the error. I've run into this error before, but in that case it was a text box name clash, I do...

Mark, Good question, the first three text boxes are hidden, and the 4th just makes sure that all the data in the 2 lookup text boxes are captured, and in a uniform format. What I mean is, if I just had the first two lookup boxes on top of each other, there would be a chance that some info may...

Good morning all, I have 4 unbound controls on a subform. The first control tests and strips away unwanted leading characters: Name: txtADJ_POLICY =Nz(IIf(Left([POLICY],1)="R",Mid([POLICY],3,Len([POLICY])),IIf(Left([POLICY],1)=0,Mid([POLICY],2,Len([POLICY])),[POLICY])),"") Name...

That is absolutely correct! Careless oversight in the formula construction, thank you very much for your help!

Good morning, I am trying to replace line breaks (carriage returns) from within a form control. Here is what I am currently trying without luck: =Nz(DLookUp(Replace(Replace("NOTES",Chr(13)," "),Chr(10)," "),"tblInvoiceLog","[VOUCHER_NUMBER]= " & [txtTEST] & ""),"") The DLookUp result is...

I couldn't agree more, the problem is that one table is a linked table, and I do not have ownership of it. Secondly, can you help me a little more with your suggestion. So I would put this function in the parent forms On Load event, or the subforms On Load event. Next, would I put (in my...

Good afternoon all, I am hoping someone can help me with the very beginnings of an idea. I am trying to test the value in a form control, [POLICY], to see if it begins with "R", "R0", or 0. If it contains any of these 3 variable, I want to strip the characters away, and leave the remainder...

Very good thought, how would I edit this code, so a vbYes answer would run the procedure?

I do not have a string variable NAMED "Date", my thought is the word "Date" in the line: If FormatDateTime(DMax("[PAY-DATE]", "qryTEMP_MONTH_TO_DATE"), vbShortDate) <> Date Then was basically using the Date() function. Am I incorrect in this thought? I was getting the Runtime error 13 before I...

Let me start by saying this procedure works the way I intend. My question is more of efficiency/elegance. Based on the code below, is this the most efficient way to accomplish this? Private Sub cmdDAILY_Click() 'Import the daily file from the "PARSE_" file 'Error handling On Error GoTo...

Based on all the responses I will keep what I have. But I really appreciate everyone's help. @Frothingslosh I will definitely try (and likely use) this function in the future, I'm sure! Thank you again

How would I call this function? When I was initially thinking about a better way, it resembled this. Although in my thought, it was an array of characters. But I would like to give this a try. In addition, (slightly off topic) is there a way to replace the word "AND" with a like break?