Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
BK
 
Posts: n/a
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bruce Sinclair
 
Posts: n/a
Default 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)

  #3   Report Post  
Posted to microsoft.public.excel.misc
Jeremy Brown
 
Posts: n/a
Default 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)



  #4   Report Post  
Posted to microsoft.public.excel.misc
Bruce Sinclair
 
Posts: n/a
Default 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)

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Protect Workbook vs Worksheet?? Dan B Excel Worksheet Functions 3 November 7th 05 09:02 PM
How many users can sucessfully use a shared excel workbook? Andrew of EIT Excel Worksheet Functions 1 September 5th 05 02:45 PM
Display form from an VB application in Excel kuhni Excel Discussion (Misc queries) 0 August 10th 05 06:04 PM
Worksheet form design rgarber50 Excel Discussion (Misc queries) 4 August 7th 05 05:09 AM
Protecting Workbook Paul Cooling Excel Discussion (Misc queries) 2 March 7th 05 11:55 AM


All times are GMT +1. The time now is 11:20 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"