Deleted Items in Tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When we delete and item, like an order, the table or the query on which the
form is made on shows that item as "Deleted" and it stays there until the
database is re-started. In my form a calculated field counts the number of
orders for each customer's history so when we delete an order the value in
this field remains wrong until we restart the database. If we make a report
prior to re-starting the report is wrong. How can I completely get rid of
the "Deleted" item without having to restart the database?
 
YourQueryName.Requiry after the delete.
When we delete and item, like an order, the table or the query on which the
form is made on shows that item as "Deleted" and it stays there until the
database is re-started. In my form a calculated field counts the number of
orders for each customer's history so when we delete an order the value in
this field remains wrong until we restart the database. If we make a report
prior to re-starting the report is wrong. How can I completely get rid of
the "Deleted" item without having to restart the database?
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem Deleting a Field - wants parameter for missing field...??? 4
Navigation buttons not bound to correct table 1
Counting a specific item in a form or report 2
Random lists PRINT identical items daily 7
Bound control doesn't update table 2
Automatically create a record in a subform 1
Enter Parameter Value in Access Form 0
Problem with multiplying value of two fields from different tables 4

Back
Top