473,326 Members | 2,148 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,326 software developers and data experts.

Deleting records in table makes hinders data entry form

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
1 2365
KC wrote:
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.

Access is a relational database. That means there is a relation between
different
types of records. In your case there is a relationship (by using the
order number) ,
between the order records and the payments or any other records that
have a child
relationship to the order. Just as the order records is a child records
of the customer.

It looks to me that the database was not setup with "Enforce Referential
Integrity" enabled.
By enforcing referential integrity, when an order record is deleted, all
of the payment and any
other child records are also deleted.

Whe you design a Form using SubForms, There are properties on the
SubForm that allow
you to tell Access what the relationship will be beetwen the Form
(Parent), and the SubForm
(Child). They are "Link Child Fields" and "Link Master Fields". By
deleting the order records
there is not relationship of the existing payemnt records to the
customer. This may be why
the records do not display when you show a given customer record.

I don't know why the records don't re-display when you put the order
records back The only
thing I can think of is... you didn't put them back correctly. You
need to look at the record
source of the Form and SubForm to see if there is any other data that is
required or not required
allowing the records to be displayed. The record source may be a
query. If so, there is criteria
set in the query that will tell the SubForm(s) which records to display
when a given
customer record is in the main Form.

You should always do backups before doing anything major to your
database. Also,
you should be doing backups on a schedule in the event your database is
lost. Then
you can recover it back to some point in time. Could be a day, week, or
a month.
This depends upon the application and your company's accounting policy.
Some backup
weekly and also an end-of-month back. This will give you 5 backups each
month.
1 for each week and 1 for each month as a example.

Hope This Helps.

Ron

--
Ronald W. Roberts
Roberts Communication
rw*@robcom.com

Nov 13 '05 #2

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

Similar topics

2
by: Iain Miller | last post by:
Struggling a bit here & would be grateful for any help. I have a table which has a list of people in it. Each person has a unique ID automatically allocated by Access but also belongs to one of 5...
1
by: Alex Wisnoski | last post by:
Access 97SR2-I am trying to create a Job Position data entry form based on a table. The form has 15 fields on it. I want to use a combo box to look in the table and see if the position number...
2
by: edworboys | last post by:
I have designed a data entry form with a number of fields and a sub form. The first field (Country) is a combo box and the user selects a country. This, in turn reduces the number of options in the...
5
by: Aspnot | last post by:
Background: I have a data entry form that is bound to a DataSet. This DataSet contains 9 tables and the form displays data from each table in textboxes, not a DataGrid. One of the tables in the...
2
by: filbennett | last post by:
Hi Everyone, I'm generally unfamiliar with Access form design, but have programmed Cold Fusion applications for a couple of years. I'd like to build a data entry form in Access that allows the...
1
by: Gino Perruti | last post by:
I am converting an old ASP data entry form to ASP.NET 1.1. The old form has a script block that dynamically adds rows to a table that contain cells with a textbox for quantity, product...
4
by: JohnnyMid | last post by:
I am working on a database, and have been having some trouble with the auto number feature. Occasionally, the data entry form is saving blank records into the table. I am trying to figure out a way...
9
by: tbeers | last post by:
I apologize for what is probably a simple solution. I have a data entry form that I use to enter work times. I have the default view set to "continuos forms" and the form is enter through a...
0
by: Tyler | last post by:
Made a data entry form which is a subform. I made a continuous form that displays everything entered through the data entry form. The data entry form displays all of the records. This doesn't...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
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: 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: 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...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

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.