Hi BJG,
I hope Lesson No. 2 learned, in case you find yourself having to re-enter
all data, is to always have a back-up of your database available.
Here is a cute little song you for you, to the tune of the Beetles
"Yesterday". I don't know who wrote it:
Yesterday,
All those backups seemed a waste of pay.
Now my database has gone away.
Oh I believe in yesterday.
Suddenly,
There's not half the files there used to be,
And there's a panic
coming over me
The system crashed so suddenly.
I pushed something wrong
What it was I could not say.
Now all my data's gone
and I long for yesterday-ay-ay-ay
Yesterday,
The need for back-ups seemed so far away.
I knew my data was all here to stay,
Now I believe in yesterday.
Tom
http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________
:
Thanks. That is exactly what I did. I looked in the Help because I had a
friend whose zip included letters (England) and it wouldn't take it. Hence,
I changed it to yes/no. Lesson No.1
--
bjg
__________________________________________
:
Did you possibly convert the field in table design view from Text to Yes/No
datatype? If so, I'm afraid your only options include recovering from a
recent back-up, or re-entering all of your data.
Tom
http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________
:
I created a mailing list in access and did something where my zip codes in
the table all changed from 5 diget codes to -1 and 0 's . Can someone tell
me what I did wrong and how to fix it?
