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
|
|||
|
|||
Form leaves table recordset open
I have a simple database but a problem I can't figure out. Objects
a 1) Table A. 2) Form A, used as a front-end tool for data entry for Table A. 3) Button on Form A which drives data to temp tables using queries and performs further calculations. 4) Report in Print Preview showing finished calculations. Problem is: after tabbing off the last field in the form, Access is leaving that recordset open for further entry or editing. Consequently, none of the queries work because no data is saved in the table. How do I get Access to close that recordset? I've tried using gotorecord next, but since the table isn't actually open, that just causes another error. |
#2
|
|||
|
|||
Form leaves table recordset open
Vanessa,
You aren't giving enough information to answer this. Is this a bound form? Is the recordsetclone being open? It sounds like you are tabbing to a new record before you click your button. Open your form in designview. Open the property sheet for the form. Set the Cycle property to "Current Record" on the drop down list. God Bless, Mark A. Sam "Vanessa" wrote in message ... I have a simple database but a problem I can't figure out. Objects a 1) Table A. 2) Form A, used as a front-end tool for data entry for Table A. 3) Button on Form A which drives data to temp tables using queries and performs further calculations. 4) Report in Print Preview showing finished calculations. Problem is: after tabbing off the last field in the form, Access is leaving that recordset open for further entry or editing. Consequently, none of the queries work because no data is saved in the table. How do I get Access to close that recordset? I've tried using gotorecord next, but since the table isn't actually open, that just causes another error. |
#3
|
|||
|
|||
Form leaves table recordset open
On Apr 4, 11:19*am, "Mark A. Sam" wrote:
Vanessa, You aren't giving enough information to answer this. *Is this a bound form? Is the recordsetclone being open? * It sounds like you are tabbing to a new record before you click your button. * Open your form in designview. Open the property sheet for the form. *Set the Cycle property to "Current Record" on the drop down list. God Bless, Mark A. Sam "Vanessa" wrote in message ... I have a simple database but a problem I can't figure out. Objects a 1) Table A. 2) Form A, used as a front-end tool for data entry for Table A. 3) Button on Form A which drives data to temp tables using queries and performs further calculations. 4) Report in Print Preview showing finished calculations. Problem is: after tabbing off the last field in the form, Access is leaving that recordset open for further entry or editing. Consequently, none of the queries work because no data is saved in the table. How do I get Access to close that recordset? I've tried using gotorecord next, but since the table isn't actually open, that just causes another error.- Hide quoted text - - Show quoted text - Thanks - it's a form bound to a table - really just a front-end data entry tool. What i'd like to be able to do is to have the user tab off the last field in the record and then click a calculate button. however, the form is leaving the record open for editing (ie, it has the pencil symbol in the corner, as if it's waiting to complete some input)- - that means that none of the data entered pass through to the queries and scratch tables that perform the calculations. |
#4
|
|||
|
|||
Form leaves table recordset open
Vanessa,
In the last control (or any data control for that matter) place this line in the AfterUpdate event of the control: DoCmd.RunCommand acCmdSaveRecord This will update the form's underlying table. God Bless, Mark A. Sam "Vanessa" wrote in message ... On Apr 4, 11:19 am, "Mark A. Sam" wrote: Vanessa, You aren't giving enough information to answer this. Is this a bound form? Is the recordsetclone being open? It sounds like you are tabbing to a new record before you click your button. Open your form in designview. Open the property sheet for the form. Set the Cycle property to "Current Record" on the drop down list. God Bless, Mark A. Sam "Vanessa" wrote in message ... I have a simple database but a problem I can't figure out. Objects a 1) Table A. 2) Form A, used as a front-end tool for data entry for Table A. 3) Button on Form A which drives data to temp tables using queries and performs further calculations. 4) Report in Print Preview showing finished calculations. Problem is: after tabbing off the last field in the form, Access is leaving that recordset open for further entry or editing. Consequently, none of the queries work because no data is saved in the table. How do I get Access to close that recordset? I've tried using gotorecord next, but since the table isn't actually open, that just causes another error.- Hide quoted text - - Show quoted text - Thanks - it's a form bound to a table - really just a front-end data entry tool. What i'd like to be able to do is to have the user tab off the last field in the record and then click a calculate button. however, the form is leaving the record open for editing (ie, it has the pencil symbol in the corner, as if it's waiting to complete some input)- - that means that none of the data entered pass through to the queries and scratch tables that perform the calculations. |
#5
|
|||
|
|||
Form leaves table recordset open
On Apr 15, 2:30*pm, "Mark A. Sam" wrote:
Vanessa, In the last control (or any data control for that matter) place this line in the AfterUpdate event of the control: DoCmd.RunCommand acCmdSaveRecord This will update the form's underlying table. God Bless, Mark A. Sam "Vanessa" wrote in message ... On Apr 4, 11:19 am, "Mark A. Sam" wrote: Vanessa, You aren't giving enough information to answer this. Is this a bound form? Is the recordsetclone being open? It sounds like you are tabbing to a new record before you click your button. Open your form in designview. Open the property sheet for the form. Set the Cycle property to "Current Record" on the drop down list. God Bless, Mark A. Sam "Vanessa" wrote in message ... I have a simple database but a problem I can't figure out. Objects a 1) Table A. 2) Form A, used as a front-end tool for data entry for Table A. 3) Button on Form A which drives data to temp tables using queries and performs further calculations. 4) Report in Print Preview showing finished calculations. Problem is: after tabbing off the last field in the form, Access is leaving that recordset open for further entry or editing. Consequently, none of the queries work because no data is saved in the table. How do I get Access to close that recordset? I've tried using gotorecord next, but since the table isn't actually open, that just causes another error.- Hide quoted text - - Show quoted text - Thanks - it's a form bound to a table - really just a front-end data entry tool. What i'd like to be able to do is to have the user tab off the last field in the record and then click a calculate button. however, the form is leaving the record open for editing (ie, it has the pencil symbol in the corner, as if it's waiting to complete some input)- - that means that none of the data entered pass through to the queries and scratch tables that perform the calculations.- Hide quoted text - - Show quoted text - WORKED LIKE A CHARM! thankx!!!! |
Thread Tools | |
Display Modes | |
|
|