Put Password Protect On One Form From On Click Command From Mainform.

Nov 4, 2004

I'm new in access world. please help. I have many forms that control by On click command from the main form. One of the form (which is Calendar form), I like to have password protect in away that only the right ID or password would have access to edit this Calendar, If not users can only view it. Is this possible?, if it is can you please provide some code for me...Thanks in advance..

View Replies


ADVERTISEMENT

Password Protect A Form?

Aug 28, 2007

Hi

i am wondering if it is possible to password protect a form?

I am building a DB which will hold personal information, all this info will be held in a table and displayed on a form, but I would like it so that the user has to enter their user name and password and only the form which relates to their details opens ( so like an open form and display specific field but passworded)

Any ideas?

View 3 Replies View Related

Password Protect A Form

Jan 25, 2005

Is there a way to password protect a form.

This is due to me having to send a mdb file, because i use A97 and the other end use A2000.

I tried sending the mde file but they could not convert it etc.

But i want to stop them getting into the code, you know how protective we are.

I want to hard code the password if thats any help.

Could some one please help me, thanks

View 4 Replies View Related

Password Protect A Form

Feb 11, 2005

How can i simply prompt the user for a password when they click a button, if the password does not match the form will not open?

View 1 Replies View Related

Can I Password Protect....

Dec 7, 2006

one form in my database?

I would like to put a password on one form; all other forms are open to see.

Can this be done?

View 1 Replies View Related

Password Protect Backend

Jun 17, 2005

I have an Access 2000 split into FE and BE and the client has requested the BE be password protected. I attempt set database password on BE but then when I open FE I get error msg " not a valid password". I get the same error message if FE has same password or if FE has no password.
Any ideas?

Thanks,

Jim

View 3 Replies View Related

Password Protect VBA Code

Sep 19, 2006

Hi,

Is the password property in Access secure enough to protect VBA code?

Regards,
B

View 14 Replies View Related

Password Protect A Table?

Dec 2, 2004

hi,

Is it possible to password Protect a table in Access 97?

I need to limit who can actually go into the raw data table as even though it is hidden, a user can easily unhide if they knew how.

any ideas?

View 3 Replies View Related

Password Protect A Button

Feb 3, 2005

Can someone point me in the right direction of how to protect a button using a password please

cheers

Andy

View 1 Replies View Related

Trying To Password Protect A Report.

Feb 14, 2006

As you can tell, I am trying to password protect a report.

This works great, but if you don't type anything in, all the employees names come up. How can you prevent that.

Like [Enter Employee Name Only] & "*"

Any Ideas

View 3 Replies View Related

Password Protect A Button

Feb 3, 2005

Can someone point me in the right direction of how to protect a button using a password please

cheers

Andy

View 7 Replies View Related

Password Protect Database Window??

Sep 6, 2005

Hi,

How can I hide the Database window with password protection?

For example, if someone attempts to access the Database Window, they would be promted to enter the password before they can see the tables and queries...


Thanks for your help

View 1 Replies View Related

Vba: Open Password Protect Spreadsheets

May 24, 2006

Hi all!

I have some Access 2000 VBA code which opens all of the Excel 2000 spreadsheets in turn in a particular folder. However, if one of the spreadsheets is password protected I want to ignore this file and move on to the next one...is this possible?

Any help most appreciated.

Neil

View 1 Replies View Related

Is It Possible To Password Protect Specific Macros?

Feb 20, 2007

Ive searched the forum and not found any threads relating to this. Some help would much be appreciated!

View 3 Replies View Related

Reports :: Possible To Password Protect A Report

Oct 28, 2013

i was just wondering if it was possible to password protect a report. so for example when a user clicks on the button from a switchboard a password prompt would open up and if a user entered an incorrect password the report wouldnt open up.

View 2 Replies View Related

Forms :: Password Protect A Checkbox With Particular Record

Jul 15, 2013

I have a checkbox that when checked will close that particular record from future editing. I want to be able to password protect this checkbox. Also I want to be able to uncheck this box with a password if we need to reopen that record.

View 2 Replies View Related

General :: Possible To Password Protect Access To Source Code?

Jun 10, 2012

I've been working on a large project for my employer for a year now (but software development isn't part of my normal day to day duties). Most of the work (around 70%) has been done in my own time at home. The company were going to buy a system that would be customized by developers at a cost of around $60,000. I've developed a solution that is probably better than what they would have got. At my last appraisal my boss said that it had been discussed that i would be rewarded if i delivered it. My question is:

Is it possible to password protect access to the source code? I'm working with Access 2003 just now. I know I can create a .mde file to prevent access to the source code but that would make further development difficult. e.

View 8 Replies View Related

Forms :: Popup Subform - Password Protect Individual Records

Jul 23, 2014

So I created a new form that multiple coworkers will have access to. I understand that you can password protect an entire data base, but I was wondering if you could go deeper than that. I have a main form with a combo box (query to show existing IDs) for "ClientID" that links the main form and subform (Its controlsource is ClientID from the table the subform was created off of). If a user selects an existing ClientID, the linked subform pops up with the selected ClientID displayed on the subform in a field along with existing additional information displayed. If The user types in an ID not in the database, a blank subform comes up for the coworker to create this new record and the field for ClientID is blank.

1) How can I make it so that when a coworker types in a ClientID in the combobox that is not in the database, the blank subform that pops up has the ClientID field filled out with what was typed in the main form.

2) Situation: Adding a new client to the main form, and filling out the additional in on the popup subform. I want there to be a field on the main form for "worker". The worker will put their ID and create a new client record. Is it possible to make it only possible for this worker to edit this client record in the future? ...the original creator will be the only one able to edit the information.

-I am thinking maybe have a table with all workers and associated passwords. So, if a user tries to open a subform created by another worker, he will be prompted to enter a password (which will be the one associated to the creator in this "secret" table.

View 5 Replies View Related

Tables :: Password Protect A Linked Table Or Make It Read Only

Nov 14, 2012

I have a table that I imported from another database. I used import Access - Link to the table source by creating a linked table. - then downloaded in my database.

I want to use the linked table to create relationships and forms but do not want to even accidently edit it. The table gets updated in the database on a weekly bases and I am hoping it gets updated automatically in my database as well. does it automatically get updated or do i have to set up something?

Also, I want to protect the data in that particular table and either password protect it or make it read only. Can I do that? If so, how?

View 4 Replies View Related

Code Triggered From Label On Click Behaves Differently From Command Button On Click

Nov 7, 2006

Often I use Labels as buttons due to the fact I can colour them the way I want, and use the on click event to trigger code.
The code below however works for a command button, but not a label button.

DoCmd.OpenForm "frmdatetime"
Do While Forms!frmdatetime!OKFlag.Caption = "False"
DoEvents
Loop

When this code is run by clicking on a command button, it works fine.
If run by clicking on a label, frmdatetime opens, but the mouse will not work on either of the 2 open forms unless you go down to the windows task bar, jump onto another window, and back onto frmdatetime.
If I remove the loop with the DoEvents in it, then the problem does not occur.

Can anyone enlighten me as to why this behaviour occurs.

Thanks

Richard

View 4 Replies View Related

Access 2010 - Delete Form Command Button With A Password To Confirm Delete

May 6, 2014

All I am trying to do is insert to have a form with a "Delete Record" button on it. The problem is I don't want anyone to be able to delete a record, I would like someone to have to insert a password to confirm the delete.

View 13 Replies View Related

Password On A Command Button?

Feb 11, 2004

Hi, i have a slight problem that i could really do with some help on.
I have a form in which u can edit/add or delete details of a record. What i would like to do is when someone presse's the delete button i would like a box to pop up asking for a password to be entered before the record is deleted just to prevent certain records from being deleted.

Thanks,

Ben

View 6 Replies View Related

Password On Command Button

Aug 2, 2006

On a "delete record" command button I want to put a password prompt so when you press it, it will only allow you to delete the record if a password is entered.

How?

View 3 Replies View Related

Control Date Value From Command Click

Jan 24, 2006

Dont be overwhelmed by the following, but it may require some extensive thought and I dont expect everyone to understand....

I want to have a unbound form control a subform. On the form I have an unbound text area entitled txtDate. In this area it displays the current date being viewed. I have put left and right buttons on the main form that will add (+1) one day to the date being shown and subtract (-1) one day from the date being shown. I want to conrol it though the "On Click" but I dont know what to enter in the "On Click" field that will allow me this. The reason is, co-insiding with the previous, when the date is changed, the subform is also changed to a new day. Therefore instead of displaying 24 hours of today, you can view 24 hours of yesterday, tomorrow and so on. See, if one is to set the onclick to be: Me.txtDate=Me.txtDate-1, or Me.txtDate=Me.txtDate+1, it calls for a custom macro and I dont know why. I know it somehow resides in some similar command set up.

I also need to know how to make the subform bound but continous, and what exactly does that mean?

Anyone care to offer some assistance? :confused:

View 4 Replies View Related

Help!Command Button Captions On Click

Aug 9, 2005

Hi all!

I have this command button whose caption switches from update record to save record with a msgbox verifying if the person really wants to take this action. On click the user is then allowed to update the record then in theory they would be able to hit the same button whose caption now reads save record, the msg box would appear with a yes or no answer required. The code I have is putting the msg box after the user clicks the update button.

Anyhelp and/or suggestions would be most appreciated!


Private Sub cmdOpen3_Click()

stDocName = "frmSearch"

If cmdOpen3.Caption = "&Update Record" Then
If IsNull(Me.FTMSubform.SourceObject) = False Then
Me.FTMSubform.SourceObject = "frmFTMInfo"

Me.FTMSubform.Form!txtFirstName.Enabled = True
Me.FTMSubform.Form!txtFirstName.Locked = False
Me.FTMSubform.Form!txtFirstName.BackStyle = 1
Me.cmdOpen3.Enabled = True
Me.cmdOpen3.Caption = "&Save Record"
Me.cmdOpen4.Enabled = False
Me.cmdOpen4.Caption = "&Update Record"
Else
Me.FTMSubform.Form!txtFirstName.Enabled = False
Me.FTMSubform.Form!txtFirstName.Locked = True
Me.FTMSubform.Form!txtFirstName.BackStyle = 0
Me.cmdOpen3.Enabled = False
Me.cmdOpen3.Caption = "&Save Record"
Me.cmdOpen4.Enabled = True
Me.cmdOpen4.Caption = "&Update Record"
End If
End If

If cmdOpen3.Caption = "&Save Record" Then
If IsNull(Me.FTMSubform.SourceObject) = False Then
Me.FTMSubform.SourceObject = "frmFTMInfo"
If MsgBox("Save update to this individual?", vbQuestion + vbYesNo, "Save Update?") = vbYes Then
DoCmd.Save
DoCmd.Close acForm, "frmFTM"
DoCmd.OpenForm stDocName
Else
MsgBox "Return to the FTMInfo Form!", vbInformation, "Save Function Aborted!"
End If
End If
End If
End Sub


~Van

View 2 Replies View Related

Double Click Listbox Command Won't Work!

Jun 27, 2005

Hi everyone!

First, I want to say I would REALLY appreciate any help I could get with this problem. Let me lay out the details.

I DO NOT, DO NOT, DO NOT know the first thing about programming for ms access. I am an absolute novice, no exaggeration at all. I was a liberal arts major in school!!!!!

Here's the thing: being adventurous and all, about 2 years ago a co-worker and I were fiddling with databases to try and help out our employer keep track of dispatching his equipment for his business. With a little too much time on our hands, before we knew it, our database became fairly complicated, for such novices. A kind gentleman on this forum did us an enormous favor, and programmed a search form for our database. you could enter any or all of the id #'s for various equipment, and it would pop up in a list box. Double-clicking the listbox would open the particular record you were looking for.

Fast-forwarding to now, I'm trying to create another database to keep track of our inventory while while various equipment moves in and out of our yard. I have tried using the old search form as a foundation to create a similar search form for this db. I think I actually have it (kind-of) working! You type in a container number, and the record should pop up. which is a miracle all its own.

problem is, is that when you doubleclick the selection in the list box, I receive the following error:

"Run-time error '3075':
Syntax error (missing operator) in query expression '[ShipID] = '.

I click debug, and visual basic brings me to:

DoCmd.OpenForm "Inventory Table Form",,, "[ShipID] = " & Me.lstInfo


I don't know what to do! I'm sure it must be something painfully simple or obvious, but I'm really stuck & would appreciate any help.

Also, I would really appreciate any advice on this: I'd like to also be able to search by chassis # in addition to container number, but i don't know how to do it. no big deal, though. THANKS SO MUCH!!

p.s., I've attached the db. please let me know if you can open it ok

View 1 Replies View Related







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