Search results

Very thanks , this is what i want exactly .

Please try to change data in any field or enter new records in the continuous form ( frmEmploeeList or in subform ) , then go to a new record and you will notice the error message that will appear.

See to the attachment

If i use single form there no problem . The problem only in continuous form ( if it was main or sub form )

OrderID is a bound control on that subform , it is a long datatype .

On the form_beforeupdate event , when calling the function : Sub form_beforeupdate(cancel as integer) Call Audit_Trail(me, "OrderID", OrderID.value, True) End sub

Hi all When i am using this code for audit , i want to get the text on the label related to the controls ( not control name ) , it works good on the single forms , but gives error 2467 when using it on continuous forms . Option Compare Database Option Explicit Public Function...

Hi all I have a form to use for search . Because there a hundreds of thousands of records , i prefer to use a listbox than a continous form . How to use that as like the code that provided by allen browne: http://allenbrowne.com/ser-62.html

Sorry The error in the line: If InStr(ctl.Controls(0).Caption, "*") > 0 Then

Can any one try to use this code on any single form then on a Continuous form to see the error ?

DoCmd.GoToControl ctl.Name

I use this code but gives me error 2467 Private Sub Form_BeforeUpdate(Cancel As Integer) ' perform data validation Dim ctl As Control For Each ctl In Me If ctl.ControlType = acTextBox Or ctl.ControlType = acComboBox Then If InStr(ctl.Controls(0).Caption, "*") > 0 Then...

I try to get the controls that have a label caption text that contains "*" as : Dim ctl as control For each ctl in me.form If ctl.type=acTextbox or ctl.type=acCombobox then If ctl &""="" then If ctl.controls(0).caption like "*"&"*"&"*" Msg ctl.controls(0).caption End if End if End if Next...

Very thanks another time . How to refere to the control's caption that contains mark of ( * ) , example : - txtOrderID *: - txtOrderDate *: - cboCompanyNm *: - cboEmployeeNm*: - txtWriter*: How to do the code to loop through the controls that is ( null ) and their label caption text...

Very thanks for all

How to get caption text of linked labels for every control on a form I have a form based on a table with this textboxes and combo boxes : - txtOrderID its linked label caption : Order Number - txtOrderDate: its linked label caption : Visit Date - cboCompanyNm : its linked label caption ...

i want to go to unlimited generations . please help how to use code with my db.

it is not important to store mothers data . if there more than 10 generations in table how to get all the names of grandfathers for a person ?

hiii all dears i search for best way to build a family tree database , the best way that i found as in http://allenbrowne.com/ser-06.html is by using one table only , i have design a table " tblPersonsData" with 4 fields : -PersonID : Primary key -FatherID -PersonName -PersonBirhDate...

Very thanks It works good. It solved thanks ..for mr. Mark_ , post #4 , please re - explain step by step .