Hi
I want to protect an MS Access 2007 database I have created so that users cannot use anything other than the forms I have put in place. I have been able to create a login page which requires they use a password to get to the sub forms, so from that point of view I am happy.
What I have noticed however, is that I can use the built in options to hide the navigation pane and menus, but actually they're quite easy to...
jimrand
Last Activity: Mar 14 '08, 04:45 PM
Joined: Feb 12 '08
Location:
-
Protect MS Access Database
-
Ignore me, I was being thick!! Have solved it - I had forced my password box to be referenced to the underlying table, so no wonder it kept deleting it. -
I am trying to use this piece of code in my own database, but I am a bit confused!! The code runs fine, but the login form I have created automatically defaults to a user name and displays the password (masked with ****). How do I get it so that the form opens blank and allows users to enter their names and passwords each time?
If I then delete the pre entered data, it deletes it from the undelying table tblUsers.
Sorry...Leave a comment:
-
No worries, I think it was much more me misleading you by trying to use code (in the first post) that was clearly not understood by me!!!
Anyway, thanks for trying to help despite me confusing the heck out of it!!...Leave a comment:
-
That's what I wanted - thanks!! Realise it's crude, but it does what I need....Leave a comment:
-
Right, I already have my form created and I am attempting to use it as both a form to display data, but also to allow input. Would I be better to use one form to display the data that is locked and have a second form for input that is only displayed when the users select the "New Record" button?
I have only been doing this for a short space of time and as you can probably guess I am having to learn as I go along!!
...Leave a comment:
-
Ok, thanks. How do I get the button to open a pop up form for them to enter a new record?Leave a comment:
-
Create New Blank Record In a Form
Hi
Using Access 2007, I have a form created that uses a combo box to select records from an underlying table. I want the user to be able to create a new record with absolutely no pre-set data in it to allow them to key in the new data themselves. I am really stuck as to how to do this.
I have added a cmd button to the form and have tried using the following code that I picked up from here:
...Code:Private Sub
-
MTB - thanks, it works perfectly and stops my head hurting!!!...Leave a comment:
-
Count Imported Rows From Excel Spreadsheet
Hi
I am using Access 2007. How can I display to a user in a message box how many rows were imported when they click an import command button from a form?
This is my code to produce the import and the message I am currently displaying:
...Code:Private Sub ImportLatestSaleData_Click() DoCmd.TransferSpreadsheet acImport, , "ThisSale", "S:\Accounts\Jim\Fleet\Disposals\BCA\ThisSale.xls",
No activity results to display
Leave a comment: