If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Controlling a datasheet form with unbound text boxes
Hi All
I have an unbound form set to Dataasheet view that uses 5 unbound text boxes. I would like the form to add a new line each time I have completed one row of data entry and then have my Insert Into query grab eaqch line of data as a separate record to insert into my table. Is this possible? I cant seem to get the datasheet view to add another line at the end of each completed record. Thanks |
#2
|
|||
|
|||
Controlling a datasheet form with unbound text boxes
On Sat, 31 Oct 2009 09:11:09 -0700 (PDT), BWD
wrote: No. You will have to bind those controls to an underlying table. Then you get this behavior automatically. -Tom. Microsoft Access MVP Hi All I have an unbound form set to Dataasheet view that uses 5 unbound text boxes. I would like the form to add a new line each time I have completed one row of data entry and then have my Insert Into query grab eaqch line of data as a separate record to insert into my table. Is this possible? I cant seem to get the datasheet view to add another line at the end of each completed record. Thanks |
#3
|
|||
|
|||
Controlling a datasheet form with unbound text boxes
An unbound form in datasheet view doesn't make a lot of sense to me. What
are you trying to accomplish? From your description, it seems you could do what you want with a form with the "Allows additions" set to yes in the "Data" tab of its Properties Dialog. That lets you type in new records and automatically writes them to the Form's RecordSource when you move to another record or close the form or take specific programmatic action to write the record. Larry Linson Microsoft Office Access MVP "BWD" wrote in message ... Hi All I have an unbound form set to Dataasheet view that uses 5 unbound text boxes. I would like the form to add a new line each time I have completed one row of data entry and then have my Insert Into query grab eaqch line of data as a separate record to insert into my table. Is this possible? I cant seem to get the datasheet view to add another line at the end of each completed record. Thanks |
#4
|
|||
|
|||
Controlling a datasheet form with unbound text boxes
I started to write that an unbound form only contains one record, but in
point of fact, it contains no record at all. All it does is hold data that has been entered. Following Tom's post, you can bind the form to a temporary table, and then append the records to a permanent table, but once again, the important question is ***why*** you're using an unbound form. The reasons given by posters are usually based on misunderstandings on their part. Bound forms and the rapid develpment they allow are a huge part of Access' strength. To be honest, if you're not going to use bound forms, you'd probably be better off developing your app in another language, like Visual Basic or VB.Net, with an alternative backend like Oracle or SQLServer. There would be no more work involved, you could distribute the app as an EXE file, not dependent on some version of Access being on board each machine, and the security would be much better than that available with Access. -- There's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000/2003 Message posted via http://www.accessmonster.com |
Thread Tools | |
Display Modes | |
|
|