Im not very skilled at Access and i have created a database to use at work. I want my staff to be able to use it also but the are more clueless than i am. I am able to create reports, but what i want to do is to make the report generate on command through a switchboard for specific records. All i am able to do is create the report and it tells me about every record. How do i make it breakdown by date or by customer or whatever and how do i make it a clickable item on a switchboard so that my staff can use it too? Please Help Me! Louis.
Reports on Switchboard
- Thread starter louis
- Start date
David R
I know a few things...
- Local time
- Yesterday, 23:10
- Joined
- Oct 23, 2001
- Messages
- 2,632
Look up 'parameter query' in Access help. It should get you going on what you're trying to do, i.e. dynamically limit the records your report views.
There are other options, such as creating a form where you input parameters and then pass them to a form. Using the search function on this Forum (Reports) and inputting 'parameter form' will get you rolling on that if you'd like to tackle it.
If you have specific problems later with implementing this, post back. I'm not trying to put you off, but being able to work yourself through something is extremely satisfying, I find.
Hope that helps,
David R
There are other options, such as creating a form where you input parameters and then pass them to a form. Using the search function on this Forum (Reports) and inputting 'parameter form' will get you rolling on that if you'd like to tackle it.
If you have specific problems later with implementing this, post back. I'm not trying to put you off, but being able to work yourself through something is extremely satisfying, I find.
Hope that helps,
David R
Thanks for the reply but i'm having new problems. I already started to solve the problem on my own and your right it is extremely satisfying but i now have a new problem. I've created a form for the criteria of the query. i've created a Report based on the query. I've created a macro so that when the report is run it will first open the form and an "OK" box to execute the report. The problem is that on the form, i have a list box of all customers from my customer table (Names only), when a customer is selected you click "OK" and the report is run based on the query. In criteria i wrote "[Forms]![Report by Customer]![Customer Name]" which is the field name of the list box on the form. But i get a blank report! when i run it without this criteria it lists all customer details. Although everything runs smoothly it does not seem to recognise the information in the list box? Any ideas as i'm all out. Thanks!
