473,379 Members | 1,544 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,379 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 2368
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...
1
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: 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...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

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.