Hallo,

ich bin neu in diesem Forum.

Kann mir jemand Helfen zum dem IGrid Activex zu VBA und Excell.

Ich möchte eine ADODB Anbinden und mit Igrid die Daten direct Speichern wie könnte man dass machen.

Danke euch für eure Hilfe .

mfg

Georg

Georg,

You could get more answers if you asked your questions in English. Can you use this language to communicate?

If you need to upload ADO data into iGrid, you can use iGrid's FillFromRS method. To implement data binding, you need to write some code as FillFromRS just copies data into iGrid.

If you explain your problem better in English, we can be more helpful.

Georg,

You could get more answers if you asked your questions in English. Can you use this language to communicate?

If you need to upload ADO data into iGrid, you can use iGrid's FillFromRS method. To implement data binding, you need to write some code as FillFromRS just copies data into iGrid.

If you explain your problem better in English, we can be more helpful.

Thanks for then Anwers.

Hello

Thanks for the answer

unfortunately I do not speak English well

I want to bind an ADO Recordset and then save the values.
An info box has a Mulltiline field.

How can I save the data directly again with Igrid
Are there any examples for download
Is it possible to limit the entries to numbers?

Kind regards

Georg

The main demo of iGrid ActiveX contains several samples demonstrating how to edit data tables with iGrid. You'll find these samples in the Editing Databases sample group.

To limit user input, you can use the BeforeCommitEdit event or even TextEditKeyPress to filter the characters that may appear in the cell editor.

To edit multiline texts, specify the igTextWordBreak flag in the CellTextFlags property for the corresponding cells.

See the demo and the help file for iGrid for more info.

Can you tell us what is your development environment?

Hello,

Thank you for the help.

I have excel 2016 with vba and adodb
Unfortunately I could not find any source code for data storage with igrid.
Could you possibly send me one?


mfg

Georg

The main demo of iGrid ActiveX contains several samples demonstrating how to edit data tables with iGrid. You'll find these samples in the Editing Databases sample group.

To limit user input, you can use the BeforeCommitEdit event or even TextEditKeyPress to filter the characters that may appear in the cell editor.

To edit multiline texts, specify the igTextWordBreak flag in the CellTextFlags property for the corresponding cells.

See the demo and the help file for iGrid for more info.

Can you tell us what is your development environment?

Install the demo of iGrid ActiveX that includes the demo source codes. You can find it on the Download  page. By the way, the demo installator also deploys the CHM help file for iGrid which is also useful.

After installing demo, find the UpdDB_*.frm files in the Demo\Forms subfolder of the main demo source code folder. These files are the source codes of the data binding samples for iGrid I mentioned earlier. The source code of the demo is VB6, but you can use this source code in MS Excel VBA too. To view the file, use a text editor like Notepad.

By the way, the demo installator also deploys samples for VBA. One of these files is iGrid_Samples.mdb and it contains an example of data binding in MS Access.