mock navigation bar

tdcsi

Board Regular
Joined
Sep 20, 2011
Messages
86
I have a database originally written for Access 2013 that we are now using with Access 2016. We've been using the Primary key as the tracking number for several years, which I'm learning isn't the ideal way of doing things. Traditionally, we have been able to use the navigation bar as a "goto record" by typing in the primary key number followed by enter and that has taken us to the correct record. Somehow, we've managed to delete some records so now when we enter what we have as our "ID" we end up on the wrong record since we now have more numbers created via Primary Key designations then remaining records.

To minimize confusion going forward, I'd like to hide the access navigation bar and generate a new one. I've created the appropriate buttons, generated a functional "GoToRecord" combo box and tagged a text box to the primary key to show what record is being edited. This approach does work, however, what I'd really like to be able to do is have something like the Access Record number field where I can either enter the ID number and have it go to that record, or have it update itself to the current. Is this possible? I have a decent understanding of Access, but don't understand VBA codes very well so I'm not even sure where to to begin trying this. Any help would be appreciated.
 

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.
In my opinion using Access filters is fine for. Just filter for your ID number, or use Advanced Filter - Filter by Form for the same purpose. If you want to create a search form you can do so probably with a little VBA, as shown here:
http://www.allenbrowne.com/ser-03.html

(I don't know why but even though using filters is very common in Excel it seems to be completely ignored in Access - but I think you can even filter right from the text boxes in forms if they are bound fields, using a right click, so worth exploring).
 
Last edited:
Upvote 0

Forum statistics

Threads
1,223,275
Messages
6,171,122
Members
452,381
Latest member
Nova88

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top