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...

Ok, First I forgot to tell you that I'm pretty new in database at all and I'm using Access 2000. Is there any way to solve this without too complex coding coding .... My problem is like this.. I have tree tables: organization->contact person->project I have a form based on a query (this...

That works fine if I select records one by one. How can I select all of them (or erase all marks) in the same time?

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...

Actually I got error 13 . That happens only in Access 2000 not in 97. I found some discussions about that but i need some time to figure that out and make corrections.......... Thank you very much

Access 2000

Could you please write the code how to do that (I know programming but not VBA sintax......yet) Thank you

I made one change and now my button opens result form with controls in it which are empty (which is better than before) Now I just need a way to check if my result form is empty to get message again...... Private Sub cmdFindRecords_Click() Dim strFilter As String strFilter = vbNullString...

Thanks for spaces around AND ...... But the main thing is still not working. When I open my search form and don't choose anythin as a criteria I get the message, but if I put criteria and there is no mathchig records I get empty result form again (without any controls on it).......??? :(

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...