MS Access Question

[bdonelson]

Maybe it's the fact that I started with Access, but I seem to be missing the point.

Does anyone have a suggestion on how to get a query that functions as part of script?

Thanks,

[Lee Smith]

I feel like I came into the middle of a conversation here. Are you inquiring on how do perform a Find?

It is always better to tell us what you have now, and what you are trying to accomplish.

This could be as simple as a one word find, or more difficult as in setting up a relationship.

HTH

Lee

[Genx]

... you want to do a find as part of a script?

Enter Find Mode (pause if you want to allow the user to specify criteria)

Perform Find (you can specify your own criteria here if your not wanting to let the user specify it..)

alternativley you can also use the set field step between enter find mode and perform find to specify any more complex criteria you are wanting to match in a find...

but yes, please explain exactly what your trying to achieve..

[bdonelson]

I guess this more is more of a relationship question. I am attempting to use the filter results of a table in a script. The filter is based on the value of field.

[bdonelson]

Please explain this step

alternativley you can also [color:red]use the set field step between enter find mode and perform find to specify any more complex criteria you are wanting to match in a find...

I have been looking for a way to use the value of a field in the find, but just seem to be missing it.

Thanks,

[Genx]

... your going to have to be more specific by what you mean by using "the value of a field in the find"...

essentially... you could before entering find mode set a variable to any value you could possibly concieve in your wonderful imagination , anyway... something akin to the following script would work..

set variable (specify the variable name and any field / calculation / value you want it to be equal to)

enter find mode []

set field [any field; the variable you specified]

perform find[]

ps... to specify a local variable i.e. one to be used only in this script delimit it with as "$" i.e. $value and when doing the set field function just refer to it in the same manner i.e. $value

anyway be more specific with exactly what you want...

genx

[bdonelson]

This is exactly what I have been trying to do.

set variable (specify the variable name and any field / calculation / value you want it to be equal to)

enter find mode []

set field [any field; the variable you specified]

[color:red]perform find[]

How am I supposed to set the criteria for perform find[] from a field in the script? Does this, [color:green]set field [any field; the variable you specified], set that criteria?

[Wim Decorte]

Yes it does. Once you enter "find mode" you're not entering data into records with the set field, but you're entering find request criteria. Just like you would type in stuff in the Access query design thing.