resource allocation control

[pdemercey]

Hi,

I'm not sure this is the right group to ask this question...

I would like to build a form acting like a resource usage sheet. Let's
say we have n different items, and I'd like to display the hourly
utilisation for a few items, for 7 days in a form.

Day 1 Day 2 ...
------------------------------------------------------
Item 1 x x x x x x x x x x x x
x x x x x x x x x x x x
x x x x x x x x x x x x
x x x x x x x x x x x x
------------------------------------------------------
Item 2 x x x x x x x x x x x x
x x x x x x x x x x x x
x x x x x x x x x x x x
x x x x x x x x x x x x
-------------------------------------------------------

(hope this will show well in your browser. You should see 4 blocks of
24 x's)

Each of the x's is a cell that can display a color depending on the
usage (say a few different colors for different company departments),
and a click on a cell will add a new usage row in the related table.

What I've done so far is create a subform for 7x24, each 'cell' being
actually one textbox (to change colors) and one transparent button. The
controls have names such as T107 for textbox day 1 hour 07 and B107 for
a button.

I then include this subform in continuous view in a form linked to my
table. Problem is I cannot control the color of one specific textbox
T107 in continuous view - I don't believe continuous view really allows
this, unless I use complicated and dirty workarounds.

I could build a complete form with all items, but it would be rather
long and I would have to redo it each time I add or remove a specific
item. I could not chose to display only items filtered on a specific
category... Not very adatable.

I wondered if there would be a better / simpler way to do this, perhaps
using another control. I'm not sure I can use the datasheet view for
this.

Any hint on this would be greatly appreciated.

Thanks,

Philibert

 

[Guest]

You may want to purchase a third party control such as those found at
http://www.dbi-tech.com/.

 

[Guest]

Philibert,

Your best option is to use a Flex Grid control.

See my Flex Grid demo program at -
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hibbs,Peter S
for some examples.

 

[Philibert]

Thank you very much to both for these extremely useful links.
Peter, your demo database is excellent, congrats.

And happy new year

 

[Guest]

Very nice demo Peter. Can I assume you reside in an area that uses
day/mth/yr...?

 

[Philibert]

I have trouble adding the flexgrid control on a new form: "you don't
have the license required..."

I did not find very conclusive help on this in the groups: they seem to
say that you need to have developper version / tools installed, but it
seems weird: I can edit properties and work with the flexgrid in your
db without any problem. I could also successfully import a form with a
flexgrid on it in my database seemingly without the problems you
mention, so it should be ok anyways. I'm just puzzled about the correct
way to work with it.

Philibert

 

[Douglas J. Steele]

What you're describing is exactly how it's intended to work: you can only
add a control if you have the appropriate license, but you can use that
control (once added) regardless of whether or not you have a license.

Unfortunately, I don't have a list of to which Microsoft controls this
applies.

 

[Guest]

Hi Guys.

Thanks for the kind comments about my demo program.

Duane. Yes, I live in southern England.

Philibert. I'm not sure about using the control in a new project. I acquired
the control when I installed VB6 some years ago, I guess it was licensed
properly then. I have used it for various databases on other PCs and I had to
register it using the regsvr32.exe utility for it to work correctly. Maybe
installing VB6 or VB 2005 (but not the free Express Version, as I don't think
it comes with that) would fix the problem (I'm assuming the Flex Grid control
comes with the full version of VB2005 but I don't know for sure as I don't
have it yet).

Strange that you don't get any problems importing a form with a Flex Grid
control, perhaps there is some problem with my program/s.

Anyway, sorry I can't be more help. Good luck with your project.

 

[Douglas J. Steele]

Yes, installing VB6 or earlier definitely was a way to acquire a license.
I'm not sure VB 2005, or any other version of VB.Net will necessarily have
the FlexGrid control.

 

[Guest]

I also imported one of the forms with a flexgrid control but I get a compile
error on flexAlignCenterCenter etc - undefined variable.

Sue

 

[Peter Hibbs]

Sue,

Have you set a reference to the Microsoft FlexGrid Control 6.0 in the
References dialogue.

Peter Hibbs.

 

[Guest]

Hi Peter

Weird!!!! I had as I remember going through the process but double-checked
just now and it wasn't in the list at all! I had to browse from References,
find the OCX again I'd put in System32 and open - it automatically appeared
back in the list as selected. Sorry, it all compiles ok now thanks!

Sue