cannot change the date

[JRS]

I have a table question that I cannot figure out. I have a date field in my
table. All the records have the field populated with the same
date...12/08/2004. I changed the date in the table to 11/01/2004....when I
open the table all the records have the 11/01 date and if I run a query they
all have the 11/01 date...but if I export that query to a text file....the
text file shows the orginal 12/8. How can I correct that on the table end?
thanks

 

[John Vinson]

I have a table question that I cannot figure out. I have a date field in my
table. All the records have the field populated with the same
date...12/08/2004. I changed the date in the table to 11/01/2004....when I
open the table all the records have the 11/01 date and if I run a query they
all have the 11/01 date...but if I export that query to a text file....the
text file shows the orginal 12/8. How can I correct that on the table end?
thanks

It sounds like you may be trying to change the data in the table using
a Form, and that Form has a textbox that you *think* is bound to the
date field in the table but is actually unbound. Could you explain
what steps you're taking to change the date in the table?

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps

 

[JRS]

I opne the table in datashett view. I had a colum/field FROM DATE....and all
of the records are populated with 12/8/2004 as I initially wanted. And then
I changed the date in that field in the table datasheet view to 11/1/2004 as
I needed to do that for all records. I did that by highlighting the column
abd using the FIND feature...I found the 12/8 and replaced with 11/1. And it
looked like it was done as all the records said that date in that field.
Later I was downloading that info into a text file to load into another table
(long story)....and what is saw on the text file was the 12/8 date..but the
field in the datavbase currently had 11/1. So I need to knwo how to fix
that, but also I guess a general question....can to the data in a table in
Access? thanks

 

[John Vinson]

I opne the table in datashett view. I had a colum/field FROM DATE....and all
of the records are populated with 12/8/2004 as I initially wanted. And then
I changed the date in that field in the table datasheet view to 11/1/2004 as
I needed to do that for all records. I did that by highlighting the column
abd using the FIND feature...I found the 12/8 and replaced with 11/1. And it
looked like it was done as all the records said that date in that field.
Later I was downloading that info into a text file to load into another table
(long story)....and what is saw on the text file was the 12/8 date..but the
field in the datavbase currently had 11/1. So I need to knwo how to fix
that, but also I guess a general question....can to the data in a table in
Access? thanks

I'm sorry, but this is not making ANY sense. You say "highlighting the
column and using the FIND feature" - that's not a good way to edit
data; an Update query would be much better. And how you can export
11/1 and have it end up 12/8 also is unclear; could you perhaps have
written out a file before the change and not overwritten it?

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps

 

[JRS]

no i DON'T THINK SO BUT i DID AN APPEND QUERY TO THAT FIELD AND THEN RNA A
QUERY AND THEN EXPORTED THE QUERY DATA TO A RTF FILE AND IT SEEMED OK. ARE
YOU SAYING THAT I CANNOT GO INTO A CELL IN A TABLE AND CHANGE IT MANUALLY...I
WOULD HAVE TO DO AN APPEND QUERY FOR EVERY CHANGE? THANKS

 

[John Vinson]

no i DON'T THINK SO BUT i DID AN APPEND QUERY TO THAT FIELD AND THEN RNA A
QUERY AND THEN EXPORTED THE QUERY DATA TO A RTF FILE AND IT SEEMED OK. ARE
YOU SAYING THAT I CANNOT GO INTO A CELL IN A TABLE AND CHANGE IT MANUALLY...I
WOULD HAVE TO DO AN APPEND QUERY FOR EVERY CHANGE? THANKS

Please lay off the CAPS LOCK. It's hard to read and looks like you're
SHOUTING.

No. I'm not saying that at all.

If you wish to change one value in one record, then simply open the
table in datasheet view - or, better, open a Form based on the table -
and change it there. You can do this if you don't mind manually
changing each record that needs changing.

If you want to change the value of a field in every record (or
selected records) in a table, then the best way is to run an Update
query. Use criteria to select the records to be updated, or to update
all records in the table, just run the update query without criteria.

If you want to append new records which did not previously exist to a
table, run an Append query. It may be that you ran two append queries,
with different dates, and that your table now has twice as many
records as you expect!

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps