Search results

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

    Using DODCMD transfer

    I am trying to automate the exporting of several tables and queries. I have a button that you click that executes this code. I keep getting error messages. I was wondering if there is anything else wrong with my code. Micro_results_q is actually a query but I want it to export as a table. Can I...
  3. D

    After Insert Data MAcro, creating records in other tables

    I created an audit table for my database and I have been using the After Insert, After Update, After Delete Macros to create an audit trail in my audit_trail table. I created another Audit_Memo_fields table to track changes for my memo/ long text fields in my database. I can't get the macros to...
  4. D

    locking records issues

    Hello, I want to create a button that locks individual records in my database on the forms, so accidental edits don't happen. I used the code and followed the instructions from this website http://allenbrowne.com/ser-56.html. The code does work, but it either locks all the records or unlocks...
  5. D

    Data Macro keeps giving me error when I use forms to enter data

    I created a Data Macro with my backend table. I used the After Insert event for my New_Patients table, it triggers a new record to be created in my Patient_Status table. The two tables are linked. The Data Macro works great when I add new records directly in the New_Patients table, It will...
  6. D

    Front end db keeps crashing for 1 user only.

    I have a database that is split with a front end version and the backend. The backend is stored on a shared mapped network drive. 2 people use the database, generally at the same times during the day. Each person has there own version of the front end forms that they save and use from their...
  7. D

    Search boxes to with multiple criteria

    I have 2 textboxes txtkeywords and txtkeywords2 that I am want to use to do keyword searchs.I cant get the code to work. Private Sub cmdsearch_Click() Dim SQL As String SQL = "SELECT q_Qual_Cond.[Chron#], q_Qual_Cond.[Research_ID], q_Qual_Cond.[Qualifying_Condition] " _ & "FROM...
  8. D

    Use a dropdown box to display different queries?

    I want to be able to have a main form with a dropdown list Combo box. Then a subform container on the same form. I want the dropdown box to have selection where it shows all patients. Then selection for all patients with specific conditions, pneumothorax, pleural effusion. Then a selection...
  9. D

    How to hyperlink to other subforms on a tab control?

    I have a main form called Navigation_Form it has a tab control with 2 tabs on it. 1 tab Still_admitted_Form, then 2nd tab with New_PT_Main_Form The Still_Admitted page is a query that brings up a list of patients still at the hospital with their research_ID. The New_PT_Main_Form is a data...
  10. D

    How to add password automatically to exported excel file

    I created a form with a button that automatically exports several querys into an excel file with each query being 1 sheet in the excel file. I want to automatically have the excel file with a password. How to I add code that would do that? I would I integrate code that would do that into my...
  11. D

    Calculated fields, hours tracking dates

    Hello, I Have 4 fields with dates and times. Time field is in Military time. Fields: US_date, US_time, CXR_date, CXR_time. I want to create 3 calculated fields using those other fields to determine how many hours apart each of the date, times are. Calculated fields: 24hr_before, 24hr_after...
Top Bottom