Recent content by Db-why-not

  1. D

    How to run vba for another databse

    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.
  2. D

    How to run vba for another databse

    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...
  3. D

    Audit trail, tracking user changes with data macro and USer login from form?

    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...
  4. D

    Audit trail, tracking user changes with data macro and USer login from form?

    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
  5. D

    Audit trail, tracking user changes with data macro and USer login from form?

    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...
  6. D

    After Insert Data MAcro, creating records in other tables

    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.
  7. D

    After Insert Data MAcro, creating records in other tables

    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 =...
  8. D

    Using DODCMD transfer

    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...
  9. D

    Using DODCMD transfer

    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.
  10. D

    Using DODCMD transfer

    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.
  11. D

    Using DODCMD transfer

    Here is the full code I have right now. The tables with (last 5) q at the end are querys. strPath = "M:\Research\Lung Us\Data\Exporting_OHSU\OHSU.accdb" DoCmd.TransferDatabase acExport, "Microsoft Access", strPath, acTable, "Admission_DX", "Admission_DX", True DoCmd.TransferDatabase acExport...
  12. D

    Using DODCMD transfer

    I end up with a Access database that has linked tables. (I need a copy of the tables, not links) Then the querys that I exported show up as empty tables, but actually in the table, not linked.
  13. D

    Using DODCMD transfer

    There was an issue with how the drive was mapped. I fixed it. Also the file extension wasn't correct and I fixed it. But now there is a different issue. It's not exporting the tables it only exporting the link. I'm trying to create a copy of part of the database so I can send it to someone not...
  14. D

    Using DODCMD transfer

    I might try moving the access file that I'm exporting to somewhere on my desktop
Top Bottom