locking a form after 24 hours

I have a form for salespeople to enter sales right now i have it set for no
edits. Seems people dont know how to enter data because 1 out of 3 are wrong
i would like to make the form editable till the next day or untill the
accounting dept runs their sales query. Whichever is easier is the way i
will go

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200612/1

Need more info. If I could enter data yesterday, but I can't enter data
today, what about tomorrow?

If you are saying that what you really want is for a user to be able to
enter/edit only data that is for today or in the future, but not to be able
to enter/edit data with a date prior to today, that can be accomplished by
filtering the form based on a date in the record or by a flag field in the
record that "freezes" the record.

As to the problem with incorrect entry - tighten up your data entry editing.
Don't allow a user to proceed until correct information has been entered.

"jomara via AccessMonster.com" wrote:

I have a form for salespeople to enter sales right now i have it set for no
edits. Seems people dont know how to enter data because 1 out of 3 are wrong
i would like to make the form editable till the next day or untill the
accounting dept runs their sales query. Whichever is easier is the way i
will go

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200612/1

First, data entry issues can be resolved with training. However, you may not
have the time. So you have to established data entry rules. Perhaps, you
should include within the design of the form a " * “symbol next to required
fields and then place a label that reads� * REQUIRED FIELD " in red bold text.
That will grab some attention! Also include data validation rules. Within
the form you can create input masks to format the way data can be entered.
You may also set data defaults on certain fields. The use of Combo Boxes
that limit data entry to the items on the list is great for eliminating typos.
Nevertheless, I think your data entry issues can be resolved with more work
on your part.

Second, you set the form's property "Allow Edits" to equal "No" must mean you
are manually adjusting this form's property on a daily basis. What a pain!
To automate the form to Allow Edits from "No" to "Yes" you must use VBA.
Since your Accounting Department must be running during a certain time of day
(let's say between 11am and 1pm), you don't want anyone to modify records
during that time. Here is what I came up with.

Step 1. Open the form in design view and set the form's property "Timer
Interval = 1000"
Step 2. Place the cursor in the property "On Timer" and create an Event
Procedure. Copy and Paste the code below between the words “Copy From Here
To Here�.


Private Sub Form_Timer()

'Copy From Here

If Format(Time(), "hh:mm:ss AMPM") = #11:00:00 AM# And Format(Time(),
"hh:mm:ss AMPM") = #1:00:00 PM# Then
Me.AllowEdits = False
Else
Me.AllowEdits = True
End If

'To Here

End Sub


The event procedure will check the time every second to see if it is between
11am and 1pm. This should get you started. Much luck and success to you!




jomara wrote:
I have a form for salespeople to enter sales right now i have it set for no
edits. Seems people dont know how to enter data because 1 out of 3 are wrong
i would like to make the form editable till the next day or untill the
accounting dept runs their sales query. Whichever is easier is the way i
will go

Why on earth are you reposting this, instead of going to your previous post,
where I've given you step by step instructions on how to solve your problem?

http://www.accessmonster.com/Uwe/For...732/data-entry

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200612/1