Recent content by GoodNamesTaken

Lagbolt, thanks for the thorough response. Something else came up at work, preventing me from putting any effort into this for the time being. I'll be sure to check back in a week or two when it dies down. Thanks again for the awesome reply, cleared it right up! Have a good'n

Thanks for the link, very helpful background. My only reason for not wanting to use a combo box is that it could only display one record, and I'd like the user to be able to see all results that are similar to what they're typing. Thanks for the suggestion! If it comes down to it, I'll...

Just thought I would add a link to the source that I originally learned regexp's from. The tutorial is written specific to perl, but regexp's should be pretty language unspecific so the theory should be transferable. http://perldoc.perl.org/perlrequick.html...

I saw the post on live search, but the files are not in 2000 compatible format. Hooray :( I know I'm starting with the on change event. I dont quite follow you on using the .Text or .Value property though. I know it's probably pretty basic, but I dont know what element or level you're...

They're a means of matching patterns in strings. I looked into it and VB does support the use of regular expressions. I'm afraid I don't have enough VB experience to give you much beyond these links - http://en.wikipedia.org/wiki/Regular_expression http://www.regular-expressions.info/vb.html

Beyond what was already suggested, you might consider looking into regular expressions. If you can make the pattern matching specific enough, in theory it should do just what you're looking for.

Awesome! So glad it's possible. Though my SQL background is very strong I lack experience in Access to put it to good use. I'm assuming there will be some VB involved, which I'm also pretty shaky at. If there are any tutorials or relevant resources to building this, I'm happy to do the lions...

While I'm not expert it sounds like you might be looking for a subform bound by a field on the main form. Hope this helps.

Forgive me if this has already been covered, I couldn't find anything with the search terms I could think of. I'm trying to create a picklist that updates based upon what a user types. I've seen this done in other databases, but have not encountered it in my limited Access experience. My...