Recent content by sun_after_rain

Is there any way to lock the fields? I don't want to protect the fields from being changed.

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

Thanks!~ You're awesome..I checked again and pinpoint the problem. All fixed1

I performed the check your recommended. new record= false. it's not reading it as a new record that is why I don't get a "insert" in my audit table. How do I fix the problem?

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

Thank you for the reply! It worked!

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

I have the same problem with Insert! Everytime I insert a new record the "audtype" is Edit To..What is the line of code you left out?

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

do the dates need to be in a certain format?

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