Search results

Hi Kevin Thanx for your reply again m8. Please excuse my ignorance. Although I haven't created a new MDB on my desktop, I understand the risks with my unsecured database. I will now start to look at security (whilst saving a backup) and hopefully explore this complexed area. Thanx again m8.

G Hudson, Your example of shift disable is absolute ace. I have managed to convert my database to an mde and disabled shift etc and I am quite excited that nobody can get into my data such as tables, forms etc. The next step is to look at the security side of things, although I am a bit...

-------------------------------------------------------------------------- If [YourTextBox] = "YourPassword1" Then DoCmd.OpenForm "YourFormName1", acNormal ElseIf [YourTextBox] = "YourPassword2" Then DoCmd.OpenForm "YourFormName2", acNormal ElseIf [YourTextBox] = "YourPassword3" Then...

-------------------------------------------------------------------------- If Me.[YourTextBox] = "YourPassword" Then DoCmd.OpenForm "YourFormName", acNormal Else MsgBox "Incorrect Password!" & vbCrLf & vbLf & "You are not allowed access to the ''Special Form''.", vbCritical, "Invalid...

hi, I had the same problem in one of my forms, but when I allowed add record in the properties, the form was showing. Try enabling allow additions in the form's properties. Hope that helps

thanx Ghudson, It's ok m8, I am not going to goto that bother. I will just tell them thatthey need to ensure nobody's watching over the sys whilst accessing sensitive data. kind regards m8

Hi Mile, I'd just like to say a big thank you for your password button (on-click) code. I have manage to incorporate it into my own database which is still currently under construction. Can I ask, I noticed that when typing in the password, anyone else watching the screen at that time could...