Report filtering example!

[Jar80]

Is there any example about filtering report, i mean that when i insert ex. date in the date field and press button then it search data from db in that information?

 

[KenReay]

Hi

At its most simple

Base your report on a query

In the query, in the date column put a criteria of [Please Enter Date]

This can be made more user friendly by using a form to ask the user for the date paramter, on the form put a button to run the report, change the criteria of the query to the syntax Forms!MyForm!Mydate (using your own form and control names of course in place of My..)

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[Jar80]

Why i get error (Database engine could not lock table "table name" because is it already in use by another person or process.)

I haven´t try your example but i think that will be working, thank you!

 

[KenReay]

You are probably getting the error because (say) you have the tabel open in design view in one window, and you are trying to update teh atble in another window, or some similar conflict

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[Jar80]

I have open only that form which contains filtering fields and one combobox.

All other fields works fine but that combobox informs that error.

Combobox contains company name, so when i select it and press button which contains macro (open report) then it throws that error.

Report is maded using query. Query contains all filters which are connected in the filtering form fields.

 

[KenReay]

Hi

Try this

Comment out the code behind the combo box which runs the report

Open the form and select a value in the combo box, does it work?

With the form still open, run the report from the database window, does it work?

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[Jar80]

Combobox will not run the report only button does.

 

[Jar80]

When I open report straight it works ok(but of course it doesnt show any information related to database, because the data comes from the filtering form)
Then when I open the form that it reports to be open, after that I open the report then it throws this error msg (Database engine could not lock table "table name" because is it already in use by another person or process)

 

[KenReay]

Hi

OK, this suggests you are doing something in the form to lock the table would you agree?

Look and see what code you have in the form

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[Jar80]

I don't know because only that combobox searching the records in the that form which throws the error.

The form not contains any code!