By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,392 Members | 1,556 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,392 IT Pros & Developers. It's quick & easy.

Searching in VB

P: n/a
I wish to search the VB of my Access database for lines containing
simply:
Resume

Searching for Resume gives me lines like:
Resume next
Resume exitCode
of which there are many

I want to be able to search for 'Resume followed by end of line' but
cannot
see, even using Pattern Matching how to do this.

In other systems (Unix for example) one can search for text at the
beginning
or end of a line - just what I need here.

Any ideas?

Why do I want to find these lines? Well, sometimes when debugging I
enter
Resume to find out exactly which line is causing the problem.
Unfortunately
some of these lines get left in!!

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Devonish wrote:
I wish to search the VB of my Access database for lines containing
simply:
Resume

Searching for Resume gives me lines like:
Resume next
Resume exitCode
of which there are many

I want to be able to search for 'Resume followed by end of line' but
cannot
see, even using Pattern Matching how to do this.

In other systems (Unix for example) one can search for text at the
beginning
or end of a line - just what I need here.

Any ideas?


Something along the lines (huh) of
with theOpenModule
If .Find("Resume", n1, p1, n2, p2) Then
If Trim(.Lines(n1, 1)) = "Resume" Then
MsgBox "Gotcha! at line" & n1
End If
End If
End With
--
Bas Cost Budde
http://www.heuveltop.org/BasCB
but the domain is nl

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.