Search results

I'm not sure if I saved the function in the right place. I haven't created my own functions before. I saved it in a module.

I'm trying to lock down my database so when admin user is logged in, only admin user has access to short cut menus. "Allowshortcutmenus" is this setting for right click shortcut menus? Im also trying to disable the special access keys for non admin accounts. I can't get it to work. I saw some...

A bound form.

Hello, Is there a easy way to set all the controls of a form to Null values on exit/ on close of form if form_completed checkbox is not checked. Can you do it without referencing every single control on a form? I always seem to mess up the syntax for form references with controls when I have...

I downloaded the file you posted and tried to do what you did with the VBA code and the query, and the form but I am getting a runtime error 457. "This key is already associated with an element of this collection" I have attached screenshot of the debug error. It highlights this section of the...

Hello, I am assigning random records for auditing to a team of people who updated the records. I have the file that shows what records everyone updated and who updated the record. I created a query (Generate_random) to assign a randomID number to each record that was updated. SELECT...

I haven't used web browser controls before, thanks, I will have to look into that.

So you probably wouldn't be able to do this for several different types of website. Each website can use different names for the userid and password controls?

Hello, I have an access database with Logins table and with fields: UserID, Password, WebAddress. I have a form (Auto_Logins) that displays these 3 text fields, and buttons to scroll through all the individual records in my Logins tables. Then I have a Login button that I want to trigger...

I tried to go to references by ut was greyed out and wouldn't let me open it. I have attached a screenshot of my code with the error message.

I am trying to use this code in my database and I keep getting error message "Compile Error: User- defined type is not defined" when I run the module. Then it highlights the code db As DAO.Database. I'm still a VBA beginner so I don't know if there is something else I need to do with the code to...

I was searching google and I found a solution. I tested it and it works now. It kind of makes my user login page not needed anymore though. It gets the userID directly from my computer Login instead. I found this utube video and did what it said. I created a function added it in my backend and...

I tried Set Field Name: Audit_trail.ChangeBy Value = [Forms]![User_login]![cbo_user] I tried Value =Forms!User_login!cbo_user, that didn't work either. It still didn't work. The Login form is on my front end though. Can the data macros take values from forms that are on the frontend

I will try!

Hello, I created a Audit table to track all changes made to my database. I got the audit table to track my changes , but I am trying to track which users make the changes also. I used this website to set up my audit table followed the directions...

Its working now. I had to make the Value = [US_ID_var], I thought it was that but when I changed it to LocalVars![US_ID_var] it didn't work. Then I changed it back to Value = [US_ID_var] and then it worked, not sure what was happening. Thanks for your help.

I am trying to use the SetLocalVar but it doesn't seem to be working. This is within AfterInsert data macro for my US_Demographics table SetLocalVar Name US_ID_Var Expression = [US_Demographics].[US_ID_FK] Create a Record in Audit_trail SetField Name Audit_trail.TableName Value =...

I just made all the data/ tables I wanted to export into querys, and that works to export the data as a copy and not a just a link. But it creates another problem. I have a couple long text fields in some of my tables that are also formatted as Rich text fields. So I can make text bold and...

I see that I can select the linked tables and right click, then convert to local table. That works but I wanted everything to be automatic. I will be having someone else doing this.

Ok, thanks I just tried that and now the querys are exporting properly. They have all the data in them and they are a copy, not a link. I just need to figure out how to get the tables to be an actual copy and not a link.