Free Lessons
Courses
Seminars
TechHelp
Fast Tips
Templates
Topic Index
Forum
ABCD
 
Home   Courses   TechHelp   Forums   Help   Contact   Merch   Join   Order   Logon  
 
Back to Access Forum    Comments List
Upload Images   @Reply   Bookmark    Link   Email   Next Unseen 
Employee Performance Tracking
Ben Perry 
      
43 days ago
I found a couple other forum threads that didn't prove helpful. I thought it might be beneficial for someone to know that while I am currently doing this and a coworker using it loves it, I don't like the overall design because IMO the company I work for asks too many questions so my form is extremely long. I will try to share screenshots of the design for anyone who may like it and hopefully get some input on a better setup. I did try to see if there was a video with this specific use case and there doesn't appear to be although Richards ChatGPT recommended the survey seminar as a conceptual, I just am not in a posistion to get it at the moment. One thought I had am just starting to try to do is to use buttons to change the control source of a single text box and label to cycle through the fields of that record so it is a cleaner look.
Ben Perry OP  @Reply  
      
43 days ago

Ben Perry OP  @Reply  
      
43 days ago

Ben Perry OP  @Reply  
      
43 days ago

Matt Hall  @Reply  
          
43 days ago
Ben , Just out of curiosity, is this filled out by the employee or by the employer.  I only ask because I have worked a job where this would look very different depending on who provided the feedback.  

There were many of us on site in the same role and some of those on site would take "shortcuts" in their work.  Our supervisors were evaluated on the quantity of work done but not the quality.  Additionally, my supervisor did not know how to do my work.
Ben Perry OP  @Reply  
      
43 days ago
Matt , I understand what you mean and absolutely agree. I work for a relatively small manufacturing plant producing specialty vehicles, so this is meant more for a superior to fill out regarding their subordinates. That is also why there is a line separating the supervisor from reviewer because there is a possibility there is a difference. There are absolutely people with subordinates who don't know how to do that subordinates job but they are expected to be able to answer these questions. It applies to the supervisors on the floor overseeing the grunt workers all the way to the top where my CEO fills it out for the COO.
Matt Hall  @Reply  
          
43 days ago
I have a couple of forms where I show and hide controls depending on what I am doing.  You might be able to do something similar where you only display the active textbox using label clicks as the trigger.  When you click on the label, that textbox would become visible and the rest would be made not visible.  The labels could also move together so all of the topics are visible but only the active response is visible.  That would shorten the form and expose only one working field at a time.
Ben Perry OP  @Reply  
      
43 days ago
I like that idea. I will probably try that since hopefully I can do it faster. Im envisioning that would be done with size properties of the controls and detail section right? I haven't had the chance to work the computer thought process for my idea so I dont even know if it can be done with its current structure.
Matt Hall  @Reply  
          
43 days ago
When I click on label5, I make textbox5 visible and all others not visible.  I vertically position the controls using the control.top property.  Something like: textbox5.top = 2800.
Richard Rost  @Reply  
          
41 days ago
Thanks for sharing this, Ben. First, nice work getting something functional in place. If it's doing the job and your coworker likes using it, that's already a win. That said, from a design standpoint, I probably wouldn't build this with a separate field for every single question. What I would do instead is set it up more like a survey or quiz database with a Questions table and an Answers table. Then each evaluation would store one record per answer tied back to the question and the employee review. That makes the system a lot more flexible because you can add, edit, reorder, or remove questions without having to redesign the table structure every time management changes the form, which we all know they love to do.

The other advantage is that once you go that route, you can support all kinds of question types much more easily, like short text, long text, numeric ratings, yes/no, multiple choice, and so on, all in the same framework. So instead of fighting a giant wide table and a huge form full of bound controls, you'd be working with a structure that can grow with you. What you've built definitely works, but if you plan on expanding it or making it easier to maintain long term, I think a normalized survey-style design would be the better way to go. I've actually had something like this on my list for a future Developer lesson because there are a lot of useful techniques wrapped up in it, so you may have just bumped it higher on the list.
Ben Perry OP  @Reply  
      
41 days ago
Come on Richard, you're killing me lol. Like I said, it works, he loves it, I always hated it but didn't know a better way (still don't fully). Now I have to buy your survey seminar and hustle through the developer videos (I'm not very patient) so I can see what you end up putting out. What makes the structure you describe difficult for me to fully understand without seeing is currently the answers are set up as note fields so the supervisor can type in examples and details specific to the employee and question. Having predetermined answers sounds great to me but I'm not sure everyone else would be happy with it. This originated in an excel file and is still used mostly from that because ppl here don't like change. I keep trying to push the move because operating a business of this size out of excel seems insane to me, anyway, I can't wait to see what you put out. Thank you.
Richard Rost  @Reply  
          
41 days ago
Ben here ya go: Questionnaire

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.
 

Next Unseen

 
New Feature: Comment Live View
 
 

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
PCResale.NET
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

LinkedIn
Copyright 2026 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 4/30/2026 2:29:32 AM. PLT: 1s