VideoSoft Flex Array or other 3rd party Grid OCX ?

  • Thread starter Thread starter Albert D. Kallal
  • Start date Start date
A

Albert D. Kallal

First....do consider the built in continues forms...they are often over
looked...

Take a look at the following screen shots:

http://www.members.shaw.ca/AlbertKallal/Articles/Grid.htm

So, the above screens are native ms-access...no special code. If you just
need a nice grid
with formatting...then use a continuous form. they require VERY little code,
can edit
data...and you get to use the standard ms-access form events. And, you can
use conditional
formatting to "color" boxes based on conditions. And, you an place buttons,
or
check boxes on that continues grid also.


If you really exhausted the above, and for some reason don't want to use the
REALLY GREAT built in grids (continue forms), then
a nice activeX gird control?

I recommend tlist7...it really nice..and works well with ms-access..

You can find it here:

http://www.bennet-tec.com/btproducts/tlist/tlist.htm
 
I have just got a requirement from a client for a grid array embedded
in a form (as opposed to using the standard datasheet style subforms)
In the past I have gone to VB6 and Farpoint Active X but would like to
have another go at staying in Access.

I initially tried embedding an Excel spreadsheet in the form and this
almost worked though a bit slow and clunky.

Looking at the 3rd party ocx's available in the toolbox - I see
VideoSoft Flex Array. It appears to be licensed ok for Access 2003 -
but I am finding very little documentation for it - googling and
following the "about box" only lead me to Component 1 which has a
control called "Flex Grid" which seems similar but perhaps not
identical. Almost no mention at all in Microsoft Knowledge Base.

Questions :
1) Which newsgroup should I be asking these questions in ?
microsoft.public.access.activex seems very quiet
2) Is VS Flex Array up to the job ? (just a bit of cell stuffing and
formatting is all I want to do)
If not can anyone recommend a good grid ocx that works with
Access 2000 - 2003 (I'm happy to pay up to $US 300 to buy a license
and documentation)
3) Where can I find VS Flex Array help files, documentation, samples
for Access VBA ?
4) What is the difference between VS Flex Array and VS Flex Grid ?

Many thanks in advance
Tony Epton
 
The main problem, for my particular application, as I understand it,
with continuous forms is that the fonts and colours apply to the
entire column - or have I only been using a fraction of their power
in my ignorance ?
Click to expand...

yes, you can apply text/collor formatting to individual contorls in a collum

You can have the color, or font change based on conditions (up to 3 per
column).

While in design mode of a form, simply highlight a control (text box).

Then go format->conditional formatting.

Note the bunch of features for font, color etc......

the above just might save your day.....
 
Would you mind giving me a very brief code snippet, or tell me which
proptery events I should be manipulating to achieve this. ?
Click to expand...


For the "gray" alternation. I just made a function in the form that returns
odd = true if the record position is odd.

The code in the forms code module is:

Private Function Odd(vID As Variant) As Variant

Dim nRec As Long

If IsNull(vID) = False Then
Me.RecordsetClone.FindFirst "id = " & ID
nRec = Me.RecordsetClone.AbsolutePosition
If nRec Mod 2 = 1 Then
Odd = True
End If
End If

End Function


Then in coditinal formatting I choose:

"expression is"

And in the expression box, I typed in
odd([id])

I assume the primary key value is id...as it is for most tables. At this
point, I can bold, or shade the background.....

You can also do simple things like have a red box for negative
values....bold for partiuclar value...whatever.....
 
Thanks Albert

The main problem, for my particular application, as I understand it,
with continuous forms is that the fonts and colours apply to the
entire column - or have I only been using a fraction of their power
in my ignorance ?

Many thanks
Tony Epton
 
The main problem, for my particular application, as I understand it,
with continuous forms is that the fonts and colours apply to the
entire column - or have I only been using a fraction of their power
in my ignorance ?
Click to expand...
I should have looked at your samples before posting.

I notice one example where you have alternating shading on the lines -
that's a very neat trick which I didn't know was possible.

Would you mind giving me a very brief code snippet, or tell me which
proptery events I should be manipulating to achieve this. ?

Much 'ppreciative

Tony Epton
 
ace said:
1) Which newsgroup should I be asking these questions in ?
microsoft.public.access.activex seems very quiet
Click to expand...

Here is as good as any.

There is a list of Access compatible grid controls at
http://www.granite.ab.ca/access/gridcontrols.htm. Most of the grid
controls allow you to download a demo version and see if it suits your
needs. I would think some would have Access specific examples but the
VB sample code should work. Emphasis on the should.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
dude stick with the built in forms

I mean seriously

if you want to reinvent the wheel go and hang out with cSharp fags
 
First....do consider the built in continues forms...they are often
over looked...
Click to expand...

Only by people who haven't bothered to learn the most basic things
about Access!
 
Peter Hibbs said:
You could use a Flex Grid control. Have a look at my Flex Grid demo
program at -
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hibbs,Peter S
for some examples.
Click to expand...

I'd like to add a link to that page to my page however that URL
doesn't go directly to your section. Does it work for others? If so
what browser type and version?

I've already emailed Roger on this problem suggesting he remove the
space aka %20.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
Tony

You could use a Flex Grid control. Have a look at my Flex Grid demo
program at -

http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hibbs,Peter S

for some examples.
Click to expand...
Very nice examples - many thanks
You've turned me on to Flex Grid.

But before I start using it in every database :-

Can anyone give me any background on MSFLXGRD.OCX ?

It appears to be in the System32 directory of every one of my machines
but does not appear to in the toolbox list of controls within Access.

Is there any rhyme or reason as to what appears in the toolbox list
(as opposed to being quietly placed in to system32 during the
installation of some product) ?

No problem registering it if I need it - but which product is it first
installed with and are there any licensing issues (ie may not be on
some of my client's target machines)

A look in the knowledge base indicates that it comes with earlier
VB's, .Net developer, Office Developer, Project, etc - unfortunately I
have no "bare bone" systems to see if it just comes with the just the
OS or with Office.

Though I guess, from your instructions on how to install and register
it - it is no big issue if it is initially missing from a machine.

Many thanks
Tony
 
Hi Tony,

I am happy for you to provide a link to the Flex Grid page on your Web
site. I don't know of a way to go to the page directly, if Roger can
provide a new URL that does I would be very interested to see it as it
will make it easier for me to point interested parties to the demo.

Peter Hibbs.
 
Hi Tony.

I don't know why the control does not appear on the list of ActiveX
controls on your system, it does on mine. It was installed on my PC
many years ago when I installed Visual Basic 6 and the license to use
it in any application automatically came with it. If you want to use
it in your own software I think you need the license but if you then
install your database on someone elses computer you only need to
register it on their computer using the regsvr32.exe utility.

I'm pretty sure it does NOT come automatically with Windows or Office
(don't know about Office 2007 though).

I presume that if you buy it you will get the license to use it, as
well, although I know of one user who just imported a form from the
demo database to his and he could use it as normal (although that does
not work for me, as I mentioned in the Word doc).

If you do find a company that sells the control I would be interested
to know as a few other people have asked the same question.

Sorry I can't be of more help, perhaps someone else can provide a bit
more information.

Peter Hibbs.
 
Albert - Thanks for the referral
Tony - if you have any questions about TList, please don't hesitate
to get in touch with us - we're here to help. You can post
questions
on our web site at www.Bennet-Tec.com, Click on Support.
We pride ourselves on support and will try to answer as quickly
as possible .

Jeff Bennett
Jeff @ Bennet-Tec.com

=============== ====================
On Feb 20, 10:19 pm, "Albert D. Kallal"
. . . .
If you really exhausted the above, and for some reason
don't want to use the REALLY GREAT built in grids (continue forms),
then a nice activeX gird control?

I recommend tlist7...it really nice..and works well with ms-access..

You can find it here:

http://www.bennet-tec.com/btproducts/tlist/tlist.htm
Click to expand...

=========================
 
Back
Top