473,413 Members | 1,727 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,413 software developers and data experts.

Field level permisions

1
Hi,
I'm setting up a stock control database which will also be used by sales people to sell stock. It has to be secure (ie so that sales staff can't edit stock values for higher margins) but at the same time i need the sales staff to edit one or two variables. I've got a 'hold' field so that if someone sells some stock they can check it off as on hold to tell others not to sell that particular item.

Access doesnt seem to help me about this. It seems that i can either give permission to edit the whole form or none of it.

I've thought of a couple of ways to maybe get around this but I dont know how. If i could get a macro to edit this one field ('hold') and allow the macro to be run, would this solve my problem?

I've also tries to put the one field as a sub-form but I couldn't get it to work well.

Any help would be very much appreciated!!
Jul 7 '06 #1
1 1326
zzqxxq
28
I suggest that you check out the enabled and locked properties of the field you need to control. These properties can be tested and altered in VB for example

If txtMyHoldField > 0 then txtMyHoldField.Enabled = False
Else
txtMyHoldField.Enabled = True.
Endif

Making enabled = false "greys out" the field and prevents anyone from tabbing or clicking into the field or changing the value of the field

Making locked = true does not grey out the field and you can tab or click into it but you cannot change the value it contains

You can test this after a value on the form is changed or when the form is opened or closed and adjust as necessary
Jul 13 '06 #2

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

Similar topics

7
by: Rick Caborn | last post by:
Does anyone know of a way to execute sql code from a dynamically built text field? Before beginning, let me state that I know this db architecture is built solely for frustration and I hope to...
2
by: Joey P | last post by:
Hi all, I am doing a project for university whereby i have to implement a simple database related to a frozen foods company. I am having some trouble though creating a validation rule for one...
16
by: Georges Heinesch | last post by:
Hi. My form contains a control (cboFooBar), which has an underlying field with the "Required" property set to "Yes". Now, while filling out all the controls of the form, I have to fill out this...
0
by: Allen Browne | last post by:
Access does not have true field-level permissions, but I was recently asked to set up a database where some fields would be locked and others not. The idea was to allow the user who created the...
2
by: Diana Estrada | last post by:
Hi, I have a ASP .Net, and in this I load a report or Crystal, with this instruction: crReportDocument.Load(Server.MapPath("") & "reporte.rpt"); It's good, but when I try to load a remote...
9
by: sellcraig | last post by:
Microsoft access 2 tables table "data main" contains a field called "code" table "ddw1" is created from a make table query of "data main" Goal- the data in "code" field in needs to...
10
by: gweasel | last post by:
What is the best way to apply a Validation Rule - or rather, where is the best place to put it? Is there an advantage to putting it on the field in the table vs setting the validation rule on the...
2
by: charleythomas | last post by:
Hi, Allen Browne's "Field-level Permissions in Microsoft Access" (http:// allenbrowne.com/ser-55.html) is an excellent sample db i was looking for a long time. Am using Access2000. I have...
1
by: Luke Bailey | last post by:
I have an access database that I have secured using ueser-level security. I have my own logon in the Admins group. I have also removed Admin from the Admins group so that the standard end-user...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

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.