Find/Replace Wildcards

[Kev]

Hello,

I'm trying to upgrade an Access application from a very old version
(Access 2.0) to Access 2000. The major item that does not get converted
automatically is the fact that the original author used the following
format in the code to access data in recordsets:

RS.[Field]

Current versions of VB however don't recognize this, and want the format:

RS("Field")

to be used. All well and good, so I want to do a global replace of
these. Using the Replace dialog box, I can match the first format with
pattern matching enabled using .[[]*[]] in the find section, however, I
have no idea how to (or if it's even possible to) take the * selection
(Field in the case above) and insert it into the replace function. If I
try to put the * in brackets like so .[[](*)[]] it will no longer match,
and attempting to use either [1] or \1 in the replace expression simply
uses those as literals! Is there any way I can get the field name to use
in the replacement string? I don't see any options for regular
expressions on the replace dialog.

Thanks,
Kev

 

[Mike Walker]

I dont think this behaviour is supported you could copy the macro/text to
word and use its replace features and paste back not that convienient but I
think this is the case, else the \ is normally used as an escape character
that might help ie \[ is the [

Rgds

Mike Walker
(Reply via NG)