Rolodex

[scottpw via AccessMonster.com]

I would like to create a rolodex to bring the user directly to a value in an
attribute titled "Employee". The rolodex would be within an options group
consisting of an line of tabs (buttons), each representing a letter of the
alphabet.

In the form detail, the attribute (field) "Employee" will be based on
employees' names sorted in ascending order from a query.

As I click on any particular tab in the option group, the "Employee" field
would present the first employee's last name that starts with the letter of
the tab in the rolodex. For example, if I click on the tab "B", and "Baker"
is the first employee starting with a "B," then that name would appear. This
will provide the user a means to narrow down to the actual person's name
starting with the letter "B" with the navigation keys at the bottom of the
form.

I know that in the rolodex option group, the AfterUpdate property would have
to be set for a VB procedure that would point to the "Employee" field via a
named variable. The rolodex could be further refined so that if no last
names begin wth a particular letter of the alphabet, the next letter of the
alphabet would be automatically used.

Does anyone know a web source where I may find an example of a Rolodex option
group? I tried a search at Microsoft, but couldn't find any.

Thanks,

Scotty

 

[fredg]

I would like to create a rolodex to bring the user directly to a value in an
attribute titled "Employee". The rolodex would be within an options group
consisting of an line of tabs (buttons), each representing a letter of the
alphabet.

In the form detail, the attribute (field) "Employee" will be based on
employees' names sorted in ascending order from a query.

As I click on any particular tab in the option group, the "Employee" field
would present the first employee's last name that starts with the letter of
the tab in the rolodex. For example, if I click on the tab "B", and "Baker"
is the first employee starting with a "B," then that name would appear. This
will provide the user a means to narrow down to the actual person's name
starting with the letter "B" with the navigation keys at the bottom of the
form.

I know that in the rolodex option group, the AfterUpdate property would have
to be set for a VB procedure that would point to the "Employee" field via a
named variable. The rolodex could be further refined so that if no last
names begin wth a particular letter of the alphabet, the next letter of the
alphabet would be automatically used.

Does anyone know a web source where I may find an example of a Rolodex option
group? I tried a search at Microsoft, but couldn't find any.

Thanks,

Scotty

Look in your own computer.
Search for the Northwind.mdb sample database.
Take a look at the Customer Phone form.
You can adapt it for your own needs.

 

[scottpw via AccessMonster.com]

Thanks,

Right under my nose all the time. I'll take a look at it.

Thanks again,

Scotty

I would like to create a rolodex to bring the user directly to a value in an
attribute titled "Employee". The rolodex would be within an options group

[quoted text clipped - 24 lines]

Scotty

Look in your own computer.
Search for the Northwind.mdb sample database.
Take a look at the Customer Phone form.
You can adapt it for your own needs.