Search results

Details: I have a New User form that I inherited. The form adds a new user to the Users table. It works perfectly, but I want to set up validation rules for the form that require First Name, Last Name and Username to be entered BEFORE the Users table is updated. (The password field is set by...

Re: [Solution] Security Warning Issues Ok, here is how I solved my problem with the Security Warnings issue using the Access 2010 version. Make the database a trusted file Make a backup of your database Go to Start|Microsoft Office|Microsoft Office 2010 Tools|Digital Certificate for VBA...

Hey Gina, I am having a similar problem. I don't want my users to think there is a problem with the Database security by leaving the message visible and requiring them to click ok. I want the Security message to be removed and I would like to know how write a .REG file. Could you give me an...

Thank you for your last suggestion, but it didn't work. It's almost as if the code isn't being recognized. Here is what I have: If User.AccessID <> 1 Then Call DisableProperties End If

I'm wondering if I should just accept the multiple logins problem and just create an ACCDE file with all menus permanently disabled for my database users. Then I would be free to work on the original ACCDB file and make changes as necessary, leaving me the option of creating new ACCDE's, as...

After much research, I made a backup of the database and split it. Then I activated (uncommented) the code that calls for the Disable/Enable functions. I am still having to log in multiple times to see the menus lock and unlock. Thanks for the helpful articles, by the way. Any new thoughts...

Thank you for your help! I will look into this and see if it solves the problem.

Also, I work in a non-IT department, so I'm not sure how that would affect where the "back end/front end" would be stored.

I assume that you mean that the database is not split? If so, then yes I am sharing a Front End. I am not familiar with splitting databases and am not certain how that would affect my ability to develop the database further.

I was the user that posted the question about Enable properties not working on that other site before I realized it would take several logins to make the function work. This problem was not solved in that thread most recent thread on Link: iaccessworld . com / how-to-disable-properties / What...

I tried Me.AccessID, but it doesn't work. Here is the link, but I do not have enough posts for it to be active. I copied the code exactly like it is listed on this link. I just chose not to the use the password protection offered because I have my own password management system for that. Link...

I found where User is defined. Here is what I found in one of the modules of VBA code: Public Type UserInfo ViewID As Integer AccessID As Integer Active As Boolean Password As String UserID As String SecurityID As String End Type Public User As UserInfo

To be honest, I borrowed this code from another post on this forum and tweaked it for my needs. I changed the names of tables and updated the code to match. I don't know what User is, but User.AccessID = 1 works for controlling access to one of the other buttons on one of my forms, so I haven't...

The following code:User.AccessID <> 1 is the test that I want to run for each user that logs into the database. If the user's AcessID is not equal to 1 (i.e. not an administrator) then VBA should call DisableProperties. If the User's AccessID is equal to 1, then VBA should call EnableProperties.

Thanks, but that doesn't fix the problem. I did try it, but that made it worse. Now I can't get back into the program to make changes at all because the condition I set for the login type isn't met before the function is called. Fortunately, I made a backup of the file before I moved the code...

Details: I found some code for the main menu of my form online through a post on this very forum that allows me to disable almost all menu properties/bypass keys, etc. in Access. Here is the link: iaccessworld . com / how-to-disable-properties I have included the code below. There are three...

SOLVED (for now) I scrapped the combo box and started the wizard again. Then, I set the SSN as the first column, (which is the primary key) allowed it to be hidden and the combo seems to work fine.

I have an unbound combo box that I set up in a form using the combo box wizard in Access 2010. I selected the option that says, “Find a record on my form based on the value I selected in my combo box.” The problem is that the combo box will not always display the correct record. It seems to only...

Is there a way to merge duplicate/similar Access 2010 records into one record? I have researched this question numerous times and have not found an answer specific to my needs. I have an Access table with 1,000 duplicate records, although they are similar and not exact duplicates. As you can...