Solved

Multiline per record grid control sought

Posted on 1998-12-17
12
393 Views
Last Modified: 2013-12-26
I'm after a grid control which will display/edit edit a number of lines per record, similar to Access Forms Continuous form mode. The records should have distinctive lines separating them, different from the lines separating the lines within the reocrd.
None of the grid controls supplied with VB5 can do this, and Truegrid V5 can't cut it either - it's record seaparators are not distinctive and they proudly admit it.
Truegrid is a fool of a thing to navigate with tab and arrow keys. I'm looking for something superior.



0
Comment
Question by:ozphil
  • 5
  • 3
  • 2
  • +2
12 Comments
 
LVL 4

Expert Comment

by:tomook
ID: 1489045
The only other one I have to recommend is Sheridan.
0
 
LVL 2

Expert Comment

by:kswinney
ID: 1489046
The only grid that I know of that may have the features you're after is the Janus grid.  A trial version can be downloaded at:

http://www.janusys.com/

Good luck!
0
 
LVL 4

Author Comment

by:ozphil
ID: 1489047
Thanks.

I have just looked at the Janus control and it's not what I want.

These users have to have a grid:

------------------------------------------------------
x1        1     34     56     78
l_x1     67d    5t     58     78  
------------------------------------------------------
h5       78            56    
l_h5     OFF    45     78      
------------------------------------------------------
rr
l_rr
-------------------------------------------------------

where x1, l_x1 come from the same record, separated from the other pairs with a distinctive line. And fully navigable/editable with arrow keys and tab. There are hundreds of records so it has to have a high speed interface.

I'll be looking at sheridan.
0
 
LVL 4

Author Comment

by:ozphil
ID: 1489048
I can' t see a Sheridan control that will do it.

The Microsoft Access Continuous forms mode is unique and I would like  third party control for VB5/6 seems to match it's ability to provide a number of lines per record, with distinctive lines between records.


0
 
LVL 1

Expert Comment

by:tommy_boy
ID: 1489049
Use Apex TrueDBGrid it allows for multiline.  Maybe DBGrid will enable you to do multi-line (it is by Apex as well)

0
 
LVL 4

Author Comment

by:ozphil
ID: 1489050
I have already rejected Truegrid in my question. Its navigation is too cumbersome and it does not provide distinctive lines between records.
0
Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

 
LVL 4

Expert Comment

by:tomook
ID: 1489051
ozphil, VB6 has a continuous subform control. It works rather well. To use it, you *must* use the ADO data control, and make your subform a separate OCX. Let me know if you would like more info.
0
 
LVL 4

Author Comment

by:ozphil
ID: 1489052
tomook

I am interested yes.

We have Visual Studio 6 Enterprise Edition on order, and am currently developing this application in Access97.

I'm using a lot of DAO between a 'client' and 'data' Access databases.

Can I use ADO between VB and Access(Jet) database.

In any case I am interested in the OCX and hope that it provides sufficent events and properties etc to make it a useful 'grid'




0
 
LVL 1

Accepted Solution

by:
DennisH earned 50 total points
ID: 1489053
What you need to use is the DataRepeater control in VB6.  There's an excellent article on how to use it in "Visual Basic Programmer's Journal" Nov. 1998 edition.  See page 63, column 1.

To summarize the process, you first create an ActiveX control that has your text boxes arranged on it.  Read and write to the text boxes by creating properties on the control. Example:

Public Property Get FirstName() as string
  FirstName = txtFirstName.Text
End Property
Public Property Let FirstName(ByVal strValue as string)
  txtFirstName.Text = strValue
  PropertyChanged "FirstName"
End Property

Next set the property attributes.  Select Procedure Attributes from the Tools menu.  Check the "property is data bound" and the "Show in DataBindings collection.." check boxes.  Compile the OCX.

In another project, add a form and place an ADO Data control on it.  Bind the data control to your data source.  Put a DataRepeater control on your form and bind it to the ADO Data control.  Set the RepeatedControlName of the DataRepeater to the class name of your new OCX.  Right click on the DataRepeater and open the properties page.  Set the RepeaterBindings to bind the OCX to the DataRepeater.  Now you have something that approximates an Access subform.

Just as a note, our company is working on a product that will automate this process between Access and VB.  Visit our web site at www.ndimensional.com for more information.
0
 
LVL 4

Author Comment

by:ozphil
ID: 1489054
Thanks dennis. Tomook also supplied the answer first as a comment, so who gets what?

Your reference to the VB Journal articel is useful. I'll look at the article if I can get hold of the magazine article.


0
 
LVL 1

Expert Comment

by:DennisH
ID: 1489055
ozphil,

tomook and I own the same company.  It doesn't matter to me about which of us gets the points.  Happy Holidays!
0
 
LVL 4

Expert Comment

by:tomook
ID: 1489056
Give it to Dennis. He gave the technical details.
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

When trying to find the cause of a problem in VBA or VB6 it's often valuable to know what procedures were executed prior to the error. You can use the Call Stack for that but it is often inadequate because it may show procedures you aren't intereste…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now