Search results for query: *

I found it. I didn't know about the function 'InStr'. I just looped through all possible values, checking if each value was InStr of the entire selected set/row/string, and set selected to true if it was. Thanks nobody!

I am using a listbox with extended multiselect listbox (values coming from a seperate 1 field table). I have read through the forums and worked out how to save the multiple values to my table, and that is working fine. My problem is that i now want to have those values selected on the listbox...

Aha thankyou! I had just assumed that it was a problem with the way i was calling the function, and never thought it was actually getting inside the function it was calling. The problem was that i was referencing 'id' in the DLookup functions and the subform didn't know what id was. Changing id...

in Form: frmFollowUp Public Sub Form_Open(Cancel As Integer) Me!histCount = DLookup("Count(*)", "tblFollowUp", "[student_id] = id") Me!histCompletedCount = DLookup("Count(*)", "tblFollowUp", "[student_id] = id and [completed] =...

How can I execute a function from the Parent module of a subform? What I want to do is set the 'On_dirty' event of the subform to run a function within the parent. I tried Forms!frmStudents.Form_Open (0) and Me.Parent.Form_Open(0) but they both give: Runtime error 2471 - 'The object doesn't...

Ok I tried that but nothing showed up. If I manually set the Filter property in my code (ie Reports!Report1.Filter = whereStr) it displays, but using wherecondition shows nothing. I also added - MsgBox Reports!Report1.Filter after DoCmd.OpenReport and that displays an empty box if I'm using...

I don't think it is the If's thats that issue, because even doing: DoCmd.OpenReport stDocName, acPreview, , " 0 = 1" returns all rows from the query/report

I had put the 2nd stDocName in while trying to get this thing to work. It makes no difference if I remove it. I just tried putting the clauses in to the Filter property and it works as it should. I then tried updating the .Filter property from my code with whereStr and it also works as it...

Hi, I'm using access2000 to create a dynamic report based on inputs from a form. Both the query and report do not reference the form in any way. I want to be able to select only certain rows from the query, so I thought I would use the WhereCondition field in DoCmd.OpenReport, but this seems to...