Google Groups Home
Help | Sign in
Lock records after edit
There are currently too many topics in this group that display first. To make this topic appear first, remove this option from another topic.
There was an error processing your request. Please try again.
flag
  2 messages - Collapse all
The group you are posting to is a Usenet group. Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post was successful
ebev  
View profile
 More options Jul 10, 7:44 pm
Newsgroups: microsoft.public.access.dataaccess.pages
From: ebev <e...@discussions.microsoft.com>
Date: Thu, 10 Jul 2008 16:44:02 -0700
Local: Thurs, Jul 10 2008 7:44 pm
Subject: Lock records after edit
        Hello all, I am new to Access and I have a question. In the IT dept. where I
work we have a daily checklist that we use. It was made in Access 2003 and a
data access page was set up.  My IT manager wants
the database set up so when we are done for the day and create a new day
 the old day will lock and not be editable. Is it possible to do this
and if so how is it done? Alternately we can use a button or checkbox to lock
the records if it is any easer. Thanks in advance for any help you can give.

    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
PaulD  
View profile
 More options Jul 16, 2:22 pm
Newsgroups: microsoft.public.access.dataaccess.pages
From: "PaulD" <nospam>
Date: Wed, 16 Jul 2008 14:22:46 -0400
Local: Wed, Jul 16 2008 2:22 pm
Subject: Re: Lock records after edit
I'm not sure how to lock specific records inside of access, but you could
certainly 'lock' them from a DAP.  Just set the controls to disabled if they
try to look at an old day.
Paul D

"ebev" <e...@discussions.microsoft.com> wrote in message

news:9BE5E713-C230-444D-B0F9-FF88DD131729@microsoft.com...
: Hello all, I am new to Access and I have a question. In the IT dept. where
I
: work we have a daily checklist that we use. It was made in Access 2003 and
a
: data access page was set up.  My IT manager wants
: the database set up so when we are done for the day and create a new day
: the old day will lock and not be editable. Is it possible to do this
: and if so how is it done? Alternately we can use a button or checkbox to
lock
: the records if it is any easer. Thanks in advance for any help you can
give.

    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
End of messages
« Back to Discussions « Newer topic     Older topic »

Create a group - Google Groups - Google Home - Terms of Service - Privacy Policy
©2008 Google