msflexgrid without data control

[denise_lau_]

dear friends,
i have a problem when using vb6.0. i can only load the data from access onto the msflexgrid by data control.when i try to load the data to msflexgrid by writing several programme lines in form_load(), it fails.does anyone help me as i am hurry to hand in my homework.

i want to ask if i use data control, can i search or edit the data on the msflexgrid.if can, how?

[Paul Warren]

Have a look at this thread, it fills the grid and sizes the columns for you.

http://forums.vb-world.net/showthread.php?threadid=25701

Post back here if you have any problems.

[denise_lau_]

Originally posted by Paul Warren
Have a look at this thread, it fills the grid and sizes the columns for you.

http://forums.vb-world.net/showthread.php?threadid=25701

Post back here if you have any problems.

[Paul Warren]

Denise_lau_

Is this a problem or are you just saying hello ?

[denise_lau_]

dear paul,
i have tried the programme u suggested to me.but neither the grid is set nor the data is shown on the msflexgrid.instead, a warning box of"object required"arise in the "end sub" of the form_load().
yours
denise

[Paul Warren]

Sorry - I jumped the gun on that last post.

The example uses DAO so you will need the right version of the DAO library loaded to use it. Add a reference to it from the Project...References menu option. It's called Microsoft DAO Library 3.51 or 3.6, depending on the version of Access your talking to.

Use 3.6 for Access 2000.

Let me know if that doesn't fix the problem and I'll have a nother look.

[denise_lau_]

dear paul,
sorry, i accidentally press the sumit button before entering anything.
actually i have chosen the DAO 3.51 and the data is created in access 2000 but download it to access 97 (because the data in access 2000 can't be opened in vb 6.0 as access 2000 use jet 4.0 and vb 6.0 use jet 3.51 only.)actually , the data can be opened in the msflexgrid if i use a data control,but when i want to omit the data control and write the programme instead, no data is shown.
or can use suggest what sort of grid should i use if i need to perform search ,edit in the data shown on the grid.
yours,
denise

[Paul Warren]

I haven't really got time to look at this right now. I'll try to get back to you in the next few hours.

[Paul Warren]

I've had another look at this and it's possible that your flexgrid isn't called grdFields. I just made the same mistake when trying the code out again.

Could you check the name first.