Making entered records "Non-modifiable"

  • Thread starter Thread starter Duncan Edment
  • Start date Start date
D

Duncan Edment

It may be simple, but I can't find a solution anywhere.

What I want to do is as follows.....

Users enter information into a database on a daily basis, for the purposes of
recording how much time they spend on various projects. At the end of the week,
all figures entered for the week are transferred to an Excel s/s and the week is
considered closed. However, I have found that some staff members are returning
to previous weeks entries and altering times, which screws the billing of
customers.

So, what I want to do is...

At the end of the week, the user would click a button--say Submit--and that
button would effectively 'lock' their entries for the week and prevent them from
returning to them and modifying them. Sounds simple? However, can it be done
and more importantly, could someone please direct me along the way of "How to"?

I am very much obliged for all responses / ideas / suggestions.

TIA

Duncan

--
"Whatever you do, you need courage. Whatever course you decide upon, there is
always someone to tell you that you are wrong.
There are always difficulties arising that tempt you to believe your critics are
right. To map out a course of action and follow it to an
end requires some of the same courage that a soldier needs. Peace has its
victories, but it takes brave men and women to win them."
~ Ralph Waldo Emerson
 
You will have to make sure that your users do not have access to the tables,
but do all their data entry via a form. Then, you can follow these steps:

1. Add a boolean field to the table with the times called, say,
[Submitted].
2. Add the Submit button to your form and have it set the value of
[Submitted] to True (-1).
3. On the current event of your form add code similar to this:

Sub Form_Current()
Begin
If Me.chkSubmitted = -1 then
Me.txtYourTimeField.Enabled = False
Else
Me.txtYourTimeField.Enabled = True
End If
End
 
-----Original Message-----
It may be simple, but I can't find a solution anywhere.

What I want to do is as follows.....

Users enter information into a database on a daily basis, for the purposes of
recording how much time they spend on various projects. At the end of the week,
all figures entered for the week are transferred to an Excel s/s and the week is
considered closed. However, I have found that some staff members are returning
to previous weeks entries and altering times, which screws the billing of
customers.

So, what I want to do is...

At the end of the week, the user would click a button-- say Submit--and that
button would effectively 'lock' their entries for the week and prevent them from
returning to them and modifying them. Sounds simple? However, can it be done
and more importantly, could someone please direct me along the way of "How to"?

I am very much obliged for all responses / ideas / suggestions.

TIA

Duncan

--
"Whatever you do, you need courage. Whatever course you decide upon, there is
always someone to tell you that you are wrong.
There are always difficulties arising that tempt you to believe your critics are
right. To map out a course of action and follow it to an
end requires some of the same courage that a soldier needs. Peace has its
victories, but it takes brave men and women to win them."
~ Ralph Waldo Emerson


.
Create a duplicate table whose records are locked.
Click to expand...
When you close the week move all the records to the locked
table
 
Lynn,

Thank you, thank you, thank you!!!!

It works a treat and is exactly what I need!!

Once again, thanks.

Duncan

--
"Whistling to keep up courage is good practice for whistling."
~ Charles Homer Haskins (1870-1937) U.S. historian, medievalist

Lynn Trapp said:
You will have to make sure that your users do not have access to the tables,
but do all their data entry via a form. Then, you can follow these steps:

1. Add a boolean field to the table with the times called, say,
[Submitted].
2. Add the Submit button to your form and have it set the value of
[Submitted] to True (-1).
3. On the current event of your form add code similar to this:

Sub Form_Current()
Begin
If Me.chkSubmitted = -1 then
Me.txtYourTimeField.Enabled = False
Else
Me.txtYourTimeField.Enabled = True
End If
End

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm



Duncan Edment said:
It may be simple, but I can't find a solution anywhere.

What I want to do is as follows.....

Users enter information into a database on a daily basis, for the purposes of
recording how much time they spend on various projects. At the end of the week,
all figures entered for the week are transferred to an Excel s/s and the week is
considered closed. However, I have found that some staff members are returning
to previous weeks entries and altering times, which screws the billing of
customers.

So, what I want to do is...

At the end of the week, the user would click a button--say Submit--and that
button would effectively 'lock' their entries for the week and prevent them from
returning to them and modifying them. Sounds simple? However, can it be done
and more importantly, could someone please direct me along the way of "How to"?

I am very much obliged for all responses / ideas / suggestions.

TIA

Duncan

--
"Whatever you do, you need courage. Whatever course you decide upon, there is
always someone to tell you that you are wrong.
There are always difficulties arising that tempt you to believe your critics are
right. To map out a course of action and follow it to an
end requires some of the same courage that a soldier needs. Peace has its
victories, but it takes brave men and women to win them."
~ Ralph Waldo Emerson
Click to expand...
Click to expand...
 
Larry,

Thanks for your reply, but I think the suggestion provided by Lynn, looks like
it will work best in my implementation.

However, thank you for providing an alternative.

Duncan
 
You are quite welcome, Duncan. Please feel free to post back if you have any
questions on implementing this.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm



Duncan Edment said:
Lynn,

Thank you, thank you, thank you!!!!

It works a treat and is exactly what I need!!

Once again, thanks.

Duncan

--
"Whistling to keep up courage is good practice for whistling."
~ Charles Homer Haskins (1870-1937) U.S. historian, medievalist

Lynn Trapp said:
You will have to make sure that your users do not have access to the tables,
but do all their data entry via a form. Then, you can follow these steps:

1. Add a boolean field to the table with the times called, say,
[Submitted].
2. Add the Submit button to your form and have it set the value of
[Submitted] to True (-1).
3. On the current event of your form add code similar to this:

Sub Form_Current()
Begin
If Me.chkSubmitted = -1 then
Me.txtYourTimeField.Enabled = False
Else
Me.txtYourTimeField.Enabled = True
End If
End

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm



Duncan Edment said:
It may be simple, but I can't find a solution anywhere.

What I want to do is as follows.....

Users enter information into a database on a daily basis, for the
Click to expand...
purposes
of
recording how much time they spend on various projects. At the end of
Click to expand...
the
week,
all figures entered for the week are transferred to an Excel s/s and
Click to expand...
the
week is
considered closed. However, I have found that some staff members are returning
to previous weeks entries and altering times, which screws the billing of
customers.

So, what I want to do is...

At the end of the week, the user would click a button--say Submit--and that
button would effectively 'lock' their entries for the week and prevent them from
returning to them and modifying them. Sounds simple? However, can it
Click to expand...
be
done
and more importantly, could someone please direct me along the way of
Click to expand...
"How
to"?
I am very much obliged for all responses / ideas / suggestions.

TIA

Duncan
Click to expand...
there
is
always someone to tell you that you are wrong.
There are always difficulties arising that tempt you to believe your critics are
right. To map out a course of action and follow it to an
end requires some of the same courage that a soldier needs. Peace has its
victories, but it takes brave men and women to win them."
~ Ralph Waldo Emerson
Click to expand...
Click to expand...
Click to expand...
 
Back
Top