473,322 Members | 1,690 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Reports based on a criteria chosen by the user

1
Version of Access 2003

I have designed a report based on a query which has a parameter built into it. The parameter asks you to enter an employee name and the report will then show you all the training records that belong to that particular employee.

The problem i am having is that you have to enter the employee name exactly how it is spelt in the table and other users do not have access to the tables therefore they sometimes find it difficult to view the employee's record they need.

Is there a way which i can get the users to select an employee from a combo box or list box and then view the report based on the name they have selected?

Any help given will be very much appreicated
Nov 22 '07 #1
1 1426
ADezii
8,834 Expert 8TB
Version of Access 2003

I have designed a report based on a query which has a parameter built into it. The parameter asks you to enter an employee name and the report will then show you all the training records that belong to that particular employee.

The problem i am having is that you have to enter the employee name exactly how it is spelt in the table and other users do not have access to the tables therefore they sometimes find it difficult to view the employee's record they need.

Is there a way which i can get the users to select an employee from a combo box or list box and then view the report based on the name they have selected?

Any help given will be very much appreicated
Yes there is, but first I'll need:
  1. The Table's Name containing the Employees information.
  2. The Employee's First Name, Last Name, and a Unique Identifier that points to a specific Employee in the Employee Table.
  3. The Name of the Report you wish to Open.
Nov 22 '07 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: neptune | last post by:
I have a query where each customer has an or . Sometimes both fields for a customer are populated, but if is null, then will be populated and vice versa. I have a form, , where I select a...
7
by: dog | last post by:
I've seen plenty of articles on this topic but none of them have been able to solve my problem. I am working with an Access 97 database on an NT4.0 machine, which has many Access reports. I...
11
by: Grasshopper | last post by:
Hi, I am automating Access reports to PDF using PDF Writer 6.0. I've created a DTS package to run the reports and schedule a job to run this DTS package. If I PC Anywhere into the server on...
2
by: Wayne | last post by:
I am running a complex query using about 25 criteria that are entered on a query form. If any individual criteria isn't required its field is left as "*" on the form. When I run the query the...
4
by: Andy Davis | last post by:
I have developed a number of reports that are based on parameter queries where the user enters criteria such as a date range and a sales rep say. I want to be able to show a graphical picture in...
1
by: Jo K. | last post by:
I have the following fields in a table. -JobNo (primary key) -Assessor (combo box containing only two names to choose from ie. John, Bill) I have created two seperate reports which have exactly...
0
by: neoteny2 | last post by:
I need MS Access to automatically create reports/subreports based on specific criteria. I am building a database in Access 2003 with different locations/sites. I have the "sites" table created...
5
by: SeanCly10 | last post by:
Hi all. I don't want to sound like a complete idiot here, but I'm somewhat limited in my coding knowledge, and I need some advice and help. I'm working on a database that will eventually be used...
1
by: Ron | last post by:
Hi All, I needed a report so I used the report wizards to make it based on a query I made (also made with a wizard). That all works great. However, now I need a identical report only based on...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.