Re: In Access 2007 why does info disappear?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I am using a table datasheet. I did not set a filter. You must realize I
know very little about Access. This was thrown on my desk to learn. I know
that it was not caused by scrolling. For example: record #1 I entered an
employee's name and a general contractors name. I then arrowed to record #2.
As I was entering the next employee name the first record disappeard. If I
save and close and then reopen the first record reappears. On occasions when
I save, close and reopen the data in all columns is nothing but XXXXXXXXXX's.
I appreciate anything you have to offer.

"John W. Vinson" wrote:

On Tue, 1 Apr 2008 13:09:03 -0700, smprice <smprice@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote:

After making an entry and moving to next line the data disappears from the
previous line. I have to save and close database. When I reopen the data is
there.
Does anyone know why? Also, sometimes the data entry is nothing but XXXXX's.

More info please. Are you using a Form, or the table datasheet? Do you have a
Filter set on the form (or table), and if so does the data you're entering
pass the filter? Are you sure it isn't just scrolling up offscreen? What's the
datatype of the fields in which you're entering, and just what do you mean by
"the data entry is nothing but XXXXXX" - in all fields, selected fields?
--

John W. Vinson [MVP]

.

Relevant Pages

  • Re: Display a specific record by clicking an open form button-not
    ... The forms wizard presents a screen with 3 options, ... It doesn't necessarily have to filter out the records, ... It just brings me to the first record on the form. ... I tried a macro, as well, but the macro opens the building form with the ...
    (microsoft.public.access.forms)
  • Re: Removing filter loses bookmark
    ... filter, change the sorting, change the RecordSource, or requery the form. ... the first record becomes the default? ... before I reset the form's recordsource, and then in the ontimer event, I ...
    (microsoft.public.access.formscoding)
  • Re: Selecting records in datasheet view
    ... > she builds the filter on the fly). ... > brought to a new form that displays the filtered set in datasheet view. ... > listbox of identifiers that match the datasheet items. ...
    (microsoft.public.access.forms)
  • Re: Email a Receipt
    ... This would help build the filter to for example send emails to the 4 people selected. ... address field in my datasheet to insert the email address. ... "Mark Andrews" wrote: ... and attach it. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Cannot open table in ADP
    ... For me this looks like a minor bug. ... table in design view and check the property sheet for any Order By or Filter ... Delete those, save the design, and your datasheet view should ...
    (microsoft.public.access.adp.sqlserver)