[AccessD] A2003: Table Driven button list on Continuous Forms

Hi Darren,

I use buttons on continuous forms quite a bit.  To my knowledge, you cannot
do what you're trying to do.  The only way to change the appearance of a
control is to use Conditional Formatting, and button up/button down
appearance is not part of conditional formatting.  

Perhaps you could use a textbox instead of a label for your button, and
slightly change color to substitute for button up/button down using
Conditional Formatting.  Conditional Formatting only works with textboxes
and comboboxes.

Can you use a regular button on each record that says 'Open App'.  The user
knows which app since its name is displayed.

Or, could you set up a double-click event in the app name control to open
the app?  No button at all.

Just some thoughts,
Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darren D
Sent: Monday, September 08, 2008 7:25 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] A2003: Table Driven button list on Continuous Forms

Hi All

 

I have a table of application names that will grow and shrink with many
fields
but the 2 of interest are.

APPID = AutoNumber and AppName = Text

 

I want a continuous form to have a button for each item in that table. 

Trouble is It is a bit tricky to get the caption for each button to = the
AppName for each record in the table

I can 'fake' it using labels but if I write a routine to simulate a mouse
down
and mouse up to mimic raises and depressions then

all the labels that are simulated buttons on the form depress and raise at
the
same time

Besides I would prefer to have the 'rounded' look to the buttons simply to
match
the rest of my screen design

 

I know many people have done this sort of thing before - But how have you
managed it on a continuous form driven by a table

 

Many thanks in advance

 

Darren

 

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com