Recent content by filfil

it is fixed. there was a control that is related to another table, and this was causing the problem.

Hi, I'm using the audit trail. it was working fine until I added more fields in the sql db that is connected to my MS Access db. the new fields are not tracked by audit trail! I have no idea why is that!.. sometimes I get the following error when trying to save changes done in the current...

summary here is the summary of it: 1st: use the following code to create a new module, call it (dAuditTrail): Option Compare Database Option Explicit Public Function Audit_Trail() On Error GoTo Err_Audit_Trail 'ACC2000: How to Create an Audit Trail of Record Changes in a Form...

I'm not sure if someone post such solution, but here how I got my two levels forms Audit Trail working: I used ghudson's Audit Trail + the changes offered by Lyn Mac in page 1, and hooi's hint in page 3, In the main form, i used to get "Operation is not supported for this type of object."...

thanks a lot Jon K.. I also found the sample very helpful for my case.

sorry, it's solved :).. may i should try more before posting! Private Sub cmd_view_Click() Dim stDocName As String 'Dim stLinkCriteria As String 'Dim rst As String Dim rst As DAO.Recordset 'Dim rst As Object Dim strCriteria As String If IsNull(Me.contMonth_view) And Not...

ok, i'm using this code now, but it gives me "error: invalid qualifier" on line: Set rst = stDocName.RecordsetClone Private Sub cmd_view_Click() Dim stDocName As String 'Dim stLinkCriteria As String 'Dim rst As String Dim rst As DAO.Recordset Dim strCriteria As String If...

thanks, i'll do so

I'm using this code: DoCmd.OpenForm stDocName, , , "Contract_No = '" & Me.Contract_No & "' and Cont_Month=#" & Me.contMonth_view & "#" to return the record according to the matched Contract_No & Cont_Month (Date).. it does return the record, but only that record.. what i want is to return...

hi all, I need to create a program in access database, the main form contains 3 subforms. for each month 'Monthly Progress Report for:', the user enters some details in the main form and the subs. these details should be retrieved (when the user tries to add a new record and enters a new...

thanks a lot ^^ sorry forgot to tell that the fields contain Arabic characters.. i tried a few minutes ago with the English characters and it worked fine.., may be i have to do some changes in the sql table according to: http://msdn2.microsoft.com/en-us/library/aa902664(SQL.80).aspx your help...

hi all, how are you? this is my first post ^_^ I have a problem with my search form. it was working fine before i connected the access database with the sql server. the code now gets the filtering details and filter the records according to the search criteria only if number and date fields...