 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 2 / July 2007Datasheet Form
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é. Can you use a continuous form instead?  SignatureDoug Steele, Microsoft Access MVP http://I.Am/DougSteele (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é. >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 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é. >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 |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.