Lock Current Reccord

Nov 29, 2005

Hi all!
This is my first post here so my appologies if I do something wrong AND my terrible English!! :cool:

I have made a database in Access where I can store all kind of information about hardware (laptop type, s/n, hdd size, memory etc.). Now it sometimes happens that an engineer will loose (!!) his laptop or it wil be stolen...

I want to build an option to mark the current record (of that stolen laptop) as stolen. Just with a checkbox. When i select the checkbox "stolen", all fields in the form of the current record has to be greyed-out. But just only for that record.
Is this possible?

Thanks in advance!

Kindest regards,
Tim

View Replies


ADVERTISEMENT

Modules & VBA :: How To Create New Lock File Within Current Database

Apr 7, 2015

What I'd like to do is have an "export button", where the OnClick event, exports a single table into a new accde file. This would allow the end users to zip this file up and send it to me.

Because of all sorts of stupidity, I have no network capability and must send data back and forth via email.

I have digressed to a replication table that needs to be uploaded, once data is entered by the users...

Because the files can get relatively large (for emailing purposes), I am trying to figure out how I can get just one table from them vs. sending the whole application file back to me... It's pretty vital that they not be able to edit the table because that could really mess up the process.

So any way to create a new lock file from within the current Db?

View 1 Replies View Related

Lock And Un Lock A Text Field Through A CMD Button

Jun 13, 2005

I need to lock and unlock a a few text fields with a CMd Button.

and i do know about the allowedits thing, but i only need to apply this to a few fields on my form.

can some one throw me a clue?

View 2 Replies View Related

Forms :: Goto Form With Current User And Current Date

Aug 27, 2013

What I really need is for when the form opens, it looks at todays date, then matches current user and then goes to that record for today, if no current user there, then will goto new record..

i know, sounds complicated, and probably is really easy, but my heads not with it today, as about to get drunk as its my 40th, and got people ringing and texting and still trying to get this done....

I've included a copy of this database, named Timecards..

View 1 Replies View Related

Lock The Field

Apr 22, 2006

Hi,

I create the datasheet form,
I know how to lock the field, but it lock the whole column of the field.
I want to lock the field except the last record field only.
Can I do that?

eg.
ID Field1 Field2
1___a______b
2___c______d
3___z

I want to lock the field2 except the ID=3

Please let me know, thanks.

View 1 Replies View Related

Lock Records

Oct 30, 2005

My company has asked for an issue tracking database with the requirements that if is someone is edditing records it locks that block down until that user is done. I don't have any idea how to do it. my db is set up this way.

tables
tblPolls
tblIssues

Querries
qryPolls
qryIssues
qryFindPollsByID
qryFindPollsbyName


Forms
FrmFindPolls
FrmSearchResultsbyId
FrmSearchResultsbyName
FrmIssueTrackingMain
FrmIssueTrackingSub

The Form Issue Tracking Main has the Sub form IssueTracking Sub
Here users enter the issues in the sub form. The forms are linked by Poll ID
Is there a way to lock all the records with the same pollid in the tbltblIssues. Also to check who is editing them at the time?

View 2 Replies View Related

How To Lock Records

Apr 5, 2006

I've set up a database for use by a team of approx 10 people. I've got problems with locking records so that only 1 user can edit a record at one time. This is happening in a form with a subform included... Can anyone help?

View 6 Replies View Related

Lock Problem

Aug 16, 2007

hello,

Access gives me the following error:
runtime error 3326 this recordset is not updatable
How do I make a recordset UPDATABLE?

2 days ago, I was able (from front end file) to open a table (in the back end in another computer) and modify the records or add a new one. Yesterday, Office 2007 was automatically updated from the internet, and now I can open the tables but it locks me (it doesn't let me modify or add anything)

Does anyone have any idea of what's going on and how to fix this?
thank you

View 6 Replies View Related

How To Lock Tables

Oct 13, 2004

hi,
i have created a table with 2 records.i want to lock the record such that nothing can be done with the existing records but allows to add new records.wat should i do??
thank u

View 3 Replies View Related

Lock Table

Nov 5, 2005

I want to lock a table to disallow further records.
I want to have only one record (I would have created this rec by myself) to store initial conditions and infos such Username/company etc.
Any ideas?
I'm also interesting in other solutions than locking a table if sucj a thing is not possible or nt functional.

Tnx in advance

View 3 Replies View Related

Record Lock

Dec 1, 2005

I have a created a database for insurance policies.
I'm using a form in the database to edit the data in the underlying table.
I use "pessimistic lock" in the database and in the form.
The database runs in a multi-user environment.

My question is the folowing:

When a user is editing a record, it is obvious that this record is set to
lock in the table (--> pessimistic lock), but the 4 records that are right before this record
are also locked too!

There is nobody else editing at that same moment in the database and it is
not a one-time occurence!

Can somebody help me out with this one... I'm realy desperite and I
searched the entire forum.

View 2 Replies View Related

Lock A Table

Apr 12, 2007

I'm working on a database that calls on a table of zipcodes. All of these zipcodes have latitudes and longitudes connected to them..... I've searched around but cant seem to find anything on locking a table. Is it possible to lock down a table so changes cannot be made?.....(until I need to make them)

View 1 Replies View Related

How To Lock Tables

Aug 30, 2007

hello to all

i want to lock the tables and queries of my database in access so the users cant modify any information

View 1 Replies View Related

Lock Down Record

Feb 2, 2005

Hi all. I have a form that when I click a button is automatically changes a field on another form and then closes both forms. Can I add anything to this button to stop that record from being altered again. IE. when i click on this close job button nobody can ever change the record again. Thanks.

View 1 Replies View Related

Security Lock

Jun 10, 2005

Dear everyone

I have enclosed a sample need someone to help.

I have a form and in the form there are sentitive information such as cost price. Is there a way to make it invisible or make it protected (cannot see) and then set a button beside this field, if I want to see the data in that field, I just need to click the button, it will appear with a password(for security wise, this button must be password protected) only when I key the correct password then it will appear.

Can someone help me please.

Thanking in advance.

View 2 Replies View Related

Cant Lock Record HELP!

Jun 15, 2006

Hi All, I've searched the forum and have found a lot of info on locking records/forms. I pulled this from a thread but it doesnt work. I have a subform with many fields with a check box. if the check box is true then I want to lock that record(or the form). I loaded this in the on current event and I can still edit the form and or record.


if me.closed = - 1 then

Me.AllowEdits = No
Me.AllowDeletions = No
else

Me.AllowEdits = yes
Me.AllowDeletions = yes


thanks

View 3 Replies View Related

Lock A Field

Aug 6, 2006

I've looked through the forum but haven't found quite what I want. I am a novice but realise this is going to be a relatively simple one ....

I use an invoice form for my own business with client details and a sub form with invoice lines. The client is selected via a combo box. I realise the danger that I could inadvertently alter the client, so would like to lock the client field when I move on to the next invoice or close the record, I don't want to lock the invoice lines. Can't get the code quite right and not sure whether this should be AfterUpdate or OnExit?

Any help much appreciated.

View 4 Replies View Related

Need Help To Lock A Field

Aug 6, 2006

I'm doing a project for Tafe and I have some yes no questions on my form and a text box next to each one for detials if the answer was no for tick box I want the text box not to be able to write in ...

View 8 Replies View Related

How To Lock A Form For Changes?

Aug 24, 2006

I made a table containing information about products (price, amount, supplier,...). The most inportant info is the order number (cause it's unique).
Then I made a form, containing a combo-box and several text-boxes. The idea is to find a record using the combo-box, and vieuwing the information of that product in the form. This works, but a problem occurs: the order numbers change each time in a single number (I guess the autonumber). How can I solve this problem so that my combo-box is still available for searching, but no changes can be made in the table that is the source for the form?

View 2 Replies View Related

Could Not Lock File

Nov 1, 2004


I created a database for one company. So, this database needs to support multiple users environment. One of the users has problem opening the database. Sometime he can open it. …. sometime he has an error message “Could not lock file”. What’s wrong with the database? (I gave him permission to “Read”, “Write” and “Read & Execute”)
Thanks in advance for all your answers.

View 1 Replies View Related

Caps Lock

Jan 6, 2005

How can I convert the lower case data into upper case data automatically while entering data without using Ucase() function, in each and every textboxs or other objects in the forms ..

View 10 Replies View Related

Lock Table

Jan 26, 2005

Is there a way to lock a table from recieving changes that are made in other tables?

Liz

View 1 Replies View Related

DataEngine Lock

May 24, 2006

I have created a database form and put some buttons for various actions like acpreview Report"***".

Problem is when I click that button, it gives an error message :The database engine can not lock the table "**" because it is in use by another person or process.

I have checked and no one else is using this file.

Please help

View 1 Replies View Related

Lock Old Prices From Updating

Oct 4, 2005

Hi, please help if you can, i have searched the threads, but unfortunately didn't see anything close. Please point out if i missed some.

I am trying to lock or archive old records/invoices from updating when prices update for the same products/services.

Anyway of doing it a quick and dirty way perhaps?
U people rule! - built my entire system based on on your help threads/samples!

Thanks
V

View 4 Replies View Related

Lock The Object Sections

Nov 8, 2005

Hi

In MS Access:

Objects:
Tables
Queries
Forms
Reports
Pages
Macros
Modules

Groups:
...

I want to lock the Objects section, because I made the Groups in the groups section. How can I lock the objects section.

Please let me know, thanks a lot.

View 1 Replies View Related

Security 'Could Not Lock File'

Nov 30, 2005

Hi all,
We are changing domains and are doing alot of bouncing around with passwords and such.
Now all my users who are not in admins can not open our Db.
We get a message 'Could not lock file'. Any ideas?
thanks

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved