424,279 Members | 1,907 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,279 IT Pros & Developers. It's quick & easy.

Regular Expressions with Access

Breezwell Fab
P: 2
Hi Everyone

I am curious to know if there is some good literature or tutorials focusing on leveraging regular expressions in Access.

I am interested in providing users with the ability to search free text (or records from a database table) and simply highlight keywords and various text patterns to get started.

Thanks
Oct 1 '10 #1
Share this Question
Share on Google+
3 Replies


nico5038
Expert 2.5K+
P: 3,072
It's not possible to highlight words in text fields. Only a .rtf field can be used for that.

I would start with showing the users the right-click pop-up possibilities to filter and sort and when you're able to code in VBA you can use the me.filter property to store and/or manipulate the build filter.

Nic;o)
Oct 1 '10 #2

Breezwell Fab
P: 2
Thanks for the reply.

So, how about embedding regular expressions in my SQL? Can this be done in order to provide a higher level of search control?

Thanks
Oct 3 '10 #3

nico5038
Expert 2.5K+
P: 3,072
You can use your own user functions in the module section to enhance the query possibilities or use stringing to create a query dynamically in VBA and execute that.

Best probably to check our articles section to get an idea of the Access possibilities.

Nic;o)
Oct 3 '10 #4

Post your reply

Sign in to post your reply or Sign up for a free account.