I have impletemented a user system for my database with different access levels relating to entering and editing data.
I would like to make certain forms only accessible to a specific group of users. Is this possible and how?
Thanks,
Gary
Is there any way for me to have a button on my frontpage visible to only people i name
e.g.
if user = john smith or user = fred bloggs then show the button if not do not display it.?
Being a novice step by step idiot proof help would be appreciated
TIA
hi
i am having a login form.
where i have only two users..may be 3
suppose it is admin and guest
then i have a main form where i have 5 tabs,...where each tab contains 7 or more command buttons which will open some forms
what i need is when the admin is login he should be able to edit add delete
but if it is a guest then all the forms should be read only
i know abt the allowaddition and etc..but i don't know where to use it..
is it in the login form or in the main form or in each and every form
regards
jenson
I have a staff database in my office which holds, amongst other things a list of staff holiday taken. Presently the staff have no access to view holidays because they will also be able to view other employees details. What I need to do is enable members of staff to see their own holiday, but no others and Im really not sure how to go about it.
I have a workgroup in place; so each user has their own login/password.
Any ideas would be gratefully received.
Thanks,
Adam.
Hi, I would like to know how to do the following scenario in Access 2000.
Imagine I have a table, which has two fields X and Y.
User can only enter either field X or Y, but not both.
How to check the above case while user is real-time keying in the fields of the table?
Thanks, Sally
I have the below script:
For Each Item In offexchfldr.Items.Restrict("[SenderName] = '" & frmfm & "'") ' Select Items that match Sender Name on form
If Item.TaskSubject = subid Then
Item.Categories = frmcat ' Update category from form to outlook
Item.Save
End If
Next
This script checks every item in the outlook inbox where the item.SenderName = my database sendername
This works every time except for when the sendername has quotes or single quotes in their name. So i am trying to utlize the replace method on the item sendername before trying to find the items in the inbox but its not working.
Below is my attempt that does not work.
For Each Item In offexchfldr.Items.Restrict("Replace([SenderName],',"") = '" & frmfm & "'") ' Select Items that match Sender Name on form
How do I restrict access to the database while still being able to add a new hyperlink? I tried deselecting the "display navigation pane" option. But when I do this I am unable to add/edit a hyperlink in a form - when I right-click the only option I get is "add to favorites" rather than "edit", etc.
View 8 Replies View RelatedI created a database which when macros are enabled the only thing visible on the screen is the forum. All tables as well as the ribbon bar is disabled. I also disabled right-clicking.
My issue is, for those who do not have macro's enabled, it opens up in design view and allows access to the left-hand tables until the user clicks the trust button at the top. Once trust is clicked, everything hides as expected.Is there a way to restrict access if they do not have their macros enabled?
How to restric forms entry to be restricted from second edits .. means if some one posted single entry one time and wanted to post second edited entry i need form to ask passoword. or not to be updated if not available the password option.
View 3 Replies View RelatedI have a database in Access 2010 where I've created a navigation form, and I want a regular user opening the database to enter a password and only have access to that form, and not the actual tables or the navigation pane. They should only be able to view, add, edit, and delete data through the forms I've prepared, and I don't want them to be able to get to the tables themselves unless they have an admin password. I tried looking up how to do something like this, and I tried splitting the database, but it seemed like I was still able to go right to the tables and edit them from the navigation pane even in the front-end, and if I removed the navigation pane links to the tables from the front-end, the forms I made wouldn't be able to display anything from them anymore, and that's not what I want either.
So, I want one password to give access only to my navigation form and nothing else, and then a second password to grant access to everything else.
how to restrict access to forms and reports using the Active Directory. It is a pretty simple method to pick up and easy to use in any database. My problem comes when I try to apply this same method to tables and queries as well.
View 5 Replies View RelatedI want to restrict the users to only be able to access certain tabs in the ribbon .example "user1" cannot access the external tab and the create tab, but can access all others.
View 9 Replies View Relatedi have a main form called frmSearch with a sub form called subform_CasesSearch the rowsource is a query called qryCasesSearch which has a check box field called CaseClosed.the main form has a combobox called cboNy which filter the sub form.for filter i'm using the code
PHP Code:
Private Sub CboNy_AfterUpdate()Forms!frmSearch.subform_CasesSearch.Form.Filter = "NyID =" &
Me.ComboNyabaForms!frmSearch.subform_CasesSearch.Form.FilterOn = TrueEnd Sub
I want to complete the code above to add a condition by an unbound checkbox (or any method ) in the main form to restrict the filter result ... so the user can show all fields or fields has a CaseClosed checked only or fields has a CaseClosed not checked only.
This seem to be simple for single criteria but i am not able to do it multiple. I want to restrict user to customer list they r able to see in form combo box drop down list.
users are in employee TBL
employee group criteria is in tbl_Groups which contains value Admin,Read Only, manager etc
employee r grouped through tbl_AssignUsersToGroups.
customer r grouped in customerType TBL. i.e class1, class2 etc
created EmployeesClassTypeRestriction TBL to store restrictions for employees
Restrictions criteria:
1-employee can view only specific class which includes all customers in that class
2- employee can view only specif customers in a class only.
3-employee can view only specif customers in a ANY class.
4- No criteria No restrictions and can view all customers in all classes( For Admin )
Tried to used Tempvar criteria in customer combo box qry but it works for above point 1 only.
Attached accdb sample also.
I have two fields on a form. One of the fields has to be entered first in order for the other field to be filled. How can I restrict the user to enter a value in filed #2 before filling the filed #1?
View 7 Replies View RelatedOn a split database, is there a way to restrict a form so that only one user can have it open at any one time?
View 3 Replies View RelatedI need to be able to restrict users enter a value in the text box (on Form B) called "FTE Assigned" if Dsum of a field called "FTE Allocated" in another form A is less than what is going to be sum of FTE Assigned after the value is entered.
Both these forms are used by users to enter data in the 2 separate tables which are linked together through a join.
Master table - having FTE Allocated values and secondary table having FTE Assigned values.
Basically a message box would do if Dsum (of FTE used) is coming out higher than FTE allocated.
I am building a form in access and I am trying to find a way where user input isn't possible in the associated textbox when "No" from on option box is selected.
View 3 Replies View RelatedI have a database that I want to install on a client's pc as a demo only. I want to restrict the number of records he can enter to 3. Is this possible in access? I will appreciate any help. Thx!
View 2 Replies View Relatedhi all
i have created a form to enter details into a 'job' table.
here is the part of the form my question deals with.
FIELD- Airport DATATYPE- Yes/No
FIELD- Terminal DATATYPE - Lookup wizard (the values 1-5 stored in a separate terminal table)
basically the system involves entering minicab jobs into the database.
the job may or may not be at the airport.
THE RESTRICTION I WANT TO PLACE ON THE JOB FORM/TABLE
if the airport checkbox is ticked (Yes), then the terminal value can be set (1-5) from the form.
if the airport checkbox is unticked (No), then the terminal value cannot be changed from the form.
if this can be done, how can it be done? anyone..??
My query is how to restrict a user when he logs in......say for example, if he is a guest user he will not be able to change the setting neither he will be able to see the design mode..i am using access 2003
View 3 Replies View RelatedHey all,
I'm having a horrible time trying to get this to work. Basically, I have a database which has multiple tables. All of my tables are being generated with a CREATE TABLE statement. What I would like to do is add a validation rule or something else upon creation so that only X number of entries can be entered into the table.
Initially, I just added a rule that said id<5 or whatever manually to the table in order to restrict the number of entries, but I can't figure out how to do this automatically in my SQL statement or Visual basic. I want to be able to have this check added upon table creation. Surely what I'm doing must be possible.
Am I going about it the wrong way? Any Help would be appreciated. Thanks!
Hi,
Is it possible to restrict data entry for some users only on one field?
Regards,
B
I have a HUGE system which presently restricts updating a "Final Action" date to today's date only. However, I want to change it so users can input dates for only the present working week. The present coding is as follows...
Private Sub dteActioned_AfterUpdate()
Dim strTime As String
strTime = "07:30"
gintChanged = gintChanged + 1
If Not IsNull(Me![dteActioned]) Then
If Me![dteActioned] > Now Then
gintReply = MsgBox("Your actioned date is later than today !!", vbOKOnly + vbCritical, "Oops")
Me![dteActioned] = Null
Me![dteActioned].SetFocus
GoTo Exit_dteActioned_AfterUpdate:
Else
If Format(Me![dteActioned], "dd/mm/yyyy") < Format(Date, "dd/mm/yyyy") Then ' final action earlier than today
If Weekday(Now) = 2 And Format(Now, "hh:mm") > strTime Then
' If Weekday(Now) = 6 And Format(Now, "hh:mm") > strTime Then
' Not acceptable to enter a previous date
' older than 7 days is not acceptable
gintReply = MsgBox("Now too late to accept this 'Final Action' date !", vbOKOnly + vbCritical, "Oops")
Me![dteActioned] = Null
Me![dteActioned].SetFocus
GoTo Exit_dteActioned_AfterUpdate:
Else
' Previous date is acceptable but only as far back as 7 days
If CVDate(Me![dteActioned]) < CVDate(Now) Then
' older than 7 days is not acceptable
gintReply = MsgBox("Now too late to accept this 'Final Action' date !", vbOKOnly + vbCritical, "Oops")
Me![dteActioned] = Null
Me![dteActioned].SetFocus
GoTo Exit_dteActioned_AfterUpdate:
End If
End If
Else
' Actioned date is acceptable since it is today's date
DoEvents
End If
End If
End If
' if today is a Monday Only accept final action dates which fall within the previous week if today
Exit_dteActioned_AfterUpdate:
End Sub
Probably very simple but I just can't get it to work. Help please! Time is short.
Hey,
I have several list combo boxes on my form that I want to prevent users from adding data to. How can I do this? For example, there is a list box for insurance carrier, etc. :confused:
Thank you,
debo
Hello,
My "customer" form is based on sigle table. I have to restrict no of customers only 5 customers. can anybody help me ?
This is required for distributing a database.
Regards,
Satish