Search results for query: *

Thanks for the reply. Actually I solved the problem - it was that the query I was using for the report did not have the "visible" checkbox marked for my UserID field. The query worked OK on its own, but it needed this field to be visible before the report filter would see it. Thanks again John

Dear knowledgeable ones. I have a form that uses the ActiveX control DTpicker. At the moment I can read the date that the user selects and base some code on it. However what I want to do is set the date to todays date when the form loads. Should be no problem - especially when there are many...

I may have just solved the problem - i had the field that I was trying to filter by selected to be not shown. Now that I "show" this data in the query the WhereCrit seems to work. Thanks for your help anyway John

I just tried this change but I still get the same. After pressing my report button a pop-up appears asking me to enter the parameter value UserID. Even if I enter a value the form opens with all users data displayed. If I enter the userID as a criteria in the Query that the form is based upon...

I have been trying to use user entered selections on a form to pick the data printed on a report. As far as I can see I have followed the help files and help given to 2 previous threads in this forum but am still having problems. my code: WhereCrit = "T_BookHrs.UserID= " &...

I have been trying to do a very similar thing, and it never seems to work - what am I doing wrong? my code: WhereCrit = "T_BookHrs.UserID= " & Forms!F_BookHrs!UserID_TB stDocName = "R_BookedHrs" DoCmd.OpenReport stDocName, acViewPreview,,WhereCrit In the Watches window I get WhereCrit =...

Tony, Thanks a lot - this works fine. johnbucks

Dear PHV If what you mean by a private procedure is that it is actioned on the AfterUpdate event of a textbox called "Selected_equipment", then yes. If this is the problem how do I make my procedure more global so that my subform procedure can call it - do I do it on the form level or must I...

Hi SanAntonioSpur Fan and TonyJollans I am trying to do the same basic thing as discussed in this thread, but with my code: Call Forms!Equipment.Selected_Equipment_AfterUpdate I keep getting an error message on compiling "Compile error - wanting . or (" I am trying to call procedure...