Employee Skills Matrix in FlexGrid

Lawrence Salvucci
Lawrence Salvucci used Ask the Experts™
on
I'm trying to create a skills matrix in a FlexGrid instead of in Excel. Does anyone have any examples or ideas on how I should go about setting this up? Is this even possible?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
You might take a look at this demo, and see if that helps you:
http://www.rogersaccesslibrary.com/forum/flex-grid-demo_topic511.html

HTH,
Daniel
Lawrence SalvucciDirector of Information Technology

Author

Commented:
Hi Daniel,
Thanks for the link. Most of those are for dates, sales, etc. I'm not that familiar with grids so I really wouldn't know where to start to modify those to make them look like a skills matrix.
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
<I'm trying to create a skills matrix in a FlexGrid instead of in Excel.>
Just curious, ...
What, specifically, is the flex grid going to do, that can't be done in Access directly?
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Lawrence SalvucciDirector of Information Technology

Author

Commented:
Well I was just thinking of a way to mirror a skills matrix and just thought a flexgrid would be best. I'm open to other suggestions. I want it to look like it would in excel.
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
Just be aware that the Flexgrid is not a true "native" control for MS Access.
You must load specific vba references/libraries on *every* machine that will need access to this functionality...

They are also notoriously difficult to program for novice programmers...
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
Post a graphical example of what you are looking to do...
Lawrence SalvucciDirector of Information Technology

Author

Commented:
Thanks for the info. Is there an easier way to set this up?
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
In Access you can use a listbox, or datasheet view, or Continuous form to display data that "Looks" like it would in Excel.
Lawrence SalvucciDirector of Information Technology

Author

Commented:
This is an example of a skills matrix.
skill-matrix---Gemba.JPG
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
Well that would have been extremely difficult for a novice programmer to accomplish...

In Access this would most likely be a report.

What is the raw data driving this output?
Lawrence SalvucciDirector of Information Technology

Author

Commented:
For each level in the graphic would be stored as a number, (1=Can not perform the task, 2=Familiar with elements on the job, 3=Can perform with help, etc). So each task would a record that is linked to the employee with a level tied to it. Then from there I'd want the users to be able to see this matrix in a report or even a form. I would prefer it if they could look at this on a form first and maybe be able to filter it by a department so they can see the employees and the tasks for that department and what level they are. I would like the circles as sampled in the graphic though to show the graphic better.
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
OK, at first glance you will need at least 3 tables
Employees
Skills
EmployeeSkills (junction table)

I am working on a sample now...
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
This will not exactly be something that will be "simple", ...especially for someone new to MS Access.

You need to be well versed in table design, table relationships, Report design, Formulas, ...et al.

This is also not something that would be a few sentences for me to explain.
This is basically a "Project".

I would be happy to provide a rough sample, but you will have to study it in order to recreate/modify it to work in your database.

How would you like to proceed?
Lawrence SalvucciDirector of Information Technology

Author

Commented:
I'd appreciate it if you could put together a sample for me. I'll take the time to understand it thoroughly before making any changes. I want to understand how it ticks first.
MIS Liason
Most Valuable Expert 2012
Commented:
Check this.

It's rough, ...but it's ready...
Access-EEQ27088108SimulatedCross.mdb
Lawrence SalvucciDirector of Information Technology

Author

Commented:
That's exactly what I need. Is there a way to duplicate that report in a form view? I want to be able to filter by department on a form and have it show exactly what you have on the report for all employees and skills for that department. If you could help me with that part I think I can take it from there. THANK YOU VERY MUCH!!!
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
<That's exactly what I need. Is there a way to duplicate that report in a form view? >
Not easily, the issue here is that the Report is "Grouped"
This is not directly possible with forms.


<I want to be able to filter by department>
Again, this is why I stated that you should really have a firm background in Access if you need to do something like this...
You can easily filter the Report by using a form that selects the Department.

Create a blank form
Drop a combobox on it
Select the option "I want the combobox to look up..."
Select the Department table
Select both fields
Set your sort
(Leave the Key field Hidden)
Enter the label text you want to display

Drop a button on the form.
On the Click event, put code like this:
    DoCmd.OpenReport "rptEmpSkills", acViewPreview, , "DepartmentID=" & Me.Combo0



But again, this is all MS Access Fundamentals, so you should really obtain a good book on MS Access
http://www.amazon.com/Access-2007-Bible-Michael-Groh/dp/0470046732/ref=sr_1_3?ie=UTF8&qid=1307629477&sr=8-3

http://www.amazon.com/Microsoft%C2%AE-Office-Access-2007-Microsoft/dp/0735623031/ref=sr_1_1?ie=UTF8&qid=1307629535&sr=8-1

http://www.amazon.com/Microsoft-Access-2010-Plain-Simple/dp/0735627304/ref=sr_1_13?ie=UTF8&qid=1307629566&sr=8-13


JeffCoachman

Lawrence SalvucciDirector of Information Technology

Author

Commented:
I appreciate your help and the work you put in to the sample. Thank you very much!
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
I sometimes enjoy projects like this...

BTW, it would have been extremely difficult to replicate this with a Flexgrid.

This is why sometimes it is best just to state your ultimate goal, the Experts can perhaps suggest the best way to implement it.

;-)

JeffCoachman
Lawrence SalvucciDirector of Information Technology

Author

Commented:
That's why I posted. I wasn't 100% sure a flexgrid was the best way. I was hoping someone would have a better idea. Thanks again. I should be ok from here to build upon what you started.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial