microsoft access SEARCH by "ISSUE ID"

[staff sergeant]

We are currently using Microsoft Access 2003 free "issues database." This
works GREAT with what we need from a database. It was perfect when the "issue
id" matched the "record" number because we could quickly put the number in
the record field at the bottom of the form and goto that record to update it.
HOWEVER, after using it a while we've noticed that the "record" number keeps
changing on us. and only the "issue id" remains constant. it seems the record
randomly moves. for example our 150th issue will be record # 150 when we
create it. then the next day when we try and find issue id:150 it might be
located at record:77 now..

is there a way to search/navigate by issue id from the main form? (similar
to how we can readily navigate through the records at the bottom of the form.)

and/or does anyone know what might be causing our records to move around?
any ideas how to prevent this? thanks

 

[Klein-4]

We are currently using Microsoft Access 2003  free "issues database."  This
works GREAT with what we need from a database. It was perfect when the "issue
id" matched the "record" number because we could quickly put the number in
the record field at the bottom of the form and goto that record to update it.
HOWEVER, after using it a while we've noticed that the "record" number keeps
changing on us. and only the "issue id" remains constant. it seems the record
randomly moves. for example our 150th issue will be record # 150 when we
create it. then the next day when we try and find issue id:150 it might be
located at record:77 now..

is there a way to search/navigate by issue id from the main form? (similar
to how we can readily navigate through the records at the bottom of the form.)

and/or    does anyone know what might be causing our records to move around?
any ideas how to prevent this? thanks

Yes, there is. Insert a combo box on the form that looks up records
on the form. This will be the 3rd option listed when you initially
insert the combo box.

I suspect that the records are being sorted on another field on the
form, or, perhaps filter criteria are being applied and not removed.
In general, it's not a good idea to rely on the built-in record
navigator.

Let me know if you have further questions.

Ross La Haye

 

[m3]

Sort your table in "issue id" first or create key using "issue id" and sort
it in "issue id" key, you can then navigate through the records in "issue
id" order.

 

[staff sergeant]

thank you i was able to get it to work on my test database, cant wait to
update ours tomorrow.

quick question.. is there a way to cover up the record search at the bottom
of the form so that we aren't tempted to use it ;P

 

[m3]

You can
1) use the code in your form's Form_Open procedure
yourform.NavigationButtons = False
or
2) set the form property NavigationButtons to "No" in Form design mode
to hide the Record Navigation Buttons at the bottom of your form.

 

[Klein-4]

thank you i was able to get it to work on my test database, cant wait to
update ours tomorrow.

quick question.. is there a way to cover up the record search at the bottom
of the form so that we aren't tempted to use it ;P









- Show quoted text -

You're welcome.

See m3's response to this...

Ross La Haye