TimeLine

[andywal]

In my database, recording bookings of cars in our fleet, I am trying to
create a form that shows the cars down the lefthand side and a continuous
timeline across the top. I would like it to handle up to 100 cars and show
who is booked to use the cars in the past, present and future.
Does anyone know of an example that I could study to get ideas on how to
construct such a form?
many thanks in advance for any help. Andy.

 

[Arvin Meyer [MVP]]

Possibly a progress bar showing a percentage might work. Here's a label with
the ability to be adapted:

http://www.datastrat.com/Download/ProgressBar2K.zip

 

[andywal]

Many thanks Arvin
I do like your progress bar but it's not quite what I wanted and thanks for
your site. I have been there many times for inspiration and you have always
come up trumps with your helpfull sugestions on the forums. (sounds like the
Arvin Meyer fan club)
The form I'm trying to create is like the bottom section of the Student Host
Database on TeeHeeSoftware.co.uk/StudentHost.html only that one is 5 Bed rows
down by 14 date columns across with buttons to go forward and back in time,
only I would want to show at least 20 rows for say blocks of 20 cars. Does
that make sense?
Andy

Possibly a progress bar showing a percentage might work. Here's a label with
the ability to be adapted:

http://www.datastrat.com/Download/ProgressBar2K.zip

In my database, recording bookings of cars in our fleet, I am trying to
create a form that shows the cars down the lefthand side and a continuous

[quoted text clipped - 3 lines]

construct such a form?
many thanks in advance for any help. Andy.

 

[Peter Hibbs]

Andy,

A Flex Grid Control will do what you want, have a look at the Flex
Grid Demo program for some examples.

Go to http://www.rogersaccesslibrary.com/OtherLibraries.asp and look
under Hibbs PeterS.

HTH

Peter Hibbs.

 

[andywal via AccessMonster.com]

Thank you Peter for your suggestion and the samples which I hadn't seen
before, I can see how I could utilise flexgrid and I have considered it in
the past but I have read so many peoples reports on licensing issues I have
tried to avoid the flexgrid as my solutions are distributed to and installed
on many machines with various versions of office or none at all, and would
prefer not to cause myself any more grief. Is it really that difficult useing
flexgrid from that perspective?
Andy.

Andy,

A Flex Grid Control will do what you want, have a look at the Flex
Grid Demo program for some examples.

Go to http://www.rogersaccesslibrary.com/OtherLibraries.asp and look
under Hibbs PeterS.

HTH

Peter Hibbs.

In my database, recording bookings of cars in our fleet, I am trying to
create a form that shows the cars down the lefthand side and a continuous

[quoted text clipped - 3 lines]

construct such a form?
many thanks in advance for any help. Andy.

 

[Arvin Meyer [MVP]]

If you have VB6 installed on your machine and use it to create your Access
install package, you can use the Flexgrid. Otherwise, as you say, there are
licensing issues.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

Thank you Peter for your suggestion and the samples which I hadn't seen
before, I can see how I could utilise flexgrid and I have considered it in
the past but I have read so many peoples reports on licensing issues I
have
tried to avoid the flexgrid as my solutions are distributed to and
installed
on many machines with various versions of office or none at all, and would
prefer not to cause myself any more grief. Is it really that difficult
useing
flexgrid from that perspective?
Andy.

Andy,

A Flex Grid Control will do what you want, have a look at the Flex
Grid Demo program for some examples.

Go to http://www.rogersaccesslibrary.com/OtherLibraries.asp and look
under Hibbs PeterS.

HTH

Peter Hibbs.

In my database, recording bookings of cars in our fleet, I am trying to
create a form that shows the cars down the lefthand side and a continuous

[quoted text clipped - 3 lines]

construct such a form?
many thanks in advance for any help. Andy.

 

[Peter Hibbs]

Andy,

I have written database apps in A2000 and and A2003 using this control
and have had no trouble running them on any version of Access from
2000 onwards (even A2007 runs fine).

Regarding the License issue, the way I read it is that the developer
gets the ActiveX license key when he/she purchases Visual Basic or
Visual Studio (or even downloading the free Visual Basic 2005 Express
version, I believe) and when he creates an application using the
ActiveX control that license key is embedded in the code for the
application so that it can be used on any other PC.

Of course, the ActiveX control still needs to be registered on the end
user's PC using regsvr32.exe (or in code). This site has more info in
license conditions for MS ActiveX controls.
http://msdn.microsoft.com/en-us/library/aa751973(VS.85).aspx

I don't believe there have been lots of different versions of the Flex
Grid control so I think it would be unlikely that you would run into
version problems.

As you say, distributing applications which have to work on different
OSs and different versions of Access is more fraught, but then what is
the alternative. The Flex Grid control sounds ideal for your
situation. I would be interested to know what you eventually decide to
do.

Peter Hibbs.

Thank you Peter for your suggestion and the samples which I hadn't seen
before, I can see how I could utilise flexgrid and I have considered it in
the past but I have read so many peoples reports on licensing issues I have
tried to avoid the flexgrid as my solutions are distributed to and installed
on many machines with various versions of office or none at all, and would
prefer not to cause myself any more grief. Is it really that difficult useing
flexgrid from that perspective?
Andy.

Andy,

A Flex Grid Control will do what you want, have a look at the Flex
Grid Demo program for some examples.

Go to http://www.rogersaccesslibrary.com/OtherLibraries.asp and look
under Hibbs PeterS.

HTH

Peter Hibbs.

In my database, recording bookings of cars in our fleet, I am trying to
create a form that shows the cars down the lefthand side and a continuous

[quoted text clipped - 3 lines]

construct such a form?
many thanks in advance for any help. Andy.