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.

On Fri, 04 Jul 2008 18:36:42 GMT, "andywal" <u44667@uwe> wrote:

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

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


"andywal via AccessMonster.com" <u44667@uwe> wrote in message
news:86b3d901c9dec@uwe...
> 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.
>
> Peter Hibbs wrote:
>>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.
>
> --
> Message posted via http://www.accessmonster.com
>

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.

On Sat, 05 Jul 2008 17:19:59 GMT, "andywal via AccessMonster.com"
<u44667@uwe> wrote:

>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.
>
>Peter Hibbs wrote:
>>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.