Search results

  1. 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...
  2. 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...
  3. 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...
  4. 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