Employee Skills Matrix in FlexGrid

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

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.

<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?

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...

Post a graphical example of what you are looking to do...

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.

This is an example of a skills matrix.
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?

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...

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?

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.

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

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

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.