Michael, Depending upon how many columns you need the ctMDay activex appointment scheduling control from DBI will do exactly what you want. I have a similar application here with machines not days along the columns and times down the rows. The intersection shows a job which can be drilled down to and the size of the block shows the elapsed time for each job on each machine.
I'm sure that the control is freely available from DBI now under the Sedna VFP9 release but I've not checked as I have the corporate toolbox here which contains all the DBi controls. Only one problem - you are limited to 10 displayable columns at any one time even though the underlying matrix will support up to about 200 I think. Oh and by the way I have a touch screen working on it and we can drag jobs from one machine to another or one timeslot to another. One of the other operators has it on two 19" monitors displayed in the "QC lab" where everyone can see the scheduled work in the factory. Drag and drop is no problem as is double click drill down and event colouring etc etc. If you can live with the 10 column display restriction then it is ideal and will do the job with very little effort. If you want to see a screenshot just ask. Dave Crozier -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of MB Software Solutions Sent: 08 May 2007 22:05 To: Profox Subject: Need for software...does it exist already, or how would you designthis kind of screen need? I'm reminded of Ted saying something like there's no need (most of the time) to create software, as there's tons of softwares out there now that could do what folks need. Here's my client's (a pallet creation company) need: They've got a magnetic scheduling board, where it's laid out in a matrix of sorts--days of the week on the horizontal, different workcenter names on the vertical, with each of the day/workcenter intersection points featuring little magnets showing the jobs scheduled along with the little extras needed for each job. For example, they've got 3 jobs scheduled on Tuesday, May 8th in the Nailing workcenter, and each of those jobs needs something a little different--one job needs to use Wood Type A with 3/4" spacers; another job needs to use Wood Type B with 1/2" spacers; and the final job needs to use Wood Type C with 1/4" spacers. Keeping track of that data isn't too hard a task for a developer, but how to represent that on the screen---that's the real challenge here. (Of course, coming back to Ted's point, if there's something out there already suitable for this task, then it's a moot point how I would represent it in my design.) 1) Does anyone know of an EXISTING application that would suffice for this? 2) IF I have to do it in VFP9, can I design a grid of containers of sorts to achieve this "matrix" kind of look and feel? I must admit it'd be a cool app to design, as he likes the idea of dragging/dropping and using very big (flat screen) monitors. Getting the touch-screen add-ons would be an awesome feature! tia, --Michael -- Michael J. Babcock, MCP MB Software Solutions, LLC http://mbsoftwaresolutions.com http://fabmate.com "Work smarter, not harder, with MBSS custom software solutions!" [excessive quoting removed by server] _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
