Cannot save new records

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tim Green - 31 Jan 2006 17:11 GMT

Not sure if *this* is the forum for asking this question, but I inherited a
small access programme, which allows the creation of new records, and has
been doing so, up to now.

Now, I can fill out the new record, or several new records, and page back
and forth between them, but when I exit and then re-enter the programme, the
new records are no longer there. They have not been saved.

Updates to *existing* records, however, *are* saved.

Is there a common 'something' to look for when this happens?

Thanks.

Reply to this Message

Rick B - 31 Jan 2006 17:35 GMT

You say they are not there. Are you sure? Have you actually looked at the
table to see if they are there? Maybe your form is limiting what is
displayed.

Signature

Rick B

> Not sure if *this* is the forum for asking this question, but I inherited
> a small access programme, which allows the creation of new records, and
[quoted text clipped - 9 lines]
>
> Thanks.

Reply to this Message

Tim Green - 31 Jan 2006 18:01 GMT

Rick,

You are correct--they *are* in the table. But they don't show. I looked at
the Filter options, but I'm not sure where to check to see if a filter is,
in fact, in effect. I suspect there must be one, because if I back-date my
computer to a date in 2005, I can add (and see) new records.

How would I check to see why I wouldn't be able to see anything I enter with
a 2006 date? Would that be a filter? Are filters somehow attached to forms,
and therefore changeable?

Tim

> You say they are not there. Are you sure? Have you actually looked at
> the table to see if they are there? Maybe your form is limiting what is
[quoted text clipped - 13 lines]
>>
>> Thanks.

Reply to this Message

Rick B - 31 Jan 2006 18:28 GMT

Look at the query upon which tour forms and or reports are based and see if
there is any criteria stating that records after a certain date should not
be pulled.

Signature

Rick B

> Rick,
>
[quoted text clipped - 27 lines]
>>>
>>> Thanks.

Reply to this Message

Tim Green - 31 Jan 2006 19:02 GMT

Rick,

I found it before I read this message, but you were absolutely right: the
form was based on a query, and the query had the first and last dates of
2005 (with a BETWEEN). As soon as I changed those to 2006, presto!

Thanks for your help. :)

Tim

> Look at the query upon which tour forms and or reports are based and see
> if there is any criteria stating that records after a certain date should
[quoted text clipped - 31 lines]
>>>>
>>>> Thanks.

Reply to this Message