Re: Like Operator does not work in VBA Acc2003
- From: "Rick Brandt" <rickbrandt2@xxxxxxxxxxx>
- Date: Sun, 26 Jun 2005 12:59:05 GMT
"Fermon" <Fermon@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:082CEB74-63B2-4BEA-82DA-3E2F9D21603B@xxxxxxxxxxxxxxxx
> Hi,
[snip]
>
> The first thing I try to do with my code is to create a column for locations
> that I can use, so I have some code like this (assume Field1 has the string
> from above):
>
> Dim rstVol as ADODB.Recordset
> Dim strTemp as String
>
> (...)
> strTemp = "*^PL=" & [Location nbr assigned by larger loop] & "^*"
[snip]
In ADO the wildcard character is %, not *
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
.
- Follow-Ups:
- Re: Like Operator does not work in VBA Acc2003
- From: Fermon
- Re: Like Operator does not work in VBA Acc2003
- References:
- Like Operator does not work in VBA Acc2003
- From: Fermon
- Like Operator does not work in VBA Acc2003
- Prev by Date: Like Operator does not work in VBA Acc2003
- Next by Date: Re: Like Operator does not work in VBA Acc2003
- Previous by thread: Like Operator does not work in VBA Acc2003
- Next by thread: Re: Like Operator does not work in VBA Acc2003
- Index(es):
Relevant Pages
|
