Unable to navigate to next record

Access 2002, Windows XP, 1 Front end MDB, 1 Back end MDB

I have a subform which points to a table. Navigating from one record
to the next is obviously dead straight forward. However, this seems to
have stopped working periodically. I can have several records
available, and sometimes I cannot move forward or backward a record,
nor create a new one. However, on occasion it does work. I'm obviously
missing something, or have changed something, but just can't work out
what it is. At least, it was nothing on purpose. If I close the MDB
and re-open, it works for a while. Next time I go in, it may not work.

I'm thinking something has become corrupted as I have never seen this
before and nothing has changed. Well, the tables have been moved to a
different MDB file a while back, but the links are OK (inc primary
keys etc) and I can do this fine within the table. There are no
filters on the recordset and the form points directly to the table.
There isn't anything obvious.

I've not changed anything I can think of that would cause this, so any
suggestions would be appreciated. BTW, I don't get any error
whatsoever, just a message saying I can't go to the specified record.

Thanks in advance

Ryan

re: Unable to navigate to next record

When it refuses to move, is the form dirty?

If you display the Record Selector at the left of the record, it shows a
pencil icon when the record is dirty. Is there is some reason why the record
cannot be saved? Is it being dirtied immediately it is loaded (e.g. in the
Current event of the form)? Or is it being dirtied again as soon as it saves
(in the AfterUpdate event of the form)?

If that is not the issue, it could be a corrupted database. You could try
rebuilding it via the 6 steps for the first symptom in this article:
Recovering from Corruption
at:
http://members.iinet.net.au/~allenbrowne/ser-47.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Ryan" <ryanofford@hotmail.com> wrote in message
news:7802b79d.0410250254.69adb4b6@posting.google.c om...[color=blue]
> Access 2002, Windows XP, 1 Front end MDB, 1 Back end MDB
>
> I have a subform which points to a table. Navigating from one record
> to the next is obviously dead straight forward. However, this seems to
> have stopped working periodically. I can have several records
> available, and sometimes I cannot move forward or backward a record,
> nor create a new one. However, on occasion it does work. I'm obviously
> missing something, or have changed something, but just can't work out
> what it is. At least, it was nothing on purpose. If I close the MDB
> and re-open, it works for a while. Next time I go in, it may not work.
>
> I'm thinking something has become corrupted as I have never seen this
> before and nothing has changed. Well, the tables have been moved to a
> different MDB file a while back, but the links are OK (inc primary
> keys etc) and I can do this fine within the table. There are no
> filters on the recordset and the form points directly to the table.
> There isn't anything obvious.
>
> I've not changed anything I can think of that would cause this, so any
> suggestions would be appreciated. BTW, I don't get any error
> whatsoever, just a message saying I can't go to the specified record.
>
> Thanks in advance
>
> Ryan[/color]

re: Unable to navigate to next record

Hi Ryan,
This is just something I do when a form starts acting weird: decompile the
database by adding the "/decompile" (without quotes) switch to the startup
command line. After the decompile, remove the /decompile switch and compact
the database a couple of times then run the form again. This has always
worked for me!

"Ryan" <ryanofford@hotmail.com> wrote in message
news:7802b79d.0410250254.69adb4b6@posting.google.c om...[color=blue]
> Access 2002, Windows XP, 1 Front end MDB, 1 Back end MDB
>
> I have a subform which points to a table. Navigating from one record
> to the next is obviously dead straight forward. However, this seems to
> have stopped working periodically. I can have several records
> available, and sometimes I cannot move forward or backward a record,
> nor create a new one. However, on occasion it does work. I'm obviously
> missing something, or have changed something, but just can't work out
> what it is. At least, it was nothing on purpose. If I close the MDB
> and re-open, it works for a while. Next time I go in, it may not work.
>
> I'm thinking something has become corrupted as I have never seen this
> before and nothing has changed. Well, the tables have been moved to a
> different MDB file a while back, but the links are OK (inc primary
> keys etc) and I can do this fine within the table. There are no
> filters on the recordset and the form points directly to the table.
> There isn't anything obvious.
>
> I've not changed anything I can think of that would cause this, so any
> suggestions would be appreciated. BTW, I don't get any error
> whatsoever, just a message saying I can't go to the specified record.
>
> Thanks in advance
>
> Ryan[/color]

re: Unable to navigate to next record

Thanks for the advice both of you. Will give them a try tonight.

Ta

Ryan

"Barry Wright" <barry.edmund.wright@NOSPAMrogers.com> wrote in message news:<MYSdnY4jR8ULluDcRVn-1Q@rogers.com>...[color=blue]
> Hi Ryan,
> This is just something I do when a form starts acting weird: decompile the
> database by adding the "/decompile" (without quotes) switch to the startup
> command line. After the decompile, remove the /decompile switch and compact
> the database a couple of times then run the form again. This has always
> worked for me!
>
> "Ryan" <ryanofford@hotmail.com> wrote in message
> news:7802b79d.0410250254.69adb4b6@posting.google.c om...[color=green]
> > Access 2002, Windows XP, 1 Front end MDB, 1 Back end MDB
> >
> > I have a subform which points to a table. Navigating from one record
> > to the next is obviously dead straight forward. However, this seems to
> > have stopped working periodically. I can have several records
> > available, and sometimes I cannot move forward or backward a record,
> > nor create a new one. However, on occasion it does work. I'm obviously
> > missing something, or have changed something, but just can't work out
> > what it is. At least, it was nothing on purpose. If I close the MDB
> > and re-open, it works for a while. Next time I go in, it may not work.
> >
> > I'm thinking something has become corrupted as I have never seen this
> > before and nothing has changed. Well, the tables have been moved to a
> > different MDB file a while back, but the links are OK (inc primary
> > keys etc) and I can do this fine within the table. There are no
> > filters on the recordset and the form points directly to the table.
> > There isn't anything obvious.
> >
> > I've not changed anything I can think of that would cause this, so any
> > suggestions would be appreciated. BTW, I don't get any error
> > whatsoever, just a message saying I can't go to the specified record.
> >
> > Thanks in advance
> >
> > Ryan[/color][/color]

re: Unable to navigate to next record

Found it. It won't move when on a specific field as I have some code
at the end to set it to capitals on exit. It's obviously the problem,
so I'll find a way to sort this.

Thanks for the advice anyway.

Ryan