Query/Search

[abc]

Is there a way for the user to search for a TITLE by typing a couple of
characters.. and it will populate all the titles including those
characters?

 

[Scott L. Heim [MSFT]]

Hi,

May I get a little more information? For instance, are you referring to
typing in a drop-down list box and then having the drop-down list box
populate with those items or typing in a text box and then populating a
drop-down or lastly, typing in a text box and have all the data returned to
the form?

In short, I just want to get a better handle on what you are trying to
accomplish.

Thanks!

Scott L. Heim
Microsoft Developer Support

This posting is provided "AS IS" with no warranties, and confers no rights.

 

[abc]

Sorry for not clarifying...

I have a textbox where the user will type in and when they press
"search"... any words that match what they type in will populate into a
textbox (repeating).

For example:

*Database has the following titles*
Title: Return Demonstration
Title: Team Interventions
Title: Prevention, Intervention, & Postvention
Title: Mock Survey

 

[Scott L. Heim [MSFT]]

Hi,

Basically what you are asking about is the ability to query using
wildcards. This is possible and we have a Knowledge Base article that
describes this:

826992: How To: Use Wildcard Characters in an InfoPath Form Query
http://support.microsoft.com/default.aspx?scid=kb;EN-US;826992

I hope this helps!

Scott L. Heim
Microsoft Developer Support

This posting is provided "AS IS" with no warranties, and confers no rights.

 

[abc]

THANKS!

 

[abc]

When it says to:

"Make the following changes:· Change the Action of the button to
Script.
· Make the Label type Run Query.
· Make the Script ID value MyQuery.
Click Microsoft Script Editor to apply the changes and to display
Script Editor."

I am running sp1... how do i make my script id value MyQuery?

 

[Scott L. Heim [MSFT]]

Hi,

Right-click on the button, choose Properties and change the ID.

Scott L. Heim
Microsoft Developer Support

This posting is provided "AS IS" with no warranties, and confers no rights.