how to add alphabetical tabs on a database

L

lostinaccess

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).
 
L

lostinaccess

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

Merging from an Excel file with graphics 1
How do I set focus (and select text) on a text box on a modeless userform? 0
basic mail merge questions 1
HELP! 2
Home email account in Outlook 2007 5
how to add to field from previous record 4
Alphabetical Buttons 3
Outlook 2007: Dumping the Search Box 0

Top