Search results for query: *

Hey guys, I run the below code and get the error "3544: Partial string matching requires character operands" Not sure why since both fields are character fields. I tried to Cast to ensure they are character. Any help would be appreciated. Select * From BA_HARD_HOLD BA Left Join...

Hi, I built a SQL script which I am calling at the Fastload DOS prompt however I am getting an error message that my UserID, Password or Account is Invalid. I am using the same User Id and Password I use to logon on to Teradata SQL Assistant. Is there another setting I need to change to get...

Hi all, I am having a problem with the following Excel formula:WS_2.Range("BJ" & CStr(Temp_Cell)).FormulaArray = "=SUM((DATE(YEAR('SOURCE TM DATA'!$AJ$2:$AJ$" & LastRow & " ),MONTH('SOURCE TM DATA'!$AJ$2:$AJ$" & LastRow & " ),1)<=DATEVALUE(""1/""&LEFT(L" & CStr(Temp_Cell) &...

Actually PHV, I had to change it to the ON MOUSE DOWN event of the combo box. When I used the On Current event for the form, it did not show the filtered record. Thanks again for your help.

That did the trick!!! Thank you very much PHV.

It does not work if I put it into the AfterUpdate event. I am not seeing an after Load event for the form...but I am thinking it might work if I can get rid of the filter once the found record has already been displayed.

Private Sub VIEW_Click() Dim stDocName As String Dim strFilter As String stDocName = "FORENSIC_OBSERVATION" strFilter = "[CASE_FILE_ID] = '" & [Forms]![REVIEW_FORM]![qry_FOR_OBSERVATIONS subform].[Form]![CASE_FILE_ID] & "' And [RE_OBSERVATION] = " &...

Just tried and it did not make a difference. Still having the same issue. I have a question for you PHV. Is the problem that the underlying source for the form being filtered and therefore the combo box is unable to find the record that matches the selection?

Would it matter, since Forms!FORENSIC_OBSERVATION!CASE_FILE_ID gets its value from Forms!Review_form!CASE_FILE_ID? I have no idea what difference it would cause?

Hi PHV. the following is the SQL statement in the rowsource property of the combo box. SELECT RE_RECOVERIES.RE_OBSERVATION, RE_RECOVERIES.CASE_FILE_ID FROM RE_RECOVERIES WHERE (((RE_RECOVERIES.CASE_FILE_ID)=[Forms]![FORENSIC_OBSERVATION]![CASE_FILE_ID])); When the review form is open, I have a...

Hi all, I have a Review form that has a sub-form which lists all observations made for that particular review. I have a "VIEW" option for each record in the subform that allows you to open the Observation form and view or modify the selected observation. The "VIEW" option opens the observation...

Ok, but what if the user selects another combination of criteria. In other words, I need the user to enter any combination and then have the query run based on which criteria is selected.

I have a form on which the user can select any one or combination of criteria. Based on the combination entered, I would like to query my table. I am thinking this can be done in code by using if...then..else. However I am having difficulty writing an AND clause. Can someone tell me if this...