Change Caption

[faureman via AccessMonster.com]

To facilitate data entry, I want to use an array of 16 buttons that will
enter part numbers and defects through an events form into an Events table.
By selecting a button, the part number (typcially 3 or 4 digits) should
display in another text box for display purposes - acknowledging the data
entry of the button pressed.

The part numbers and defects are tied to the line selected. This already
exists in tblPartNumber.

I want to create a table (with a form) that will allow users to change the
top 16 parts and the top 16 defect reasons by whichever production line is
entered.

My question is - how do I have the array of buttons and captions for the
buttons take the data from these tables and assign "Part One" (example: 3434)
and have it show up in Button 1 Caption?

 

[Piet Linden]

To facilitate data entry, I want to use an array of 16 buttons that will
enter part numbers and defects through an events form into an Events table.
By selecting a button, the part number (typcially 3 or 4 digits) should
display in another text box for display purposes - acknowledging the data
entry of the button pressed.

The part numbers and defects are tied to the line selected. This already
exists in tblPartNumber.

I want to create a table (with a form) that will allow users to change the
top 16 parts and the top 16 defect reasons by whichever production line is
entered.

My question is - how do I have the array of buttons and captions for the
buttons take the data from these tables and assign "Part One" (example: 3434)
and have it show up in Button 1 Caption?

that'll be a serious PITA to implement. Why not just use cascading
comboboxes? The first would be unbound and the second would be bound
to the table ... then you need almost no code and you can add more
items until you're blue in the face and the form will still work...
pretty much the sign of a stable design. Or do you like redesigning
your forms every time a rule changes?

 

[boblarson]

I definitely agree with Piet on this one.
--
Bob Larson

Free Tutorials and Samples at http://www.btabdevelopment.com

__________________________________

 

[faureman via AccessMonster.com]

The answer to your question is encapsulated in my first few words - for data
entry. The environment is "lite industrial" where operators may have gloves
on. Interestingly enough, I had developed a form that did use a series of
combo boxes to displaying drop-down options (similar to what I think you
suggested) that are "queried" to provide only those options that are possible
within the prior options selected.

However, the plant end-user wants to change it... making it that much easier
by offering the "top 16" most likely 3-4 digit part numbers for rapid ease of
entry. The goal - for example... is to select:
1) Screen 1: 16 Part buttons (auto-filling the number in the unbound box for
display purposes)
2) Screen 2: Range of 1-12 Mold numbers (auto-filling and appending to the
part numberfor a 5 or 6-digit entry)
3) Screen 3: Presenting Defect reasons in those buttons. (3 clicks to
register without any dropdown boxes).
4) The 16 buttons flank a large on-screen keypad allowing manual keying also.
Finally, all Part number-mold number combinations are validated (working in a
acces display model already developed) prior to displaying the reason.

In this manuf. environment, efficient (minimal keying) and visual data entry
are critical.

I have approached the end-user a second time to provide your "feedback" but
they persist in wanting to have the buttons/captions coorinated as described
above.