Member Avatar for agrothe

I must be getting soft....

How the heck to do I programmatically add new rows to a datagrid / flexgrid or whatever grid using VBA?

It's not bound to anything and I'm trying to add data on the fly. Any ideas?

  • 3 Contributors
  • 5 Replies
  • 116 Views
  • 1 Year Discussion Span
  • Latest Post Latest Post by agrothe
Member Avatar for anto_nee

can use flexgrid.rows=flexgrid.rows+1

let me know wht the exact problem do u have

commented: thanks. +2
Member Avatar for agrothe

can use flexgrid.rows=flexgrid.rows+1

let me know wht the exact problem do u have

Sorry, forgot to say that this is an Office VBA application, not straight VB. It's a cinche in VB 6, but in Access 2003, the datagrid or flexgrid controls seam to only allow additions and deletions when bound to a table.

I'm trying to add rows without binding the control. I'll try your code anyway in hopes it will work when I get back to my production computer...

Member Avatar for agrothe

anto_nee, thats exactly right. Problem with Access is it doesn't give you all the properties in the properties drop down, and of course after a while we get lazy and forget all the properties available to us. :)

Member Avatar for Yomet

Have you tried ".AddItem" with column values separated by "vbTab"?

Yomet

Member Avatar for agrothe

Have you tried ".AddItem" with column values separated by "vbTab"?

Yomet

I dunno, that was 2 years ago :P !!

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.