Lawrence Salvucci
asked on
Employee Skills Matrix in FlexGrid
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?
ASKER
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.
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.
<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?
Just curious, ...
What, specifically, is the flex grid going to do, that can't be done in Access directly?
ASKER
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.
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...
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...
Post a graphical example of what you are looking to do...
ASKER
Thanks for the info. Is there an easier way to set this up?
In Access you can use a listbox, or datasheet view, or Continuous form to display data that "Looks" like it would in Excel.
ASKER
This is an example of a skills matrix.
skill-matrix---Gemba.JPG
skill-matrix---Gemba.JPG
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?
In Access this would most likely be a report.
What is the raw data driving this output?
ASKER
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.
OK, at first glance you will need at least 3 tables
Employees
Skills
EmployeeSkills (junction table)
I am working on a sample now...
Employees
Skills
EmployeeSkills (junction table)
I am working on a sample now...
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?
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?
ASKER
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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!!!
<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
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
ASKER
I appreciate your help and the work you put in to the sample. Thank you very much!
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
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
ASKER
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.
http://www.rogersaccesslib
HTH,
Daniel