ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Forcing users to complete a form (https://www.excelbanter.com/excel-discussion-misc-queries/55875-forcing-users-complete-form.html)

BK

Forcing users to complete a form
 
I am setting up a form for to help calculate sales in the store I work
in. There are several managers who only enter enough data into the form
to get the numbers to balance. They are leaving out other informatiun
such as customer count, total credit transactions, "signatures" etc. I
want to force them to put in all information before they can print or
close the application. Is there any way to do this?


Jeremy

Bruce Sinclair

Forcing users to complete a form
 
In article , BK wrote:
I am setting up a form for to help calculate sales in the store I work
in. There are several managers who only enter enough data into the form
to get the numbers to balance. They are leaving out other informatiun
such as customer count, total credit transactions, "signatures" etc. I
want to force them to put in all information before they can print or
close the application. Is there any way to do this?


I suggest that they might be telling you something important here. That
information may not be as important as you think it is ... and if you "make"
them fill stuff in, they might just make it up - how useful would that be ?
:)

Suggest you talk to them and either persuade them the info you want really
is important ... or relax your rules a bit :)




Bruce

----------------------------------------
I believe you find life such a problem because you think there are the good
people and the bad people. You're wrong, of course. There are, always and
only, the bad people, but some of them are on opposite sides.

Lord Vetinari in Guards ! Guards ! - Terry Pratchett

Caution ===== followups may have been changed to relevant groups
(if there were any)


Jeremy Brown

Forcing users to complete a form
 
It is not that the info is unimportant, it is usually entered at the end of
the night after the restaurant has closed. Several of the managers (about
three or four of the thirty across this franchise group) don't care if they
one way or the other, they just want to leave. The information is included
in the various forms they gather the data from, so it is not difficult to
enter.

They're just lazy.

Jeremy

"Bruce Sinclair" wrote
in message ...
In article , BK
wrote:
I am setting up a form for to help calculate sales in the store I work
in. There are several managers who only enter enough data into the form
to get the numbers to balance. They are leaving out other informatiun
such as customer count, total credit transactions, "signatures" etc. I
want to force them to put in all information before they can print or
close the application. Is there any way to do this?


I suggest that they might be telling you something important here. That
information may not be as important as you think it is ... and if you
"make"
them fill stuff in, they might just make it up - how useful would that be
?
:)

Suggest you talk to them and either persuade them the info you want really
is important ... or relax your rules a bit :)




Bruce

----------------------------------------
I believe you find life such a problem because you think there are the
good
people and the bad people. You're wrong, of course. There are, always and
only, the bad people, but some of them are on opposite sides.

Lord Vetinari in Guards ! Guards ! - Terry Pratchett

Caution ===== followups may have been changed to relevant groups
(if there were any)




Bruce Sinclair

Forcing users to complete a form
 
In article , "Jeremy Brown" wrote:
<TPF
"Bruce Sinclair" wrote
in message ...
In article , BK
wrote:
I am setting up a form for to help calculate sales in the store I work
in. There are several managers who only enter enough data into the form
to get the numbers to balance. They are leaving out other informatiun
such as customer count, total credit transactions, "signatures" etc. I
want to force them to put in all information before they can print or
close the application. Is there any way to do this?


I suggest that they might be telling you something important here. That
information may not be as important as you think it is ... and if you
"make"
them fill stuff in, they might just make it up - how useful would that be
?
:)

Suggest you talk to them and either persuade them the info you want really
is important ... or relax your rules a bit :)


Ącis not that the info is unimportant, it is usually entered at the end of
the night after the restaurant has closed. Several of the managers (about
three or four of the thirty across this franchise group) don't care if they


one way or the other, they just want to leave. The information is included
in the various forms they gather the data from, so it is not difficult to
enter.

They're just lazy.


You might be right. Thing is .. do you really need the info they aren't
giving you ? Does it help your business in any way ... and do they
understand why you need it ? I still reckon you have a people problem, not a
computer problem ... even if you can truthfully say "they are just lazy".
:)



Bruce

----------------------------------------
I believe you find life such a problem because you think there are the good
people and the bad people. You're wrong, of course. There are, always and
only, the bad people, but some of them are on opposite sides.

Lord Vetinari in Guards ! Guards ! - Terry Pratchett

Caution ===== followups may have been changed to relevant groups
(if there were any)



All times are GMT +1. The time now is 03:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com