Basic database and struggling from the beginning

[Burnsie]

So you need to be able to search the report? You can search the report with Ctrl+F although it is not elegant.

The other option is to create a link from your form that opens up your report to the specific employee.

You could also probably create a pop-up search form to search the report but this would involve a lot of work.

sorry for the delay...been out of the office for a week.

So, what i want is for me to be able to creat a report for each person, that they can take away with them. I will contain all their detials/results from the session.

In the old database, I had it set up that when i opened the report, i got a pop-up asking me for a employee ID nu,ber. I put that number in and their detials (and only their details) came up (sourced from the Personal details and source tables).

It was then a simply "print", done!

 

[EternalMyrtle]

In the old database, I had it set up that when i opened the report, i got a pop-up asking me for a employee ID nu,ber. I put that number in and their detials (and only their details) came up (sourced from the Personal details and source tables).

It sounds like you had a parameter query set up for the report.

That is an option. I have not used those so I cannot help you but it should be fairly straightforward to set up.

Another option would be to link to the report from the employee form (create a hyperlink control in your form on the ID field) and in the on click event of the control use code:

DoCmd.OpenReport "YourReportName", , ,"[EmployeeID]"= & Me.EmployeeIDControlName

Using your names of course.

 

[EternalMyrtle]

This should help: http://office.microsoft.com/en-us/access-help/overview-RZ001097065.aspx?section=1

or this:

http://office.microsoft.com/en-us/access-help/using-parameters-with-queries-and-reports-HA001117077.aspx

 

[Burnsie]

It sounds like you had a parameter query set up for the report.

That is an option. I have not used those so I cannot help you but it should be fairly straightforward to set up.

Another option would be to link to the report from the employee form (create a hyperlink control in your form on the ID field) and in the on click event of the control use code:

DoCmd.OpenReport "YourReportName", , ,"[EmployeeID]"= & Me.EmployeeIDControlName

Using your names of course.

sorted it...it was simple (I probably didn’t explain it properly)

I simply added a query (with a parameter of "What Staff number") as the source to my existing report like this

http://office.microsoft.com/en-gb/access-help/use-a-query-as-the-record-source-for-a-form-or-report-HA010096318.aspx#BM1

 

[EternalMyrtle]

Great!

I was inspired to use a parameter query on one of my long, slow to load reports today. Very easy to implement.