#Deleted & Record is Deleted Issue
- Thread starter ollyjolly
- Start date
BigHappyDaddy
Coding Monkey Wanna-Be
- Local time
- Yesterday, 16:20
- Joined
- Aug 22, 2012
- Messages
- 205
I am not sure if this is the issue, but it popped into my head as I was reading this forum string.
First, is the form an bound or unbound form? If bound, at anytime during the entering of data, if the network connection is lost, the record on the BE may be <deleted>. Well not deleted, but not fully created and saved. The lost network connection may force Access to discard this record in progress.
If this is the case, can you try an unbound form and when the user does submit the record, append the data provided to the back-end table(s)?
Again, all this is just a thought.
First, is the form an bound or unbound form? If bound, at anytime during the entering of data, if the network connection is lost, the record on the BE may be <deleted>. Well not deleted, but not fully created and saved. The lost network connection may force Access to discard this record in progress.
If this is the case, can you try an unbound form and when the user does submit the record, append the data provided to the back-end table(s)?
Again, all this is just a thought.
BigHappyDaddy thank you! The form is bound form. I am not very familiar using unbound forms so I will do some research to determine how to pass the data to the BE table. I figure at this point it is worth a shot.
BigHappyDaddy
Coding Monkey Wanna-Be
- Local time
- Yesterday, 16:20
- Joined
- Aug 22, 2012
- Messages
- 205
Personally I would create a query to append the data to the BE table. Have the query created when the user submits the record. Just use the various text boxes / combo boxes values, etc to populate the table.
Code:
strSQL = "INSERT INTO [BackEndTable] ( [Field1], [Field2], [Field3])
"SELECT Form!frmName!TextBox1 AS Expr1, " & _
"Form!frmName!TextBox2 AS Expr2, " & _
"Form!frmName!ComboBox1 AS Expr3;"
CurrentDb.Execute strSQLOk so I would update the code you provided with the appropriate BE table and field names, and form field names. After doing that do I just place it in the VBA under the All load Click event so when the user clicks to add a new record it updates the table?
Also, how do I change the form from bound to unbound?
Also, how do I change the form from bound to unbound?
BigHappyDaddy
Coding Monkey Wanna-Be
- Local time
- Yesterday, 16:20
- Joined
- Aug 22, 2012
- Messages
- 205
The location of the code would go und r the command button click event.
As for making the form unbound, simply remove the record source of the form. Now it is not bounded to any dataset.
But i expect that would cause other issues . Instead try creating a new unbound form for the user to populate. You could display this new form as a popup or a subform in your current form.
As for making the form unbound, simply remove the record source of the form. Now it is not bounded to any dataset.
But i expect that would cause other issues . Instead try creating a new unbound form for the user to populate. You could display this new form as a popup or a subform in your current form.
