MS Data Grid Control

[taha]

I am using the MS dataGrid Control in my application to link to an MS Access database.
the problem is that when i add new fields to the database using the control , and press enter , the newly
entered row goes off the Data grid control , although it is updated in the database correctly.
i.e. as soon as i press enter in the last field of the record to be added , this bhaviour
is seen .
Only one record;s space is seen in the control at one time.
I want that i should see which previous records i have entered through the control.

Can anyone help me?

[dmeikle]

hmmm... could be because you're refreshing the database/grid connection when you click enter...

if you HAVE to refresh then maybe write a trigger that date/timestamps the entry, the when refreshing run a query to show all entries with date/time stamp of 'today' or something... but that's kinda sloopy fixing.
you should probably undo the refresh and wait until you press the save button. then have it go row-by-row saving each row 1 at a time in a looping execution, rather than every time you finish a row.

David

[taha]

Thanks.

I think this will solve my problem.

Will let you know however in case it doesn't.

:-)

[taha]

Hi..

No , I am not refreshing it when i press Enter.
However , I forgot to mention an error message that occurs . It is as follows:

"IRow Offset would position you past either end of rowset regardless of CRow value specified. CRow obtained is zero"


Could anyone please help me in solving this problem?

Thanks in advance

I am also facing the same problem .

I would appreciate if somene knows the solution and tells me too.

[dmeikle]

Taha,

could you email the function to me? or the whole form so I could look at your grid properties? Mebbe then I can get a better idea...
actually just copy/paste the grid into a blank form so you don't give away your 'source code' so I can see it's properties, and copy/paste the function for it


David