An Access 2000 question
Hi
is is possible to have (as a subform) a continous form with 0..n
buttons which have different images in each row.
(Personally I would have preferred a button array and assign images in
code, much easier with a class module - but unfortunately Access does
not support control arrays).
Here is my table that should create 4 buttons on the subform, when
filtering for process printStart.
Design
btnId - Number - number of button on screen to iterate
btnProcess - Text(20) - Process, e.g. Print Finish, Screen, Die Cut
(some processes do not have filter buttons!)
btnImg - Text(20) - Name of Button Picture (normal status)
btnImg_Active - Text(20) - Name of Button Picture in "Selected" State
btnSound - Text(20) - reserved for future use
btnCaption - Text(50) - Caption of button (displayed in separate
label, because button will have Picture)
btnFilterMc - text(20) - For building a query filter on parent form
Selected - Yes/No - to make buttons behave like "radio buttons"
Data
(beware line breaks)
btnId,btnProcess,btnImg,btnImg_Active,btnSound,btn Caption,btnFilterMc,isSelected
0,PrintStart,ALL.bmp,ALL_a.bmp,,ALL,,No
1,PrintStart,image1.bmp,image1_a.bmp,,T3000A,T3000 A,Yes
2,PrintStart,image2.bmp,image2_a.bmp,,T3000B,T3000 B,No
3,PrintStart,image3.bmp,image3_a.bmp,,T3020,T3020, No
4,PrintStart,image4.bmp,image4_a.bmp,,T4000,T4000, No
Each button triggers a query filter for displaying data in a listbox
pertaining to a certain (Print Process) Machine => btnFilterMc. Each
button should be graphic style and have its own unique image, which
should be
if Me.Selected=No _
Button.Picture=Me.btnImg
if Me.Selected=Yes _
Button.Picture=Me.btnImg_Active
Is this possible?
Also a Label underneath the button should display btnCaption.
If this is possible I could create a generic form with different
(optional) filter buttons with uniqe images that would work like radio
buttons. Otherwise I would have to create 6 different forms (some of
them with some without buttons) and it would create a lot of work on
2nd and 3rd plant integation.
thanks in advance
Axel