Forms :: Prevent Edits Based On Permissions

Jul 24, 2014

I have created an ACL table (access control list) where I have the fields UserID,FormName,CanSee and CanEdit.

When the user opens the db, the on open event gets the LoggedOnUserName and then check my ACL table to either prevent viewing or editing.

I have got the prevent viewing part working, but am having a small problem with the prevent edits.
I can set the property to prevent edits, but i need the user to be able to search records. the combo box is disabled if I use the following code.

MyCount = DCount("User_ID", "dbo_NPY_ACL_User", "(dbo_NPY_ACL_User.User_ID)=" & MyUserId & " AND ((dbo_NPY_ACL_User.CanEdit)=False) AND ((dbo_NPY_ACL_User.NavBtn_ID)=" & MyTab & ")")
If MyCount > 0 Then
Me.AllowEdits = False
end if

View Replies


ADVERTISEMENT

Two-table Query-Based Form Won't Allow Edits

Oct 2, 2006

Have the data settings for the form all allow=true
And tried the VBA allowedits=true on form open but the form is still locked.
Any suggestions about why?
Is updating two tables from a two-table query not allowed or???
Thanks,

View 1 Replies View Related

Forms - Allow Edits, Only When Requested

Nov 29, 2003

Hello,

i am relatively new to databases so this is a fairly basic question.....

I have a form. Within this form all records are locked as i do not wish users to change details. However i am told there is an option allowing the editing of existing records upon request. is this true?, as it would improve my form greatly

help would be much appreciated

thanks.

View 14 Replies View Related

Database Permissions (NTFS Permissions, Really)

Aug 13, 2007

Can anyone tell me what the ideal NTFS persmissions should be for users who are only inputting data to an Access database?

Would Read, Write, & Execute on the networked folder where the BE resides be enough for the users to update the database?

Thanks!
Michael

View 2 Replies View Related

Forms :: Allow Edits In Design Mode

Jan 9, 2015

I have a form which was locked down (ie Allow additions, allow edit and allow deletions were all set to no) on the Form property. I want to change this to allow edits so in design mode I changed the Allow Edits property to Yes.

I then went to Form view and was able to update fields on the form. When I exited the form it asked me if I wanted to save the changes so I clicked yes.

On going back into the form I can no longer update the fields I could before. Going into design mode I can see that Allow edits on the form property is set to no again.

What is happening here. There is nothing in the on load or other events to set this to no, besides this shouldn't change the form property should it?

I know I can get around it my setting the property in the form itself but why is the property getting reset in the first place.

Access 2010.

View 11 Replies View Related

Forms :: How To Restrict Entry From Second Edits

Nov 22, 2013

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 Related

Forms :: How To Disable Edits In General Tab But Not In Calls Tab

Apr 9, 2013

I have a form called Contacts that has two tabs. One is called General adn the other Calls.

In the General tab I have a bound field called CustomerIDdet which can be numeric or alphanumeric. I need to disable edits in the General tab but not in the Calls tab if CustomerIDdet is numeric (and it follows certain additional rules)

I have placed this code in the Onload even for the form:

Code:

If Len(CustomerIDdet) = 9 Then
If IsNumeric(CustomerIDdet) Then
If Right(CustomerIDdet, 4) = 9090 Then
If Left(CustomerIDdet, 1) = 0 Then
'disable editing in the General tab
End If
End If
End If
End If

I know how to disable edits control by control, but can I disable edits in all controls in that tab at once?

View 2 Replies View Related

Forms :: Record Source Not Allowing Edits?

May 17, 2013

i have a form that has a record source

Code:

SELECT tblClientDetails.FirstName, tblClientDetails.Surname,
tblClientDetails.MobileTelephoneNumber, tblClientDetails.SentTextMarketing
FROM (tblCategories INNER JOIN tblItems ON tblCategories.CategoriesID = tblItems.CategoriesID)
INNER JOIN ((tblClientDetails INNER JOIN tblOrders

[Code] .....

this does not allow edits on a continuous form. the edit i am trying to do is the check box. it will allow edits if the grouping is not on but if it is not on then i will get many duplicates of client details.

so how do i set it up to allow edits but still only get one instance of each client detail.

View 7 Replies View Related

Forms :: Are 2 Forms Required For New Entries And Edits

Mar 23, 2015

I have a form for inputting Crisp Brands. On the form is a Txt_box for entering the crisp brand an unbound txt box for renering the text box to ensure spelling is correct and a lst_box listing all existing crisp brands in the sytem.

First question is:

1) When i open the form i only want to be able to add new entries and not be able to edit old entries. However i would like some people to have the ability to edit existing ones. Is it best to create two forms one for new entries adn one for editing or is it best to add a command button on form for editing.

2) how do i achieve new entries only?

View 2 Replies View Related

Forms :: Apply Filter To Form And Allow User To Do Edits

Jan 10, 2015

I'm creating a database about Vets and I need to make a button on my menu form that will open something like message box that will allow me to type in something (in my case Customer ID) which will then apply the filter on the customer form and allow me to do edits. I have only done the macro that will open the customer form but can't figure out how to do the filter part.

View 2 Replies View Related

Forms :: Why To Undo Edits After Changed Records In A Form

Jul 22, 2013

I thought "Undo" was only available while in the current record.Here were my steps:

1 - Loaded form that shows 1 record per form page.
2 - Edited a record
3 - Moved to another record with status bar nav arrow
4 - Verified my edit was in the underlying table
5 - Moved back to the original record, again using status bar nav arrow
6 - Clicked my "undo" control and the original data appeared in the form
7 - Moved to another record
8 - Verified my original data was now back in the underlying table

My undo control has this vba on click:

Code:
DoCmd.RunCommand acCmdUndo

View 1 Replies View Related

Prevent Duplicate Records Based On Multiple Fields

Nov 15, 2005

how or what function (DLookup) should I use to prevent duplicate records based on multiple fields? I want to look at data in three fields that can't match existing data in those three fields. It's ok if one or two of the fields match but not all three.

View 2 Replies View Related

Forms :: Timesheet Database - Restricting Edits To Records By Other Users

Dec 27, 2013

I have a timesheet data base and I wanted to find a way to restrict employees from editing other employees timesheets only their own timesheet... .is it possible with access 2010?

View 4 Replies View Related

Forms :: Edit Button To Enable Edits On Form And Subform

Sep 22, 2013

I have a form "Handover" on this form I have a button that enables edit functionality once clicked, I now have a subform on this form named "Bdown".

The Bdown subform allows edits without having to click the "btn_Edit" on the main form "Handover".

Is is possible to make the edit button on "Handover" control the edit function on "Bdown" also?

Currently "Handover" contains:

Code:
Private Sub btn_Edit_Click()
Me.AllowEdits = True
Me.btn_Edit.Caption = "Editing"
End Sub

[Code] .....

View 2 Replies View Related

Forms :: Split Form With Combo Box As Filter Allow Edits False

Sep 6, 2014

I have a simple split form with datasheet on the bottom and a couple of comboboxes (unbound) on the form header which the user can use for filtering the data. When some users open the form the allowedit property of the form is set to false, because those users can only view the records. But the result is that also the comboboxes cannot be set, hence no filtering!

View 6 Replies View Related

Forms :: Record Source Of Query Stopped Allowing Edits

Apr 10, 2013

My form with record source of query has stopped allowing edits.

I have reviewed property setting and do not understand what's going on.

View 2 Replies View Related

Problem Restricting Users From Forms Via Security/Permissions

Jan 10, 2008

I am receiving an unexpected message when a user tries to launch a form that the user does not have permission for via the Access Security-Permissions setting that I have configured.

I am trying to set my Access db up so that Guest users can only access 2 Forms - the Switchboard and the Main form. There is a Maintenance Form and I don't want Guest users having access to it.

I have configured Security and created a Group named Guestgrp. I have also created a user named Guest that is assigned to the Users and Guestgrp groups.

The Users group is currently set up with NO permission for any form.


Here are the Guestgrp permissions for the forms, db and tables

The following forms have Open/Run and Read Design permission
Switchboard
MainForm

The following forms have NO Permissions selected
Maintenance Form

The database permission is set to Open/Run

Table permissions
The Guest group has Read Design and Read Data permission for all tables


so here is what happens...............
My Guest user can log in and launch the Switchboard form and can launch the Main Form from the switchboard.
BUT......................
When my Guest user clicks on the Switchboard button for the Maintenance Form, the following message pops up:
There was an error executing the command.

Is this the normal way for Access to indicate that the user does NOT have permission to access a form? I am guessing/hoping that it isn't and if configured properly there would be a message indicating that permission is denied or something of that nature.

If anyone has any comments, suggestions on the error in my ways, I appreciate any comments/suggestions/clarifications.

Thanks

View 4 Replies View Related

Forms :: Setting Add / Edit Permissions On Form Tabs

Jun 5, 2013

I have an Access 2003 database. I have a form with 5 tabs. I want to prevent some users from editing data on some of the tabs.

I added some logic to the OPEN property of the parent form but it does not work. "Object doesn't support this property or method." What is the correct way of controlling access of the data on the tabs?

In the logic below I first determine the user's permission for each tab. If the user has read-only access they will not be allowed to edit anything on this tab. There are 50 fields on the accounting tab and a subform. If possible, I don't want to have to specify each field individually in the code. Plus there are 5 tabs with numerous fields on each.

BTW: [add designer] is the parent form and [accounting] is the tab.

If DLookup("[permission_studentacct_ReadOnly]", "Users", "Contact_ID = " & Forms![Global]![UserID]) = True Then
Forms![Add Designer].[Accounting].AllowEdits = False
Else
End If

View 3 Replies View Related

Forms :: How To Prevent Duplicate Data

Aug 11, 2015

I am putting the student names in a form. I want it to alert me that a name is duplicated. But thats not this simple. For example a name is Jennifer Locus but I type jenifer with one . Can access guess that this might be the same person and suggest me to correct the spelling or enter it as a new person?

View 2 Replies View Related

Forms :: Prevent Duplicate Records

Oct 16, 2013

the proper code to prevent duplicate records in my form?

I'm using:

Private Sub Ctl_Lname_BeforeUpdate(Cancel As Integer)
Dim dupCount As Long
dupCount = DCount("*", "Clients", "[LastName]= '" & Me.[LastName] & "'" & " And " & "[PreferredName] = '" & Me.[PreferredName] & "'")
If dupCount <> 0 Then
Beep
MsgBox

[code]....

"This name already exists in the database. Please check that you are not entering a duplicate person before continuing.", vbOKOnly,

View 10 Replies View Related

Forms :: Prevent Duplicate First Name And Surname?

Apr 25, 2013

I just need a simple method to prevent a member being imput twice on a form.

I have two fields firstname and surname ( this is necessary).

I want to stop duplication of the same person being entered when staff use the form.

How do I stop this?

View 2 Replies View Related

Forms :: Prevent Cut Functionality Within Unbound Combobox

Jun 28, 2015

I am trying to prevent any foolish behavior from taking place upon a form. I have textboxes and comboboxes that users need to input data into or make selections within.

I came up with a method to prevent Paste as follows:

Code:
Private Sub ComboBox_KeyDown(KeyCode As Integer, Shift As Integer)
Call PurgeClipBoard()
End Sub

[Code].....

However if I remove the MsgBox logic then the Cut is not prevented.

Note you need to include the Declares for those api functions if you use them.

View 14 Replies View Related

Forms :: Prevent Wrapping In Memo Field Box?

Aug 28, 2013

Is there a way I can prevent wrapping in a memo field box?

I have a memo field with a list of email addresses and usernames however the email addresses often just wrap around the end of the memo box just creating a new line in the memo box rather than properly showing the email without the wrapping.

Even if the message scrolls out of the box, id rather that then wrap the text.

Also is there a way in which I can enable someone to open the "ZoomBox" whilst the text box is locked/disabled.

View 5 Replies View Related

Forms :: Filter To Prevent Repeating Records

Aug 7, 2015

I need to create a form and report. I created a Form now (i want to Report too.) but i saw, some field records are repeating themself.

I give an example :

ID Group Project Name Maintainers
1 A X-File Top-Secret Saruman
1 B X-File Top-Secret Gandalf
1 C X-File Top-Secret Radagast

On my report or form i want to see only :

ID: "1"
Group: "A" , "B" , "C"
Project: "X-File"
Name: "Top Secret"
Maintainers: "Saruman" , "Gandalf" , "Radagast"

Is that possible to filter records like that ? and How ?

View 3 Replies View Related

Forms :: Prevent Duplicate Records From A Form?

Nov 12, 2013

Im trying to prevent duplicate records based on a PO # (RA_PO_Nbr), entered from a form. I'm trying to throw a 3022 error when the user attempts to enter a record that already exists, but I dont necessarily have to do it this way.

Code:
Private Sub cmdSubmit_Click()
On Error GoTo cmdSubmit_Click_Error
Dim db As Database
Dim rst As DAO.Recordset
Dim strSQL As String
strSQL = "CompanyPOTable"

[code]....

View 7 Replies View Related

Forms :: Prevent Duplication In Form Entry

Jul 7, 2014

I've been trying to use some code I've found to prevent a user from entering a duplicate ID. I've tried this:

Dim Answer As Variant Answer = DLookup("[SAR_ID]", "Request", "[SAR_ID] = '" & Me.SAR_ID & "'")
If Not IsNull(Answer) Then MsgBox "Duplicate SAR ID Found" & vbCrLf & "Please enter again.", vbCritical + vbOKOnly + vbDefaultButton1, "Duplicate"

Cancel = True Me.SAR_ID.Undo
Else:
End If

but it displays the message even if I don't enter a duplicate.

View 14 Replies View Related







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