Search results for query: *

Thanks for your quick response PHV, I have read the FAQ. At present the SQL code of the RecordSource property of each form is: Form A (the form that is being filtered); SELECT [T- GCS, Job Planner].Network, [T- GCS, Job Planner].Depot, [T- GCS, Job Planner].[Job Number], [T- GCS, Job...

Please could someone else help me out with this enquiry? I thought it was going to be a simple exercise. I simply don't know how to implement what Remou suggested and I'm not even sure if it's exactly what I'm looking for. If what I've already said in my previous posts doesn't make sense or...

Would anyone be able to help me with this filter query? As described by Remou above; I'm not sure how to apply the below VBA code to the results of a query that can be used to filter two seperate forms. My currant VBS filter: Private Sub ApplyFilter_Click() Dim strFilter As String...

Thanks again, Remou. I'm not sure what detail I can provide that'll help. In this example, a simple form has filtered down a simple table to show a subset of the records. While this original form is open I want to open a second form that "looks" at the original one to know which records it is...

Thanks for your quick reply Remou. I'm sorry, but I'm not quite sure what you mean with your code. Do I adapt that and put it in the SQL view of the query builder for the Form's Record Source? Or use part of it in the Filter box on the Form's property window? Or somehow use it in VBA activated...

Using Microsoft Access 2003; With reference to my previous post: http://www.tek-tips.com/viewthread.cfm?qid=1461195&page=1 After using a combination of filters on a form I am wanting a seperate form to open and use the primary key from the filtered list as the foreign key for the new list...

Thanks for your help and quick response PHV, that code works like a treat! ProgramError, I think the quote marks still appear in the filter string so that it matches the default "All" text in each combo box. If a combo is set to "All" it shouldn't filter that particular column. I believe the...

I have managed to get further with the query by removing the ' from the Yes/No combo values And so now have a new problem! I now want the Quoted field, in Date format, to be filtered for blanks or non-blanks, but cannot get it to work. My Code: Private Sub ApplyFilter_Click() Dim strFilter...

Also, if it helps: Quoted, Accepted and Completed are the form's fields Quoted is of Date format Accepted and Completed are of Yes/No format QuotedFilter, AcceptedFilter and CompletedFilter are all unbound combo boxes that have a pre-made list of choices.

Using Access 2003; I'm trying to filter a simple continuous form using selections from various combo boxes. It is not using any sub-forms. Using the below code I am getting run time error '2001' when any one of the combo boxes doesn't equal "All". I'm aware that this error is to do with the...