searching from the switchboard

[kerie]

i have put a song database together (access 2002) with a swithboard to use when i run karaoke nights.

my question is, i have a search button on the switchboard where i can search for name or artist, which works by entering the entire song name or artist but i cannot figure out how i can search for part of a field.

i know how to do it in a normal query (using the LIKE command) but it doesnt work when i try it in the switchboard

many thanks in advance

 

[Vassago]

Okay, I would LOVE to see your database, can you post a copy here or would you be willing to send me a copy because this is exactly a project I have been working on.

There have been many samples posted ont he forum in the past on how to do a search on part of a keyword. What code are you currently trying to use? I'd be happy to take a look at it.

 

[kerie]

re: search

i have now got the search working corectly (thanks to the members on this wonderful site) i got one problem left then i'll post a sample for you to see

 

[Vassago]

I am looking forward to it. It sounds like you have it interacting nicely with winamp too. That would be awesome!

 

[Vassago]

Are you going to post a sample? (Hopeful)

 

[Tezcatlipoca]

Yes, please post a sample as this is the kind of thing I'm also looking for (Also-hopeful-but-probably-not-as-much-as-Vassago!)