customize find record

[Ivana]

Hi,

I would like to create something similar to the find record, but customize
it so it searches all records in the form and the options are always set to:
find any part of fild, search all, without an option that allow changes for
the criteria. Also, if this could be made separated from the form, as a new
form or smth.

Thanks for your help,

Ivana

 

[Roo]

You can do something like this behind a button on_click event:

DoCmd.FindRecord, [set parameters here]
you should see what parameters you can set after you put the first comma in.

 

[Ivana]

Hey thanks for your response, it seems to be it, but I probably wrote it
wrongly. When I click the button it says: Run-time error '2465'

Telephone directory can't find the field '/' referred to in your expression.
(The / is acctualy a horizontal line).

This is what I wrote:

Private Sub Command0_Click()
DoCmd.FindRecord [,acAnywhere, , acSearchAll, , acAll]

End Sub


Any ideas?

Thanks a lot

You can do something like this behind a button on_click event:

DoCmd.FindRecord, [set parameters here]
you should see what parameters you can set after you put the first comma in.

Hi,

I would like to create something similar to the find record, but customize
it so it searches all records in the form and the options are always set to:
find any part of fild, search all, without an option that allow changes for
the criteria. Also, if this could be made separated from the form, as a new
form or smth.

Thanks for your help,

Ivana

 

[Roo]

Looking at this further, I think this way of doing it actually requires an
expression or value for what to search for, so it might not be suitable for
your needs afterall.
Did you get the find record dialog box to actually appear ?

Hey thanks for your response, it seems to be it, but I probably wrote it
wrongly. When I click the button it says: Run-time error '2465'

Telephone directory can't find the field '/' referred to in your expression.
(The / is acctualy a horizontal line).

This is what I wrote:

Private Sub Command0_Click()
DoCmd.FindRecord [,acAnywhere, , acSearchAll, , acAll]

End Sub


Any ideas?

Thanks a lot

You can do something like this behind a button on_click event:

DoCmd.FindRecord, [set parameters here]
you should see what parameters you can set after you put the first comma in.

Hi,

I would like to create something similar to the find record, but customize
it so it searches all records in the form and the options are always set to:
find any part of fild, search all, without an option that allow changes for
the criteria. Also, if this could be made separated from the form, as a new
form or smth.

Thanks for your help,

Ivana