datasheetview-get values programmaticaly

[Guest]

hello i have a subform which opens in datasheetview. all the
columns/textboxes in datasheet form are unbound. so i have to save them
manuully using insert query. so can anyone please tell me how to
programmaticaly get the values in iterations in all the rows in the
datasheetview ?

 

[Marshall Barton]

hello i have a subform which opens in datasheetview. all the
columns/textboxes in datasheet form are unbound. so i have to save them
manuully using insert query. so can anyone please tell me how to
programmaticaly get the values in iterations in all the rows in the
datasheetview ?

Could you explain more about this form and what you are
trying to do? A datasheet form without bound controls is
nonsensical.

 

[Guest]

All what i want to do is to take input from user in a datagrid mode, but i
dont want to use bound textboxes as i need to do some manipulation on the
input data.
so, i am using unbound textboxes in a datasheetview. so is that possible or
any other idea? thanks for your reply

 

[Marshall Barton]

An inbound data entry grid is not anything that's built in
to Access, you will have to use a block of undividual text
boxes with a fixed number of rows.

If you can get by with operating on a single record's data,
then a standard form with invisible bound controls and
visible unbound controls for data entry is not all that
unusual.

OTOH, database operations are far more commonly done by
storing and displaying the values that users enter and using
calculated controls to display derived values.