S
Sue R
Suddenly we are unable to add new records in form view. We are able to add
new records in table view. Anyone know why this would happen?
new records in table view. Anyone know why this would happen?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
6
'69 Camaro
Hi, Sue.
Yes. The form's properties have changed, probably accidentally. Open the
form in Design View and ensure that the "Allow Additions" property is set to
"Yes," and the "Recordset Type" is _not_ set on "Snapshot." Recently added
VBA code in a module that changes these properties could be to blame if the
form's properties in the Properties dialog window appear to be in order.
The problem you are experiencing can also be caused by using a
non-updateable recordset as the form's "Record Source" property, but it
sounds like your form's "Record Source" property is set to the table's name
(which you have described as updateable), not a query name or SQL statement,
so it isn't a problem.
HTH.
Gunny
See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.
(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
- - -
When you see correct answers to your question posted in Microsoft's Online
Community, please sign in to the Community and mark these posts as "Answers,"
so that all may benefit by filtering on "Answered questions" and quickly
finding the right answers to similar questions. (Only "Answers" have green
check-marks.) Remember that the best answers are often given to those who
have a history of rewarding the contributors who have taken the time to
answer questions correctly.
Suddenly we are unable to add new records in form view. We are able to add
new records in table view. Anyone know why this would happen?
Yes. The form's properties have changed, probably accidentally. Open the
form in Design View and ensure that the "Allow Additions" property is set to
"Yes," and the "Recordset Type" is _not_ set on "Snapshot." Recently added
VBA code in a module that changes these properties could be to blame if the
form's properties in the Properties dialog window appear to be in order.
The problem you are experiencing can also be caused by using a
non-updateable recordset as the form's "Record Source" property, but it
sounds like your form's "Record Source" property is set to the table's name
(which you have described as updateable), not a query name or SQL statement,
so it isn't a problem.
HTH.
Gunny
See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.
(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
- - -
When you see correct answers to your question posted in Microsoft's Online
Community, please sign in to the Community and mark these posts as "Answers,"
so that all may benefit by filtering on "Answered questions" and quickly
finding the right answers to similar questions. (Only "Answers" have green
check-marks.) Remember that the best answers are often given to those who
have a history of rewarding the contributors who have taken the time to
answer questions correctly.
S
Sue R
Thanks for your answer--unfortunately it didn't fix it--the Allow Additions
property was set to yes and the Recordset Type is Dynaset. The Record Source
is a query, but as far as I know that's what it's always been set to.
Thanks!
property was set to yes and the Recordset Type is Dynaset. The Record Source
is a query, but as far as I know that's what it's always been set to.
Thanks!
R
Rick Brandt
Sue said:Thanks for your answer--unfortunately it didn't fix it--the Allow
Additions property was set to yes and the Recordset Type is Dynaset.
The Record Source is a query, but as far as I know that's what it's
always been set to.
Try to edit something directly in the query. My guess is you won't be able
to. Check the help topic named "When can I update data in a query?".
6
'69 Camaro
Hi, Sue.
If everything else checks out, let's check your query. Please post the SQL
statement from the query's SQL View pane (or the SQL statement in the form's
"Record Source" Property, if that's what you're using).
HTH.
Gunny
See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.
(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
- - -
When you see correct answers to your question posted in Microsoft's Online
Community, please sign in to the Community and mark these posts as
"Answers," so that all may benefit by filtering on "Answered questions" and
quickly finding the right answers to similar questions. (Only "Answers"
have green check-marks.) Remember that the best answers are often given to
those who have a history of rewarding the contributors who have taken the
time to answer questions correctly.
the Allow Additions
property was set to yes and the Recordset Type is Dynaset. The Record
Source
is a query,
If everything else checks out, let's check your query. Please post the SQL
statement from the query's SQL View pane (or the SQL statement in the form's
"Record Source" Property, if that's what you're using).
HTH.
Gunny
See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.
(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
- - -
When you see correct answers to your question posted in Microsoft's Online
Community, please sign in to the Community and mark these posts as
"Answers," so that all may benefit by filtering on "Answered questions" and
quickly finding the right answers to similar questions. (Only "Answers"
have green check-marks.) Remember that the best answers are often given to
those who have a history of rewarding the contributors who have taken the
time to answer questions correctly.