Solved

MSFLEXGRID FIXED COL

Posted on 1998-10-07
3
432 Views
Last Modified: 2013-12-26
I am using 2 msflexgrids on a form.
both have the fixed col and row set to 1 - this is what i want. the props are set the same with the exception of the source.( must be my problem)

the first grid is not set to a data control and it scrolls fine in both col and rows. ( the col-row headers do not move)

the second grid uses a datsecondaryRS. the fixed col is blank and my data starts in col 1 ( not col 0 )

am i missing somthing ? is there another way around ?

Thanks
        diamondp
0
Comment
Question by:DIAMONDP
  • 3
3 Comments
 
LVL 3

Accepted Solution

by:
TheAnswerMan earned 50 total points
ID: 1487434
I think you must be..  I tried to duplicate your items
useing the NWind.mdb Database.
Datacontrol set to the Employees Table.

Dim x As Integer
Dim y As Integer
Grid1.Rows = Grid2.Rows
Grid1.Cols = Grid2.Cols
For y = 0 To Grid2.Rows - 1
    Grid1.Row = y
    Grid2.Row = y
    For x = 0 To Grid2.Cols - 1
        Grid1.Col = x
        Grid2.Col = x
        Grid1 = Grid2
    Next x
Next y

This copies everything from the second<bound> into the first..
they both look and scroll the same..

0
 
LVL 3

Expert Comment

by:TheAnswerMan
ID: 1487435
try copying the second one..  rename it to the first.. then remove the datasource link.
0
 
LVL 3

Expert Comment

by:TheAnswerMan
ID: 1487436
try copying the second one..  rename it to the first.. then remove the datasource link.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There are many ways to remove duplicate entries in an SQL or Access database. Most make you temporarily insert an ID field, make a temp table and copy data back and forth, and/or are slow. Here is an easy way in VB6 using ADO to remove duplicate row…
Introduction While answering a recent question (http://www.experts-exchange.com/Q_27402310.html) in the VB classic zone, I wrote some VB code in the (Office) VBA environment, rather than fire up my older PC.  I didn't post completely correct code o…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
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…

830 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