I was working in my Access when all of a sudden a column disappeared. I went
to a report and the info is missing off that page as well. How can I recover
the lost column?

Peggy wrote:
> I was working in my Access when all of a sudden a column disappeared.
> I went to a report and the info is missing off that page as well.
> How can I recover the lost column?

First make a copy of the database and work with the copy not the
original

Open the copy and see if you can do a repair and compact. (See the
tools menu)

Does that help?

--
Joseph Meehan

Dia duit

Peggy <Peggy @discussions.microsoft.com> wrote:

>I was working in my Access when all of a sudden a column disappeared. I went
>to a report and the info is missing off that page as well. How can I recover
>the lost column?

Is the width of the column in the datasheet view set to zero?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

Tony Toews wrote:
> Peggy <Peggy @discussions.microsoft.com> wrote:
>
>> I was working in my Access when all of a sudden a column
>> disappeared. I went to a report and the info is missing off that
>> page as well. How can I recover the lost column?
>
> Is the width of the column in the datasheet view set to zero?

I should of thought of that. It that the voice of experience speaking?
:-)

>
> Tony

--
Joseph Meehan

Dia duit

I did that and nothing changed or came back. Thanks so much for the help,
tho! I know very little about this program as it was set up by an assistant
and she is gone. Guess it is time for me to take a class or two on Access!

"Joseph Meehan" wrote:

> Peggy wrote:
> > I was working in my Access when all of a sudden a column disappeared.
> > I went to a report and the info is missing off that page as well.
> > How can I recover the lost column?
>
> First make a copy of the database and work with the copy not the
> original
>
> Open the copy and see if you can do a repair and compact. (See the
> tools menu)
>
> Does that help?
>
> --
> Joseph Meehan
>
> Dia duit
>
>
>

No, it is not, wish it was that easy tho! Thanks very much for your help,
Tony!

"Tony Toews" wrote:

> Peggy <Peggy @discussions.microsoft.com> wrote:
>
> >I was working in my Access when all of a sudden a column disappeared. I went
> >to a report and the info is missing off that page as well. How can I recover
> >the lost column?
>
> Is the width of the column in the datasheet view set to zero?
>
> Tony
> --
> Tony Toews, Microsoft Access MVP
> Please respond only in the newsgroups so that others can
> read the entire thread of messages.
> Microsoft Access Links, Hints, Tips & Accounting Systems at
> http://www.granite.ab.ca/accsmstr.htm
>

"Joseph Meehan" <(E-Mail Removed)> wrote:

>>> I was working in my Access when all of a sudden a column
>>> disappeared. I went to a report and the info is missing off that
>>> page as well. How can I recover the lost column?
>>
>> Is the width of the column in the datasheet view set to zero?
>
> I should of thought of that. It that the voice of experience speaking?
>:-)

Ayup.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm