need help

[Natalie]

I have entered information into the database in the table and saved the
changes, however i have entered them in the wrong cells, so i was wondering
how to delete them but every time i try to delete it says i have a validation
rule. Is there anyway to delete the info and reenter it into the correct
cells without messing up the rest of the data in the database?

 

[Gina Whipp]

Natalie,

First, you should not enter your data via the table. Use a form and lay it
out so you can see all the fields at once, hence preventing that problem.

Next, you could remove the validation, fix your table and replace the
validation. Ugly but it will work. OR you will have to delete the row and
reenter.

Lastly, (and not *scolding* you) Access has fields not cells... my initial
*quick* read almost had me sending you to the Excel forum. Try to be
careful what terminolgy you use so we don't give you the wrong information.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Daryl S]

Natalie -

You have a couple of options if there is a lot of data. (If there are only
a few records, then manually correct them using a form.)

If other people are not using the database, you can copy the table into
Excel, make the changes there, and paste the results back in. If there are
autonumber fields, this will cause problems, but if you are more familiar
with Excel, this can make it easier than one record at a time on a form.

If the data problem is because you entered the values for say Field5 into
Field6 and those for Field6 into Field5, then you could copy the structure of
the table into a new table, and run an append query that pulls the data from
the original table and puts it in the right fields. After reviewing the
data, you can then rename the tables so the new one has the original name.

 

[Gina Whipp]

Natalie
First, you should not enter your data via the table. Use a form an
lay i
out so you can see all the fields at once, hence preventing tha
problem
Next, you could remove the validation, fix your table and replace th
validation. Ugly but it will work. OR you will have to delete the ro
an
reenter
Lastly, (and not *scolding* you) Access has fields not cells... m
initia
*quick* read almost had me sending you to the Excel forum. Try to b
careful what terminolgy you use so we don't give you the wron
information
Gina Whip
"I feel I have been denied critical, need to know, information!"
Tremor
I
http://www.regina-whipp.com/index_files/TipList.ht

I have entered information into the database in the table and saved th
changes, however i have entered them in the wrong cells, so i wa
wonderin
how to delete them but every time i try to delete it says i have
validatio
rule. Is there anyway to delete the info and reenter it into th
correc
cells without messing up the rest of the data in the database

--