November 19, 2008 02:33am pst

1. LSMCons... 221,794
2. boag2000 207,288
3. capricorn1 173,245
4. DatabaseMX 113,861
5. peter57r 100,815
6. matthews... 61,295
7. harfang 55,490
8. jimhorn 51,658
9. jmoss111 46,537
10. GRayL 27,259
11. LennyGray 25,605
12. JDettman 25,023
13. hnasr 24,075
14. frankytee 18,250
15. MikeToole 16,650
16. RgGray3 15,896
17. kelvinsparks 15,490
18. mbizup 15,450
19. jefftwilley 15,400
20. wiswalld 14,660
21. dqmq 13,287
22. Arthur_... 12,882
23. clarkscott 12,710
24. nexusnation 12,400
25. cactus_d... 12,394

1. LSMCons... 286,909
2. capricorn1 216,253
3. boag2000 215,263
4. DatabaseMX 189,219
5. peter57r 143,269
6. matthews... 89,629
7. jimhorn 75,676
8. harfang 74,470
9. jefftwilley 61,168
10. jmoss111 51,137
11. GRayL 47,691
12. JDettman 45,298
13. frankytee 35,142
14. mbizup 31,050
15. MikeToole 30,650
16. dqmq 29,647
17. LennyGray 25,605
18. kelvinsparks 24,990
19. hnasr 24,075
20. stevbe 21,852
21. puppydog... 21,045
22. LPurvis 20,873
23. rockiroads 19,250
24. Arthur_... 16,982
25. wiswalld 16,390

10.02.2008 at 09:06AM PDT, ID: 23782153

	[x] Attachment Details

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

8.7

How do i make a button do multiple tasks?

Asked by puzzlednoob in Access Architecture/Design, Access Coding/Macros

Tags: Microsoft, Access 2003, SP3

Hi
I am trying to create a basic database for my colleagues that records several features of training for customers over the course of time. I have a form that records the course details - dates, code, quote reference, and then a subform recording the trainees who attended. I have created a button at the end of each line of the subform to allow the printing of a certificate referencing the open form selection of course and trainee using a macro which opens a query and then sends to a report. the problem i have is that i need to record the attendance of the trainee with a simple yes/no field and i also want to date stamp the printing of the certificate. I am currently unable to do these AND print the certificate and i need a little help please. Below is the code for the button, referring to the macro which simply opens the query, opens the report and then closes the query. i can provide the entire database as it's pretty small but it's still in creation so there's a lot of loose and dead ends still included. Start Free Trial