Datasheet Form

[gatarossi]

Dear all,

I created a new form, then I put two unbound textbox. I modified his
property to datasheet layout, but when I open it I can´t put more than
one line of data. What can I do?

Thanks

André.

 

[Douglas J. Steele]

Can you use a continuous form instead?

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


Dear all,

I created a new form, then I put two unbound textbox. I modified his
property to datasheet layout, but when I open it I can´t put more than
one line of data. What can I do?

Thanks

André.

 

[Scott McDaniel]

Dear all,

I created a new form, then I put two unbound textbox. I modified his
property to datasheet layout, but when I open it I can´t put more than
one line of data. What can I do?

Is the form Bound? I know your two textboxes are not, but you can have unbound textboxes on bound forms. If the form is
bound, the form will show only the records in the underlying recordsource. If it's not bound, then it'll only show one
record at a time ...

If it IS bound: Have you set the form to AllowAdditions? Check this in the Design view of the form ...

Thanks

André.

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com

 

[gatarossi]

Dear Scott/Douglas,

The form is unbound too. I'm trying to put the datas as we put in a
excel's sheet, then I will try to uptade the table with a consult of
update/insert.

Is it possible?

Thanks

André.

 

[Scott McDaniel]

Dear Scott/Douglas,

The form is unbound too. I'm trying to put the datas as we put in a
excel's sheet, then I will try to uptade the table with a consult of
update/insert.

AFAIK, the Unbound form will show only one record whether you use Datasheet or Continuous view as Doug suggests. I'm not
sure how you'd go about doing this ... there's always Grid controls (the Janus GridEx works in the Access environment
and would do what you want), or the MSFlexGrid ...

Is it possible?

Thanks

André.

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com