Q: Regular Expressions in Access 2000?

  • Thread starter Thread starter Guest
  • Start date Start date
Mark said:
Is there a regular expressions plug in for Access 2000?
Click to expand...


The Microsoft VBScript Regular Expressions library should be
one of your available reference libraries.
 
Hi, Mark.
Is there a regular expressions plug in for Access 2000?
Click to expand...

One may use the regular expressions scripting library in VBA projects. To
do so, open the VB Editor (press <ALT><F11>), then select the Tools ->
References menu to open the References dialog window. Scroll down to
Microsoft VBScript Regular Expressions 5.5 and select the check box next to
it. Select the "OK" button to save the change. Compile the code.

For example syntax, please see the "Microsoft Beefs Up VBScript with Regular
Expressions" tutorial on the following Web page:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnclinic/html/scripting051099.asp

More example syntax:

http://groups.google.es/group/micro...ead/thread/2a07d628348f1635?hl=en&lr=&rnum=28

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact info.

- - -
If my answer has helped you, please sign in and answer yes to the question
"Did this post answer your question?" at the bottom of the message, which
adds your question and the answers to the database of answers. Remember that
questions answered the quickest are often from those who have a history of
rewarding the contributors who have taken the time to answer questions
correctly.
 
Thank you!!! (belated)

'69 Camaro said:
Hi, Mark.


One may use the regular expressions scripting library in VBA projects. To
do so, open the VB Editor (press <ALT><F11>), then select the Tools ->
References menu to open the References dialog window. Scroll down to
Microsoft VBScript Regular Expressions 5.5 and select the check box next to
it. Select the "OK" button to save the change. Compile the code.

For example syntax, please see the "Microsoft Beefs Up VBScript with Regular
Expressions" tutorial on the following Web page:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnclinic/html/scripting051099.asp

More example syntax:

http://groups.google.es/group/micro...ead/thread/2a07d628348f1635?hl=en&lr=&rnum=28

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact info.

- - -
If my answer has helped you, please sign in and answer yes to the question
"Did this post answer your question?" at the bottom of the message, which
adds your question and the answers to the database of answers. Remember that
questions answered the quickest are often from those who have a history of
rewarding the contributors who have taken the time to answer questions
correctly.
Click to expand...
 
Back
Top