I'm pretty sure Access is going to be the death of me today.
This is what I have...a query that pops up and ask for student's last name and then provides the requested information when one enters a last name of Smith.
Problem...instructor mistypes student's last name and finds zero results. They typed in Smyth.
Fix...(besides just typing in the name correctly)....A query that uses a soundex search.
I started here, http://www.access-programmers.co.uk/...d.php?t=173710, and downloaded the file and read through the instructions. I can't get it to work...but then again, I'm pretty new to this and maybe I'm missing some important steps. I've read this, http://msdn.microsoft.com/en-us/libr...(v=vs.60).aspx, and what I'm reading makes sense...but for the life of me I don't know where to start.
Is there a step by step process or a very basic example somewhere? I know soundex in general is more advanced, but with decent instructions I can do pretty much anything.
I've been in Access way too much the last couple of weeks and if I see one more compile error or anything else that tells me something I did isn't working...I might cry. Thank you!