Search results

Hi I have a search form. On that form I have a button which I press and get result form. Syntax is like this: DoCmd.OpenForm "ResultForm", , , strFilter, acFormReadOnly When I do this search once that's fine. But when I change criteria and press the button again it tells me that my table is...

Hi After I make filter and apply it on a ResultForm (which represent query ) I can see results like this: DoCmd.OpenForm "ResultForm", , , strFilter, acFormReadOnly or I can print report like this: DoCmd.OpenReport "MainReportForSearch", acViewPreview, , strFilter My problem is how can...

Hi, I have a query which contains three tables together: projects, contact persons and organizations. I use that query for entering information for projects (some of the fields for contact person and organization are there but I don't change them). When I want to filter data based on...

Hi, I have a small database which connects projects, organizations and contact persons for organizations. My search for projects is based on many criterias. For example I need a project with scope 1, priority status 2 and it is approved, or funding year is 2002-2003 , scope is 3 and...