Search results

  1. S

    Protect Audit Table

    Hello! I have an audit table. Does anyone have any suggestions on how to protect the table from being tampered with? Thanks!
  2. S

    Export Query to Excel with Flexible Fields and Format

    Hi! I am a beginner programmer. What I need to do is export a query into excel. I want the user to have the flexiblility to choose the desired fields to export. Also, I need the excel sheet to be formatted with bolded headers, calibri 10 pt font, and autofit columns. Would some help? My...
  3. S

    Allen Brown's audit log code "insert" problem

    I am using Allen Brown's audit log. However whenever I add a record, it logs as "EditTo" vs. "Insert" in my audType column. Everything else works fine. Please help! here is my code: Option Compare Database ' Purpose: Audit trail, to track Deletes, Edits, and Inserts. ' Does not...
  4. S

    Export Query to Excel

    Hello! I am trying to export specific fields in my search query to excel. My code isn't working: I keep getting "Compile Error: Sub or Function Not Defined" What is wrong? Private Sub Exportexcel_Click() Dim strSQL As String Dim qdf As DAO.QueryDef strName = GetUserName() strXLFile =...
  5. S

    date range query

    I am trying to extract records that fall within a certain date range.The date field is in the format mm/dd/yyyy. Here's the tricky part: The records also have data ranges. For example: Movie A has a start_date of 4/1/2005 and end_date of 3/31/2013. The user can search on start date and/or...
Back
Top Bottom