OK thanks a lot.
Appreciate your time.
zareh
Last Activity: Mar 10 '14, 02:37 AM
Joined: Feb 26 '14
Location:
-
In the FindNext there is no parameter to pass. I looked at the VB help.
''''''''''''''' ''''''''
FindNext Method
See AlsoApplies ToExampleSpecif icsThe FindNext method carries out the FindNext action in Visual Basic.
expression.Find Next
expression Required. An expression that returns a DoCmd object.
Remarks
This method has no arguments and can be called using the syntax DoCmd.FindNext....Leave a comment:
-
FindNext() does not work at all. It does NOTHING, no finding no error.
May be the parameters are not correct. I used exactly :
DoCmd.FindNext( )Leave a comment:
-
Thanks a lot.
I tried but the result is the same.Leave a comment:
-
Command3_click opens the Search form.
At the bottom of the codes you can see another sub which is for FindNext button. Private Sub FindNext_Click( )Leave a comment:
-
Thanks a lot, Here is the complete codes:
...Code:'This is on the click event of a command button on the main form which opens the search form. Private Sub Command3_Click() Dim a As Control Dim b As Form Set a = Screen.PreviousControl Set b = Screen.ActiveForm e = a.Name 'last control name d = b.Name ' last form name On Error GoTo Err_Command3_Click
Leave a comment:
-
Thanks for the reply.
This is not a macro.
In the Find Next button I have :
This part makes me really mad : (I said before)Code:Forms(d).Controls(e).SetFocus searchitem = Text0 DoCmd.FindRecord searchitem, acStart, False, acSearchAll, False, acCurrent, False
when I press Debug on this error msg box, program stops and when I press F5 it finds the search...Leave a comment:
-
Thanks for the reply.
On the main form I have a command button which opens the search form. In the search form I have a text box which is for the search item input and two command buttons. One is for "Find First" and the other is for "Find Next". When search item is entered and "Find First" is clicked, fist occurrences of the search item is found without problem, but when Find Next is clicked, an error msg appears...Leave a comment:
-
Actually I made some progress since I posted this question here.
BUT not 100%.
The codes are little bit long, NOT actually long but in many places.
My main problem is to refer to the
* main form
* sub form
* and field name which had the focus
BY variable name. Because this search must work for every form the user opens. When these items are known then I have to use the followings:...Leave a comment:
-
Can Anybody help me to create "Find" Window in access
I need to create a process exactly like Access Find window which can search anything anywhere.
e.g. A form contains one or two sub forms which show some data. The user can select one of the fields on the sub forms and clicks a button. A new form opens and asks the search item. When the search item in entered , it should find the item in the sub form selected.
I did this with the search item on the same form and it works fine. BUT...
No activity results to display
Leave a comment: