If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
cannot change the date
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 |
#2
|
|||
|
|||
On Tue, 30 Nov 2004 10:39:08 -0800, JRS
wrote: 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 |
#3
|
|||
|
|||
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" wrote: On Tue, 30 Nov 2004 10:39:08 -0800, JRS wrote: 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 |
#4
|
|||
|
|||
On Tue, 30 Nov 2004 20:33:07 -0800, JRS
wrote: 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 |
#5
|
|||
|
|||
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" wrote: On Tue, 30 Nov 2004 20:33:07 -0800, JRS wrote: 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 |
#6
|
|||
|
|||
On Wed, 1 Dec 2004 07:39:03 -0800, JRS
wrote: 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Dates in a listbox connected to a form... | RusCat | Using Forms | 13 | November 25th, 2004 02:31 AM |
If I change a date in a date column how do I get the dates below . | vpr | General Discussion | 2 | September 9th, 2004 03:58 AM |
Formatting dates in Excel | bernrunner15 | New Users | 4 | May 11th, 2004 10:32 PM |
cell to change colour at given date - how to | Tobit | Worksheet Functions | 2 | September 17th, 2003 12:20 PM |