Hi:
i have a MS Access aplication that have a vba code with a password.
Now i have a patch (in MS Access too) that will upload this full aplication, but when i try to copy a form didnt work. This is because have password in the vbe code.
someone knows how can i unlock the vbe before update the form and after update the from lock in VBA language?
thanks
I want to lock down and unlock the full menu based on a password..
For instance upon load of the database I would like it stripped down when a general user logs in... but if a admin logins in then they get all menus...
so based on the user type will dictate the menus visible.. cane this be achieved'''''''''''';
Hi,
I am trying to open my form locked and have the uers click a button to unlock the form to enter data. The way i do it now is have 2 forms one set to allow edits "yes" the other set to "no" and then have a button for each
This is working ok but i would like to tidy things up a bit and get it to one button.
I struggle with programming but i will do my best to understand any posts.
Thxs for any help
Adz
Hi all,
I'm having a problem here and after searching the web, I can't find a solution.
Problem is that I have a form which seems to be locked. None of the fields can be modified. This should be ok except for 1 combo-box.
I have checked all objects settings and all objects have:
Edit/Delete/Add options enabled;
Visible option enabled;
Locked option disabled;
The form has only Fromview enabled and recordlock is off.
There is no VB code modifying a 'locked' status.
Can someone help me out here?
My project is +20Mb so first I'd like to see if there are any things I've forgotten to check before I'll strip and post it.
Hi! I'm certin this is something really simple, but I just can't remember how I've done it before.
I have a combo box called "ReferralReason" and when a particular option ("Other") is chosen from the list in there, I want the text field "ReferralReasonOther" to become unlocked.
Could someone please tell me:
a) do I type the VBA code for this in the properties of the combo, or, the text field? (Does it even make a difference)
b) what do I actually type?? :confused:
Thanks in advance for your help!
On mij registration form I have the option to fill in the name and day of birth, email and GSM number of the partner off the main contact.
But to keep the form nice and clear, I only want to make the fields acceseble when the checkbox from [couple] is checkt OK.
How to make the fields and the Box around it Light Gray, so its very clear it issn't clickable.
The main coller is white BG and Green strokes. (see attachment) When the field [paar] 1 (couple in englisch) is OK then the fields in de eclips 2 are available And I want the collors of the stroke 25% black and de fields disabled.
I have two forms linked together.
frmMaterialRequest
MaterialRequest
Status
frmHandledBy
MaterialRequest
HandledBy
What I want is to meet the following:
- Form 2 to be locked but its "MaterialRequest" is enabled.
- HandledBy to be unlocked if the MaterialRequest meets the "Status" of "frmMaterialRequest" which is "Approved".
Hi..
I got a access file from a friend of mine, but when i open it in access, i don't see any tables or the standard menu buttons.
The only menu i see, is a docked menu with a couple of submenus, wich in turn open forms, where you can enter data..
How can i see the tables and bva script behind this access file?
I tried F11 and Alt-F11, but is does nothing.
He won't tell me how he did it, because he doesnt like to share what he knows...
Can anyone help me??
Thanx !
I have a form with 2 option buttons on it one with year 12 on it and one with year 13. I have a simple form with drop down menus and text boxes allocated for year 12s and 13s. I want all of the year 13 text boxes and drop down lists to be locked if year 12 is selected and I want all of the year 12 text boxes and drop down lists to be locked if year 13 is selected. I do not want to over complicate the form by hiding parts of it or having a new form open depending on the option button selected.
View 9 Replies View RelatedI have a form with several subforms within (tabbed subforms). I've used the code:
In the Current event of the parent form -
Code:
Me.AllowEdits = False
Me.AllowDeletions = False
Me.AllowAdditions = False
In the Current event of each of the subforms -
Code: (THIS NEVER WORKS FOR ME - RUNTIME ERROR)
Me.AllowEdits = Me.Parent.AllowEdits
Me.AllowDeletions = Me.Parent.AllowDeletions
Me.AllowAdditions = Me.Parent.AllowAdditions
In the Click event of the button -
Code:
Me.AllowEdits = True
Me.AllowDeletions = True
Me.AllowAdditions = True
So the main form is locked upon opening and unlocked with the click of an unlock button. How to apply this to the subforms as well. They just stayed unlocked the whole time.
I have recently split my database and added a password to the back end. I am now trying to re-link the tables as I have seen in other threads, but when I do this I am not prompted for the password I just get the message 'Not a valid password'
I must obviously be doing something wrong, can anyone help?
Hi,
Firstly thank you for your help, this should be a simple one I hope, but is cracking my head on the wall. Have searched and searched and can't find an answer.
I have an Access Db that is not password protected, but is asking for a password.
It opens on any other machine fine?
I think my version of Access is playing funny buggers with me, any suggestions?
I was trying to implement some security on this Db, which is why it happened I'm sure. I ran the security wizard, set-up two users and admin with passwords, I have the output file to "recreate" something too.
Issue is, I then copied this Db to another computer for use on there, it worked without a Password, so didn't need to worry about it, now I can't open any Db on my machine??
Your help on this obvious pointer would be great!
C
hi pals
i have set username and password for ms access file.
unfortunately i have forget that password?
how to crack that username and passowrd?
is there any softwares available?
i can easily crack the database pasword? but how to crack username and password of ms access file.
i have found a code that brings up a box when tab or clicking in to a box for editing as below:-
Dim strPassword As String
If InputBox("Please enter the password:") <> strPassword Then
SomeOtherControl.SetFocus
TextBox1.Locked = True
End If
its just that need to add a password as well, i have tried to put this in between the <> but this does not work. i would like a message to say incorrect password as well if possable.
I have created a web-database (? - There are globes over all the forms and tables icons) based on the Issues & Tasks template. This means that most of the data is entered and seen on the "Main" form, which has two tabs - Open Issues and Closed Issues. I have created a form that allows people at my work to input the necessary data and save it, so that it will show up on one of the two tabs. However, once a record has been created, I want to be initially locked if the ID/PK is clicked, so that data can't be changed or entered inadvertently.
SO, I changed the code so that when the ID/PK for a record is clicked, it brings up a different form, but one that looks exactly like the one that is brought up when entering a new form, but I locked all of the fields so that the information cannot be changed. It seems from what I have read that I can create a button on this form so that when clicked, it unlocks the fields on the form so that they can be changed, and then when clicked again it will lock the fields again. Is this true? If so, how can I do it? Or is there something similar I can do? I have seen codes that I could copy and paste, but I cannot figure out the place to copy and paste codes in Access 2010.
I have changed the Form properties so that Data Entry and all the "Allows" are set to No...
Hi all
Firsty i am a novice to Databases so i only really know the basics, heres my problem.
I have a database at work that i need to password protect, but i want it so when people open it up, it gives them the option of viewing it in read only mode, but if they have the password then they can use it properly and edit things, is this possible? and if so is it easy??
Thanks everyone
Chris
Ok I want to do auto backup using the auto compact db, I think I got from here., anyways I want to copy it but the auto compact cant because of the DB password is there a way around this like have the password in the path of the db?
View 2 Replies View RelatedHya.
In my database I've two diferents forms but I want one of them to be accessed only for few users where they have to type username and passaword.
Is anyone there could tell me how can I do that please?
Thanks
I don't realy know how to explain this but a college of mine has done something to her Access settings, whenever she tries to open a database it asks her for a User login password.
The prompt is a box with
Name: Centre Manager
Password:
If she types Centre Manager in the password box then it lets her in as normal. Everyone else can just access the databases without being prompted for a password.
Does anyone know what she has done?
A password to one of my MDB files has been changed for some reason and I need to get access to it. Does anyone know of a freeware program that I can get to gain access to it? Your help is appreciated.
View 2 Replies View RelatedI would like to set a database password for my back end so that ppl could not "exidentaly" open the wrong .mdb file. Then i want to send a database password from my front end to my back end so that users who use FE would login my BE automaticaly? Is this posible? If so, how?
One more question. Is it posible to based on a login name(form in FE) open a BE readonly or normaly?
Thx
I created a workgroup account with a password. I joined this work group and all has been well until my harddrive died. I have the work group and I have the password but I can't remember to user name. Is there anyway to open the work group to get the user name?
Jon
I'm creating a data access page that can be used over the internet to add information into the database. The database is password protected. The functionality currently is that when a user accesses the data access page, they need the database password in order to submit information. We don't have a small number of users and giving all these people the password to the database would comprimise the security of the system.
I am looking for a functionality such that the people that edit the database, either by the front end application or by opening the database directly to be password protected. But the data access page not to be.
Any ideas on how I can achieve this functionality?
Hi. In my database it opens up in switchboard mode. Is it possible to create a password within a switchboard?
I also different levels depending on which switchboard item they choose.
e.g. if they click "student" rather than "teacher"
How do I acheive this?
Thanks!
I have successfully created a user id & password prompt which works excellently.
The database i have created has three forms inwhich two departments access. I have an issue where one department is only allowed to view a search screen and the other department is allowed to enter in information and search. I also have a section for managers to login and run reports.
In my userid & password table i have created and field called Level which includes: Administrator, Manager, Bookings,User
Admin - Full Access
Managers - Full Access - But not able to edit queries and tables
Bookings - Order Form, Search Form
User - Search Form
Here is the code i have used:
Login OK Button:-
Private Sub login_Click()
If txtPassword.Value = DLookup("Password", "tblAccess", "[UserId] = txtUser.Value") Then
CheckFlag
DoCmd.Close acForm, "frmUserLogon"
Else
MsgBox "INCORRECT PASSWORD! Please try again"
End If
End Sub
Module1:
Option Compare Database
Public Flag As Integer '1: Reports Opener 2:Log 3:OpenUKSupplier
Function CheckFlag()
Select Case Flag
Case 1
DoCmd.OpenForm "frmReports Menu"
Case 2
DoCmd.OpenForm "frmbooking"
Case 3
DoCmd.OpenForm "Frmsearch"
Case Else
'Should never be here
End Select
End Function
Where would i add the code to the module or to the event?
Hi,
I have secured my db with password. I want to know the technique/technology so that i can read my password. Access must be storing the password in an encrypted form in any password file. My idea is that if I know the file where its stored and in what form then I hope it can be retrieved.
I find so many available sites who claims that they have their product which is able to retrieve access db passowrd. I want to learn on how to do the same.
Any idea or suggestions is highly appreciated.
Thanks.