I want to search for a record...

[Ruth]

Help!

I'm designing a form that will open on entry to my database.

The form will contain command buttons to direct the user to where they want
to go.

The one command button I want to click on and take me to a form (which we
use in datasheet view) and bring the find record box up. I want to set the
find record box to search the whole form (not just one field), I want it to
match any part of the field, and I don't want the case to match.

I've battled with the FindRecord Macro Action - and then RunCommand Macro
Action for the Action Argument Find.

How on earth do I achieve this???????!

 

[ND Pard]

Although it doesn't provide an entire solution, it is a start:

In Design View of your form, Right-Click on the command button, and Open the
Properties sheet.

Click on the Event Tab.

In the On Click event enter: [Event Procedure] and then click the " ... "

This opens the VBA Editor and enters code snippets for the command click
event.

Between the snippets enter:

DoCmd.OpenForm "YourFormName",acFormDS
Docmd.RundCommand acCmdFind

The above code should open the desired form and open the Find and Replace
dialog box.

Save the form and in Form View click on your command button.

I hope this gives you a good start.

Good Luck.

 

[Ruth]

Yes well I'd sort of worked out I could get that far by adding Actions to the
macro which is attached to the command button. It's a shame that you can't
record macros like you can in Excel and Word, but hey ho I guess that's life!
Thanks for your suggestion anyway.

Although it doesn't provide an entire solution, it is a start:

In Design View of your form, Right-Click on the command button, and Open the
Properties sheet.

Click on the Event Tab.

In the On Click event enter: [Event Procedure] and then click the " ... "

This opens the VBA Editor and enters code snippets for the command click
event.

Between the snippets enter:

DoCmd.OpenForm "YourFormName",acFormDS
Docmd.RundCommand acCmdFind

The above code should open the desired form and open the Find and Replace
dialog box.

Save the form and in Form View click on your command button.

I hope this gives you a good start.

Good Luck.

Help!

I'm designing a form that will open on entry to my database.

The form will contain command buttons to direct the user to where they want
to go.

The one command button I want to click on and take me to a form (which we
use in datasheet view) and bring the find record box up. I want to set the
find record box to search the whole form (not just one field), I want it to
match any part of the field, and I don't want the case to match.

I've battled with the FindRecord Macro Action - and then RunCommand Macro
Action for the Action Argument Find.

How on earth do I achieve this???????!