how to add alphabetical tabs on a database

G

Guest

my boss asked me to organise my new database with alphabetical index buttons
at the top of forms so that he can quickly go to names beginning with a
particular letter... I've been searching high and low but can't find any
instructions anywhere on how to do this, is this possible?
 
R

Rick Brandt

lostinaccess said:
my boss asked me to organise my new database with alphabetical index
buttons at the top of forms so that he can quickly go to names
beginning with a particular letter... I've been searching high and
low but can't find any instructions anywhere on how to do this, is
this possible?
Click to expand...

Your title says "tabs" and your body says "buttons". For buttons...

Me.Filter = "[NameField] Like 'A*'"
Me.FilterOn = True

(repeat for each button).
 
G

Guest

I guess I mean like you have in the 'contacts' thingy in Outlook - I guess
they are buttons? anyways, thanks for your help and answer, I'll start from
here and see

thanks Rick
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

letter tabs on right hand side of contacts page in Outlook Contact 2
How to create a link from paragraph heading to an alphabetical ind 1
A Database to organise digitised archive information 0
how do to add fields to a order management access database 1
how do i insert a record in access so it appears in alphabetical o 2
How to automate searching a field? 1
How does one convert VBA to VBScript? 1
Trying to use my database on a different pc 4

Top