By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,594 Members | 3,291 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,594 IT Pros & Developers. It's quick & easy.

Deleting records in table causes missing data in a form

P: n/a
KC
Hello,

I am using Access 2002. WinXP, Template from MS called Orders Mgmt DB.
I have tweaked this DB to work for our small co.
It has worked pretty well up until I made the mistake of deleting about
80 records from the Orders table. 80 out of a 1000 records.
Now our data entry form shows our customer addresses, but not customer
order history. When looking at all of the tables, customer, payments,
orders, they still have all of the current data. I tried putting the
deleted records back, but this had no effect on the form, it's still
1/2way blank.

What did I do? What can I do to fix? I am not a programmer and this
has worked fine for us that last few years. Anyone's help would be
appreciated.

Thanks,

Kim.

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Hi Kim,

Salad gave you a pretty good answer in your same question
'Deleting records in table causes missing data in a form'

One other thing might be a way for you (depends on when you deleted the records):
Just restore from a backup, and only recreate your recent data.

Since you are posting the same question 3 times! this might be important for you.
I could try to recreate the complete data from both your backup, and your current db.
When the missing data is in your backup I certainly think that it can be done.
Attention please:
If you want me to do it for you, you would be charged a little amount .... (no cure, no pay)

Arno R (Remove the obvious from my email-address)
ar***********@tiscali.nl
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.