Can You Put Passwords On Buttons In A Form???

Apr 12, 2005

Im doing a project and i have two different views i.e. Branch View and Staff View but i dont want Staff view to be able to access Branch details and visa versa!! Is there any way i can do this??

View Replies


ADVERTISEMENT

Passwords & Command Buttons

May 6, 2005

Hi all,

I'm having a problem trying to get some code to work that a member of this forum helped me with some years ago. Basically I have a form with a combobox that is used to select the user name and a textbox for the password to be entered. There are two different types of user, manager and clerk. The logon button must open the selection screen form but if the user is a clerk, then the delete client command button must be disabled.

I keep getting a 'Compile Error stating Block If without End If' and I'm not sure where I'm going wrong.

I'm also not sure what code I should be writing to disable the command button dependant on user.

I know this is not great security, but it's only going to be used as an interim solution for 4 people (none with access experience). Can anyone please explain to me why I'm getting the compile error and what code I would need to disable the command button on the form and where I would need to put it.

Many thanks.

Here is the code:

If Me.Password = Me.Combo10.Column(4) Then
If Combo10.Column(3) = "Manager" Then
DoCmd.OpenForm "frm_Splash_Screen"
ElseIf Me.Password = Me.Combo10.Column(4) Then
If Combo10.Column(3) = "Clerk" Then
DoCmd.OpenForm "frm_Splash_Screen"
End If
Else
Msgbox "Incorrect Password, try again"
End if

View 8 Replies View Related

Round Buttons Or Oval Buttons Instead Of The Normal Square Buttons

May 30, 2005

Hello everybody,

I’m new here and I have a question for you..

Is it possible to place round buttons or oval buttons on your forms instead of the normal square ones?

Greets,

Tom

View 2 Replies View Related

Change Colour Of Navigation Buttons And Command Buttons?

Mar 17, 2006

Is this possible? I can't seem to find this q anywhere here so I thought I'd post.

I changed the colour of my form to white, but the Navigation Buttons at the bottom and the command buttons that I 've added stay at the default grey.

Is there anyway to change this? I right-clicked and tried changing it to white through the properties but there's nothing there that does this.

:confused:

View 2 Replies View Related

Change Colour Of Navigation Buttons And Command Buttons?

Mar 17, 2006

Is this possible? I can't seem to find this q anywhere here so I thought I'd post.

I changed the colour of my form to white, but the Navigation Buttons at the bottom and the command buttons that I 've added stay at the default grey.

Is there anyway to change this? I right-clicked and tried changing it to white through the properties but there's nothing there that does this.

:confused:

View 4 Replies View Related

Passwords

Jul 21, 2005

How do I set up my database so that a password is required if the User tries to press F11?

Any ideas?

bizzy

View 1 Replies View Related

Need Help On Passwords

Mar 16, 2006

hiya everyone:o . is there anyone that can help me.i need to know how i can put passwords onto access programs i have made. so when i open a form you have to enter a password to get in to it.
thanks richie_b60:confused:

View 7 Replies View Related

Lost Passwords

Jun 22, 2005

I created a DB in an old PC of mine for a customer. I set passwords for user accounts to prevent users from accessing the design etc. I bought a new PC lately and I want to open the DB to work in it but I get an error saying that I do not have the rights. I suppose I need to create the same accounts in my new PC as in the old one but I don't remember the username or password that I was using back then. Any Ideas???

View 4 Replies View Related

Admin Passwords

Nov 1, 2005

Within our client estate, there are a number of types of machines and a number of admin passwords that go with them

I need to put an agent on each of these machines but first i need to make all the admin passwords the same or add our domain group to the local administrators on that machine.

In order to do that I need to know what the admin password is for that specific machine

So a series of attempts with various different passwords and users names are required.

so something like this maybe

dim admin1 as string
dim pass1 as string
dim admin2 as string
dim pass2 as string
dim admin3 as string
dim pass3 as string
dim admin4 as string
dim pass4 as string


call Shell("psexec \192.168.0.1 -u + admin1 + -p + pass1")
if error = 1 then



call Shell("psexec \192.168.0.1 -u + admin2 + -p + pass2")

else

end if

end

Is this the best way to approach this? - Am confused? - Thank you

View 1 Replies View Related

Storing Passwords

Nov 4, 2005

Hi guys how do you store secure passwords in the database?

So that if someone has acess to the database they want be able to see what they are.

View 5 Replies View Related

Enable Passwords

Jun 12, 2007

I've created users and groups in my access database and assigned the permissions. My security wizard is not working. How do I enable the secuirty-- force the users to logon with a username and password?

View 3 Replies View Related

Users And Passwords

Feb 12, 2008

This is probably a really easy thing to do but I need to set up users and passwords to access a database that will contain sensitive information so cannot be accessible to everyone.

Can someone please tell me an easy step-by-step way on how to do this, with multiple users allowed to add and edit information (but not the workings of tables, queries etc)?

I am pretty much self taught so nothing too technical if possible!!

Also, the user's name needs to be input into an "Entered By" field in a form automatically depending on who has logged in when a new record is created.

Thanks in advance for your help with this.

Emma

View 5 Replies View Related

Getting Passwords From Forms

Feb 23, 2006

hey, i have been designing a database and i have made a switchboard with forms on it and i have another switch board with backoffice functions which i only want staff with admin rights to be able to get into. i am using the code below but what i need to figure out is how to select any Password from the "Password" field where users have "Admin" in their "Access Rights" column. if that makes sense to any of you!

heres the code

Private Sub cmdOpenEmpForm_Click()

'Attached to On Click event of cmdOpenEmpForm

Dim strPasswd

strPasswd = InputBox("Enter Password", "Restricted Form")

'Check to see if there is any entry made to input box, or if
'cancel button is pressed. If no entry made then exit sub.

If strPasswd = "" Or strPasswd = Empty Then
MsgBox "No Input Provided", vbInformation, "Required Data"
Exit Sub
End If

'If correct password is entered open Employees form
'If incorrect password entered give message and exit sub

If strPasswd = "Graham" Then
DoCmd.OpenForm "frmEmp", acNormal
Else
MsgBox "Sorry, you do not have access to this form", vbOKOnly, "Important Information"
Exit Sub
End If
End Sub


at the moment the password is just set to Graham, any help would be fantastic

View 1 Replies View Related

Database Users And Passwords

Aug 2, 2005

I would really like to have a better understanding of the secrurity that comes with access. I would like my DAP to be able to log in with the previleges given for each user. I would also like these previledges to work when someones opens the database with access, however, whenever I set the secureity stuff, copy the database to the fileserver, I can then open it with another computer without any problems. Why is this? Thanks guys, I'n new here.

View 2 Replies View Related

Hidding Things & Passwords

Sep 21, 2005

Hello.

I want to prevent people accessing the control boxes on a 'satalite' mdb. I have hidden the control at the top through the start up options, but havent prevented the special keys as I occassionally need to get in this database for error fixing and such like. I want to know if I can put a password on this function, so that if they know it and try it it asks for a password before opening the control windows/table pages etc.

does anyone know if this is poss and if so how too ???

Thanx in advance for your time

View 2 Replies View Related

Linked Databases Passwords

May 11, 2007

I am currently working on a database which has links to two other databases both of which are password protected. The problem occurs when the main database needs to access data in the others as it prompts for their passwords to be entered.

I was wondering if anyone knew a way to automate this so that the user would not be asked for the password but instead it would be coded into the main database.

Any help would be appreciated.

View 1 Replies View Related

Passwords Or Creating Workgroups

Mar 31, 2008

I have developed an MSAccess Database on my Workstation with an authorized MSAccess License, and I need now to share this Database with other people from your company that do have MSAccess license as well.

I also need to secure my Database with access, read, modify and delete options because only one user knows how to run simple queries and create basic tables but the others only know how to enter data and analyse the info with Excel.

From what I understand, I am the admin and they are the users.

Question 1: Is it possible to unset the "Exclusive mode" to allow the users to enter data at the same time the Admin does?

Question 2: Is there another way to limit the access and define permissions other than with Workgroup - Workgroup Administrator does not seem to be user friendly. Would it be better to create a switchboard?

Question 3: Is there a site where I can get detailed instructions (courses) on Workgroup settings?

Thanks a zillion.

View 3 Replies View Related

Accessing The Database With Passwords

Jan 7, 2005

I have a database of books that contains all the informations about the books in a library, and ofcourse the forms for accessing the database ie searching adding editing and all this, is it possible in access to make a restriction so that only the administrator can edit or add to the database and the other users can only search for books and print reports
I know the logic of creating a password table and a form with a username and a password which checks if the user can access and then open the corresponding form (using isvisible property for the edit and add botton)
but even if i did that the user in reality can see the tables and the forms of the database and can change them directly
please if anyone has an idea??????
thanks

View 7 Replies View Related

Setting Up Users With Passwords

Mar 9, 2007

I am getting ready to set up my database with users who will need to log on. I did a test on a sample database, but for some reason, my database became unavailable, and it never gave me a login box. Is there somewhere one could point me for some detailed info on setting up users and levels in MS Acess? All of the books I have on Access just kind of skim over the subject.

Secondly, in a select query, is there a way to assign a field that is part of a table a value. For instance, upon running the select query could I assign the field CurrentUser =user() ? If so, then how would I do this? I am using data access pages for data entry, and I want to be able to track the person who enters the record without them entering their username for every record they process, but, here is the drawback, they are not starting new records, they are merely adding to a record that someone else started.

Even assigning the value =user() on the data acess page field does not rectify this problem. This only works when you start a new record. I am really stuck on this one, and I know virtually nothing about SQL or Visual Basic..... the last time I programmed was in the 80's and I was a whiz at BASIC and PASCAL, lol. I know, I know, I need to get off my rear and start trying to pick up on this stuff. Anyway, I think the answer to my problem somehow lies in assigning the field the value =user() from the query, but I am stuck on how to accomplish this.

Help me Access Gods

View 1 Replies View Related

Passwords Visible On Web Forms?

Oct 11, 2013

I have a form that includes a text box for a password. The passord works fine on a local table, but when I upload the form to the web the password is visible. How can I format the text box so that the text box shows "*******" on the web form?

View 1 Replies View Related

Forms :: Use Buttons On A Form To Change Sort Order On A Continuous Form

Jul 23, 2013

I want to use buttons on a form to change the sort order on a continuous form. In the buttons click event I am using a public function (named Sort_1) to change the sort order. The first element of the event call is the name of a generic query (named Sort_1_Query1) and the query field to sort (LAST_NAME OR FRIST_NAME, depending on the button.)This is the Click Statement.

=Sort_1("Sort_1_Query1","LAST_NAME")

This is the Public Function
Public Function Sort_1(SortName As String, FieldName1 As String)
DoCmd.ApplyFilter SortName, FieldName1 & "between 'A' and 'Z'"
End Function

I think the problem is in the use of quotation marks or trying to pass the query field name to the Do Command or the use of an ampersand.

View 4 Replies View Related

Tab Style Master Form - Navigation Buttons For Each Subform Within Form

Jan 26, 2015

I have created a master form, which is a tab style. I have five additional forms that I want to use as sub-forms within each tab. I also want to include master navigation buttons that will work for each sub-form in unison. In other words if I navigate to record 10 on tab 1 and switch to tab 2, I want the new tab to show the information related to record 10. It would appear that I need to link them together in some fashion.

View 1 Replies View Related

How To Edit User Passwords In Access

May 31, 2006

I have finished my database and I have started getting the user level security all setup. I have all the permissions and users working fine except that as I was creating the accounts I entered phony passwords thinking that once i had everything worked out, it would be easy to edit them or change them to real ones, but I cannot figure out how to do that.

Does anyone know how to do this?

Thanks

mafhobb

View 1 Replies View Related

Adding Users/changing Passwords Via VBA

Jan 19, 2005

so i'm using MS Access security features, .mdw file and all that jazz. i'd like to market my program, but i don't want to have to add/delete users and change/add/delete permissions for every new/existing user. is there any way around this via an unbound form in vba, ie, something like "New User Name: _______" "New User Password: _______" "New User Permissions Group: (dropdown)"? is this possible, or MUST you go through the security page?

thanks

View 11 Replies View Related

How To Recover Lost MDB Files Passwords

Jul 21, 2012

Due to my carelessness I lost my passwords of MDB files. I used to write all my passwords on a diary. But last week I lost it somewhere and hence I lost all my passwords. I have several MDB files of MS Access but now without passwords they are useless as I can't open them. How to recover my lost passwords back?

View 14 Replies View Related

Forms :: Navigation Form - Main Form Buttons

Nov 23, 2013

So I have made all the necessary forms to start working with my Access, and now I need a main form, a home where I should put all the buttons to enter each form.I have used the Navigation Control on a New form URL...

A row with buttons appeared, and I complete the property: Navigation Target Name with the target form, but it is giving me some trouble with a searchForm and a Query. Every time I enter this form (using nav control), Query asks for an Input.

View 2 Replies View Related







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