473,320 Members | 1,921 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Deleted Records in a table, now my form is not working...

KC
I am using Access 2002, with a database template from MS Office. The
Orders Management Database. I have tweaked this for use with our
company. It is a small database with close to a 1000 records in our
Orders table. Within this table are 80 records that I decided to
delete to clean it up a bit. When I went into my data entry form, I
noticed the bottom portion of the form was blank, this is usually the
area that contains each customers order history. The top portion was
fine, this is customer address info.
When looking at the customer, order and payment tables, all of the data
is still there, but it's the form that is now not working properly. I
have tried pasting the deleted records back into it's original state,
but that doesn't do anything.

Can anyone tell me what I did wrong? Plus, is there a way to repair
the form so I can see the customer order history in the form again?

P.S. I am not a programmer. Was able to play around with it for a few
years, but now it looks like I played with it a litte too much.

Thanks,

Kim.

Nov 13 '05 #1
1 1966
KC wrote:
I am using Access 2002, with a database template from MS Office. The
Orders Management Database. I have tweaked this for use with our
company. It is a small database with close to a 1000 records in our
Orders table. Within this table are 80 records that I decided to
delete to clean it up a bit. When I went into my data entry form, I
noticed the bottom portion of the form was blank, this is usually the
area that contains each customers order history. The top portion was
fine, this is customer address info.
When looking at the customer, order and payment tables, all of the data
is still there, but it's the form that is now not working properly. I
have tried pasting the deleted records back into it's original state,
but that doesn't do anything.

Can anyone tell me what I did wrong? Plus, is there a way to repair
the form so I can see the customer order history in the form again?

P.S. I am not a programmer. Was able to play around with it for a few
years, but now it looks like I played with it a litte too much.

Thanks,

Kim.

Kim, it sounds like there is a one to many relationship. And from your
description it appears this is a MainForm/Subform problem. For example,
the Mainform presents your customer info and the Subform presents the
order history. Usually there is a field that links the two tables
together...for example an OrderId.

It's quite possible that OrderID may be an autonumber field (check the
tables in question used in the Recordsource of the forms). So lets say
you put back the deleted record. It will now have a new OrderId field
number (because it is an autonumber) and those records in history have
nothing to link to (it's pointing to an autonumber that no longer exists).

What you need to do, if this is an autonumber field used in linking the
two tables, is recreate the deleted record and find the associated
history records and update the link field in the history table

If you have hard copy of the orders, you may be better off simply
recreating the orders. It's work, I know, but it may be quicker to
re-input than fuss with this.

If you decide to do some fussing, I highly recommend you check out
FindUnmatched queries...go to the Query tab, press New, and select
FindUnmatched. This way you can find out with OrderHistory records have
no matching Order record or visa versa.
Nov 13 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: GordoBR | last post by:
I have an A2K app that I deplyed a year ago in a multiuser environment (only 3-4 users max). The users recently drew my attention to a very odd thing: For one of their records a "Comments" field...
10
by: DaveDiego | last post by:
I've had a user delete one of the client records, I do have a version of the DB with all records intact before the deletion occured. Whats the best approach to getting all the related records in...
5
by: Grant | last post by:
Hi Is there a way to recover deleted records from a table. A mass deletion has occurred and Access has been closed since it happened Louis
2
by: Bob | last post by:
I have a form, and a subform based on a query. I want to delete specific records from my table based on certain conditions. I mean, when the user adds a new record to the subform, the form saves...
3
by: BrianDP | last post by:
I have a database with a split front end/back end. There is a key table in the back end called Catalog, and it is sort of a central key table for all sorts of things. It's a list of all the jobs...
6
by: jpatchak | last post by:
Hello, I have a main form with one subform. I have a command button on the main form to delete the current record. Below is my code. The tables on which the main form and subform are based...
12
by: jpatchak | last post by:
Hello all, I have an annoying message popping up every time I close a form. Due to performance issues, I am caching data from a linked table on a SQL Server into a temporary local table. The...
3
by: Taco | last post by:
Dear forum, First, this is my first post here, so please be kind. I have been taking a look over this place for a while now and it seems like the right place to be. Alright the issue at hand:...
3
by: marcf | last post by:
Hi Everyone, Hopefully someone will be able to offer a suggestion to this problem. I have a multi user CMS running at work which I wrote. Aside from a few bugs everything has been going fine...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.