Highlight button when in use

[Shari]

I am creating a database to use as a 'waiting list' for customers. I work in
a plumbing company, and when our schedule is booked, we need a waiting list
for customers. My idea is to create a main switchboard with buttons for
numbers 1-10, and create a form for each button for each customer, and put
them in a numeric list. My question is can I set up the button, so that if
it has information on its form, it changes color when it is in use? I am
using Access 2000.

 

[Arvin Meyer [MVP]]

Probably not very easily using the Access switchboard, but you can very
easily by using a standard unbound form with buttons.

I must question your design though. Having a button for each customer
suggests that you will always have the same 10 customers, never more or
less. Suppose your business grew to 50 customers? Would you have space for
50 buttons? How about a 100? You need to redesign and open a dialog with a
combo or list box, asking which customer, and then opening the same form
with that customer's information.

 

[Larry Daugherty]

Since Access 97, the answer to your question can be found in Access
Help under "conditional formatting".

HTH

 

[Shari]

When I try to do the conditional formatting for the buttons, it is not
showing up. It does not allow me to select it. Am I missing something?

 

[Arvin Meyer [MVP]]

You're not missing anything. Conditional Formatting is only available for
textbox and combo box controls.

 

[Larry Daugherty]

My apologies. I read quickly, and didn't really comprehend the
question. I don't believe you can.

You might try here: http://www.lebans.com/ He does lots of clever
things with the interface elements.

HTH