PC Review


Reply
Thread Tools Rate Thread

datasheetview-get values programmaticaly

 
 
=?Utf-8?B?bWFYaW0=?=
Guest
Posts: n/a
 
      27th Sep 2006
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 ?
 
Reply With Quote
 
 
 
 
Marshall Barton
Guest
Posts: n/a
 
      27th Sep 2006
maXim wrote:

>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.

--
Marsh
MVP [MS Access]
 
Reply With Quote
 
=?Utf-8?B?bWFYaW0=?=
Guest
Posts: n/a
 
      28th Sep 2006
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" wrote:

> maXim wrote:
>
> >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.
>
> --
> Marsh
> MVP [MS Access]
>

 
Reply With Quote
 
Marshall Barton
Guest
Posts: n/a
 
      28th Sep 2006
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.
--
Marsh
MVP [MS Access]


maXim wrote:

>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" wrote:
>
>> maXim wrote:
>>
>> >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.
>>


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Hide column in datasheetview rum23 Microsoft Access Forms 3 10th Nov 2008 03:30 PM
Subform - datasheetview =?Utf-8?B?U2FuZHk=?= Microsoft Access Form Coding 1 27th Jun 2007 03:58 AM
Subform/DatasheetView/Font Change? Tim Fierro Microsoft Access Forms 3 19th Aug 2005 05:00 PM
Datasheetview and Formview button on toolbar TNL Microsoft Access Forms 1 13th Feb 2004 08:42 AM
Programmaticaly compress a pst Fernando Rodriguez Microsoft Outlook VBA Programming 1 7th Oct 2003 09:50 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:16 PM.