Best design for this problem......

[Ali]

Hi Folks,

We have a template at work that could do with a little automation.

The template is used to assign our 10 or so staff to cars each day.
Sometimes we have two staff in a car.

Staff that are sick or on leave also need to be shown as such......

The template does contain other static informaiton.

The staff are listed in a table on the template and when staff change we
simply change the dot file.

After the form is filled out each day it is printed.

so a simple pictorial version of the problem is:

TABLE2

STAFF CAR SICK
LEAVE

Name1 Car1 ( Name1 / Name 2) Name6 Name7
Name2 Car2 (Name 3 / Name 4)
Name3 Etc.....
Name4
Name5


So i guess my question is what is the best way to tackle this problem? Some
sort of dialog box or just use activex control toolbox????

Thanks in advance,

-Al

 

[Jezebel]

You don't actually say what the challenge is: logic, data management, or
graphic presentation. Who uses this information? What do they use it for? Is
it a permament record, in case you need to know who was using car 64 on
Thursday two months ago?

 

[Word Heretic]

G'day "Ali" <[email protected]>,

I'd be doing this the simple way.

Use a template protected for forms. It lists all your staff in a
table, staff name in col1, status in col2. Status is a simple dropdown
with three choices: Present [Default], Sick, On Leave

Stick a section break in after this table, probably Odd Page would
work best, and only protect section 1 as a form.

You then have a Generate Car Assignments MacroButton at the bottom
section 1 that calls a simple macro to loop through each row in the
table and produce the report required.


Steve Hudson - Word Heretic
Want a hyperlinked index? S/W R&D? See WordHeretic.com

steve from wordheretic.com (Email replies require payment)


Ali reckoned:

 

[Ali]

So I am gonna have 8 activeX dropdown boxes in my table listing status for
each person?

Thats quite a few list boxes.

-Al

G'day "Ali" <[email protected]>,

I'd be doing this the simple way.

Use a template protected for forms. It lists all your staff in a
table, staff name in col1, status in col2. Status is a simple dropdown
with three choices: Present [Default], Sick, On Leave

Stick a section break in after this table, probably Odd Page would
work best, and only protect section 1 as a form.

You then have a Generate Car Assignments MacroButton at the bottom
section 1 that calls a simple macro to loop through each row in the
table and produce the report required.


Steve Hudson - Word Heretic
Want a hyperlinked index? S/W R&D? See WordHeretic.com

steve from wordheretic.com (Email replies require payment)


Ali reckoned:

Hi Folks,

We have a template at work that could do with a little automation.

The template is used to assign our 10 or so staff to cars each day.
Sometimes we have two staff in a car.

Staff that are sick or on leave also need to be shown as such......

The template does contain other static informaiton.

The staff are listed in a table on the template and when staff change we
simply change the dot file.

After the form is filled out each day it is printed.

so a simple pictorial version of the problem is:

TABLE2

STAFF CAR SICK
LEAVE

Name1 Car1 ( Name1 / Name 2) Name6 Name7
Name2 Car2 (Name 3 / Name 4)
Name3 Etc.....
Name4
Name5


So i guess my question is what is the best way to tackle this problem? Some
sort of dialog box or just use activex control toolbox????

Thanks in advance,

-Al

 

[Ali]

The challenge was the best graphic layout. Once the form is printed it is
not saved etc...

-Al

 

[Doug Robbins - Word MVP]

I would use a userform with two listboxes, a combobox and two command
buttons

One listbox would be populated with the names of the employees from a table
contained (and maintained) in a separate document. The combobox would be
populated with the cars and the other items such as sick or or leave. This
information would also be stored and maintained in a table in the separate
document.

The use would select an employee from the list box and an assignment (card,
sick, leave, etc) from the combo box and then click on one of the command
buttons which would then add an item to the other list box containing the
name of the employee and the assignment. When all of the employees had been
dealt with in this way, the second command button would become enabled and
it's click event would transfer the information from the listbox that had
been populated with the names and assignments into the document.

--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

 

[Word Heretic]

G'day "Ali" <[email protected]>,

Huh? Status is in one dropdown with a few options. You copy n paste it
to the next row.


Steve Hudson - Word Heretic
Want a hyperlinked index? S/W R&D? See WordHeretic.com

steve from wordheretic.com (Email replies require payment)


Ali reckoned:

So I am gonna have 8 activeX dropdown boxes in my table listing status for
each person?

Thats quite a few list boxes.

-Al

G'day "Ali" <[email protected]>,

I'd be doing this the simple way.

Use a template protected for forms. It lists all your staff in a
table, staff name in col1, status in col2. Status is a simple dropdown
with three choices: Present [Default], Sick, On Leave

Stick a section break in after this table, probably Odd Page would
work best, and only protect section 1 as a form.

You then have a Generate Car Assignments MacroButton at the bottom
section 1 that calls a simple macro to loop through each row in the
table and produce the report required.


Steve Hudson - Word Heretic
Want a hyperlinked index? S/W R&D? See WordHeretic.com

steve from wordheretic.com (Email replies require payment)


Ali reckoned:

Hi Folks,

We have a template at work that could do with a little automation.

The template is used to assign our 10 or so staff to cars each day.
Sometimes we have two staff in a car.

Staff that are sick or on leave also need to be shown as such......

The template does contain other static informaiton.

The staff are listed in a table on the template and when staff change we
simply change the dot file.

After the form is filled out each day it is printed.

so a simple pictorial version of the problem is:

TABLE2

STAFF CAR SICK
LEAVE

Name1 Car1 ( Name1 / Name 2) Name6 Name7
Name2 Car2 (Name 3 / Name 4)
Name3 Etc.....
Name4
Name5


So i guess my question is what is the best way to tackle this problem? Some
sort of dialog box or just use activex control toolbox????

Thanks in advance,

-Al