Recent content by RbTrail

  1. R

    Audit Trail subroutine works for Forms, but not SubForms

    Thank you! That works wonderfully. For those who are interested, here is the corrected code: Option Compare Database 'from Martin Green's Access Tips at http://www.fontstuff.com/access/acctut21.htm 'changes by theDBguy highlighted in red Sub AuditChanges(IDField As String, UserAction As String)...
  2. R

    Audit Trail subroutine works for Forms, but not SubForms

    The following code works wonderfully for all of my simple forms, but nothing is recorded in tblAuditTrail if an edit is made in a subform. I've tried calling the sub from the subform's events, but it still doesn't work. I suspect the problem is in "![FormName]=Screen.ActiveForm.Name", but I...
  3. R

    How do I concatenate a field from multiple records?

    I found the error in my SQL statement. I forgot to reference the INNER JOIN in the FROM part of the SimpleCSV(). This is the corrected SQL: SELECT DISTINCT tblEmployee.EmpID, SimpleCSV("SELECT DeptName FROM tblDepartment INNER JOIN tblEmpDept ON tblDepartment.DeptID = tblEmpDept.DeptID WHERE...
  4. R

    How do I concatenate a field from multiple records?

    Thank you both! I knew it had to be simple.
  5. R

    How do I concatenate a field from multiple records?

    I am attempting to create a query that contains a field that lists the employee departments. The goal is to use this query in report headers, ie: EMPLOYEE: 1111 DEPARTMENT: A, B, C detail, detail, detail, etc I've concatenated the Employee names before, but I'm not sure how that works when...
  6. R

    How can I update one subform with information from another subform?

    Pat Hartman, I understand why you would say not to delete employee records, etc. But this is not connected to our main Employee DB. I work at a sub-company who shares an HR Dept. with the main company. We don't have access to their records, but we are required to keep track of our own training...
  7. R

    How can I update one subform with information from another subform?

    Nevermind! I figured it out. But I'd still like to know if you have a recommendation for a beginner to start learning the basics of coding.
  8. R

    How can I update one subform with information from another subform?

    Thank you so much for all of this! Last questions: Where do I enter the code? Under the Event Procedures on the Property Sheet of the subform? Or do I use Create Module on the ribbon? What resource do you recommend for learning code, for a greenie like me?
  9. R

    How can I update one subform with information from another subform?

    Okay, I entered the following: Private Sub Form_AfterUpdate() 'CompsTrainingDB stripped'.Execute Append_tblEmpPro ' alerts not triggered End Sub There are no alerts, but it doesn't update tblEmpPro. I should also mention that I've never worked with code before. I've been using the macro...
  10. R

    How can I update one subform with information from another subform?

    MajP: Thank you! This works perfectly. How do I stop the warning messages that happen when the action queries run?
  11. R

    How can I update one subform with information from another subform?

    RanMan256: Thank you, but the way my tables are related makes a simple update query useless.
  12. R

    How can I update one subform with information from another subform?

    The purpose of my database is to track employee training. Each employee can work in multiple departments, and each department has multiple procedures. These procedures often overlap various departments, but there is no 'common core' of procedures that everyone is required to take. I have my...
  13. R

    Hello, I've been thrown into the deep end. How are you?

    Thank you Minty, Mark, and The_Doc_Man! I look forward to reading more in the forums. I'll be asking specific questions as soon as I figure out how to phrase them.
  14. R

    Hello, I've been thrown into the deep end. How are you?

    I've been a QC Coordinator for a little over a month. Most of the work is in Excel, but I have now been asked to rebuild a Training DB that was corrupted beyond salvation. (Mostly because no one managed it, but everyone kept messing with it.) I know the basics of Access, so I've been able to...
Top Bottom