Search results

no the Primary Key of the List Box (ServiceID) from the another table (in dblclick on it , it runs an append query to append groups of details in the sub from.)

hiii all dears i have three forms , mainfrm , inside it OrdersSubFrm , inside it OrdDetSubFrm . i have a code to allert user if there are any changes , for any control in any form of this three forms. , after three days of the current date. i use this codes in the Form_BeforeUpdate event ...

it gives msg: Record not found. then go to the first record.

please give complete code. where put: Me.Parent.ListOne.Requery Forms![MainFormName]! [ListOne] = lngPK

Hiiii All I have a Form with Sub form , I add some data to sub form and then need to requery a listbox in Main form. i try : Dim lngPK As Long 'change data type if yours is different 'set variable to current record ID lngPK = Me.SerNo Me.Parent.ListOne.Requery 'Me.Requery 'return form to...

i have : a Single, Continuous and Datasheet View Forms. and suppose i have: a text box long data type and text box text data type , and a combobox of a number type and a text data type .

Hiii All i have a textbox , make format Like :@;"New Record" how to make its color red, only the word of New Record ? the default color for this record is black.

i have make an example with access 2007 , but not work . see to attachment.

Very Very Thanks I try the Second choice , it works good. Exit_Function: ' Label to resume after error. Exit Function ' Exit before error handler. Err_OldDts: ' Label to jump to on error.

Hiii All Dears I have read http://allenbrowne.com/ser-23a.html and try to do this in my db . this works good in forms and reports events.but i try to do in some special functions, but gives me "Compile error: label not defined " massage. please see my code: Public Function OldDts(SerAddDt...

Dear jdraw your Example is a good idea. but if user needs to show his changes dates for the current record in main form or in sub form ??

i try https://www.access-programmers.co.uk/forums/showpost.php?p=1530693&postcount=43 your Example.. sorry a refernce error. i add ms activex data object 2.8 library . and works good.

Thank you so much I want to make it easier for the user to observe changes .

thanks i try that but gives error (Db connection) i use Access 2007. if possible to give some changes in my example .

if bossible i want the code to return: (if the form contains subforms) The name of the form in which the changes or additions happend.

this is like i want , try to change code in subform to Parent.Audit_Trail Me

i some times need to use that code in Forms (that not contains Subforms ) , and if i have a form with sub forms i need to returns changes in the main form for all the main form and the subforms .

it gives error not in that function the error line is here: Private Sub Form_BeforeUpdate(Cancel As Integer) Parent.Audit_Trail Me End Sub

Very thanks Is there a method to change code to work with Main Forms and Sub Forms?

Ok Very thanks , i try that but gives error 2465