473,320 Members | 1,804 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Check box for locking

I am attempting to create a check box that when made "yes" locks the form from all other editing. I do still need to create new forms within the data base. Does anybody know how to do this or even if its possible, even a button that will do it rather than the check box would be welcome. My access knowledge is very limited. I got the project by been the person with the least work load. Thanks.
Jan 9 '07 #1
4 1545
PEB
1,418 Expert 1GB
U need the form locked for editing and the user that uses the form can't introduce any info anywhere?

Or simply when user introduces record other can't do anything on this record?
Jan 9 '07 #2
U need the form locked for editing and the user that uses the form can't introduce any info anywhere?

Or simply when user introduces record other can't do anything on this record?
A user creates a form. Any number of users may view and some may edit the form. The form is for work status, so further entries may be made untill the job is complete. Once the "job complete" box is checked I want the form to be locked so no further entries can be made on that form.
Jan 9 '07 #3
PEB
1,418 Expert 1GB
A user creates a form. Any number of users may view and some may edit the form. The form is for work status, so further entries may be made untill the job is complete. Once the "job complete" box is checked I want the form to be locked so no further entries can be made on that form.
In this case in ur form u need a bit VB

In Form properties go in Current, choose event procedure and type

Expand|Select|Wrap|Line Numbers
  1. If me!FIeld1=Yes then
  2. Me.AllowEdits = Yes
  3. else
  4. Me.AllowEdits = no
  5. end if
  6.  
me!FIeld1 is the name of ur respective field that is filled with Yes or No

I assume that Yes or No is a checkbox and not textfield!
Jan 9 '07 #4
NeoPa
32,556 Expert Mod 16PB
Vladi,
You have too much code there ;)
Expand|Select|Wrap|Line Numbers
  1. Me.AllowEdits = Me.chkJobComplete
It will work, of course, but you will not be able to un-check it afterwards as this disables even updating of the Job Complete checkbox itself.
Jan 9 '07 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

18
by: Dino | last post by:
dear all, i've created an application for a customer where the customer can upload ..csv-files into a specified ftp-directory. on the server, a php-script, triggered by a cronjob, reads all the...
16
by: Nid | last post by:
How do I do row-level locking on SQL Server? Thanks, Nid
2
by: Ken Durden | last post by:
I'm setting up an interface where clients must perform external locking before calling certain commands. I do this to force them to specify the duration the action they performed must persist...
15
by: z. f. | last post by:
Hi, i have an ASP.NET project that is using a (Class Library Project) VB.NET DLL. for some reason after running some pages on the web server, and trying to compile the Class Library DLL, it...
7
by: Shak | last post by:
Hi all, I'm trying to write a thread-safe async method to send a message of the form (type)(contents). My model is as follows: private void SendMessage(int type, string message) { //lets...
14
by: John Salerno | last post by:
What is the best way to check if a file already exists in the current directory? I saw os.path.isfile(), but I'm not sure if that does more than what I need. I just want to check if a file of a...
16
by: Brian Tkatch | last post by:
Is there a way to check the order in which SET INTEGRITY needs to be applied? This would be for a script with a dynamic list of TABLEs. B.
1
by: bg_ie | last post by:
Hi, I have the following in my com object- static public uint Time { get { lock (Channel.staticLockObject) {
0
by: xpding | last post by:
Hello, I have a class MyEmbededList contains a generic dictionary, the value field is actually the MyEmbededList type as well. There is another class need to access and manipulate a list of...
1
by: Paul H | last post by:
I have an Employees table with the following fields: EmployeeID SupervisorID Fred Bob Bob John Bob Mary Bill Bill I have created a self join in...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.