FW: [AccessD] "Like" operator help

rusty.hammond at cpiqpc.com rusty.hammond at cpiqpc.com
Thu Jul 14 09:06:35 CDT 2005


John, thanks for the reply but I think the link Karen provided is going to
work for me.

Thanks Karen.



-----Original Message-----
From: Nicholson, Karen [mailto:cyx5 at cdc.gov]
Sent: Thursday, July 14, 2005 7:36 AM
To: Access Developers discussion and problem solving
Subject: RE: FW: [AccessD] "Like" operator help


Isn't working for the government cool?  Here is a link to download the
drug information released by the FDA:

http://www.fda.gov/cder/ndc/index.htm 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Clark
Sent: Thursday, July 14, 2005 7:47 AM
To: rusty.hammond at cpiqpc.com; accessd at databaseadvisors.com
Subject: Re: FW: [AccessD] "Like" operator help

Sorry that I didn't reply to this Rusty. I was cleaning out my Junk mail
folder and noticed it somehow got sent into there...don't you feel
special? I don't usually even look in here, but I am expecting a quote
on some Cisco equipment from a new vendor, and being new they sometimes
get put in there. Ya just gotta love how the spammers have created a
mess for us.

Anyhow, I don't know where they get the drug list. I am assumming that,
because we are a govt. agency, that it probably comes from the state
(NY) or medicaid (more probable). I did this as a favor for my
co-worker, who is out this week, and I don't know who she was speaking
with, so I can't check w/them. If you would like, I could look into it
next week for you.

Take care!

John W Clark

>>> <rusty.hammond at cpiqpc.com> 7/8/2005 10:07:21 AM >>>
John, you mentioned they get a monthly update of their drug list.  Do
you know where they are getting this drug list and what the cost is?
I'm working on an app that requires a drug list.

Thanks,

Rusty Hammond


-----Original Message-----
From: John Clark [mailto:John.Clark at niagaracounty.com]
Sent: Friday, July 08, 2005 8:48 AM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] "Like" operator help


I really didn't want to use a form...this is just a simple table (i.e.
not a whole program) that our nursing department will use...they get an
update monthly (I think it is) and just want to quickly access any given
drug. But, I did think a form may be the answer, so I whipped up a quick
litte one. One the form I've got a text box (Text0) and a label
(Text2)...I'm just playing right now, so the names are defaults. On the
"On Change" property of Text0, I've got a statment that says
Text2.Caption = "Like '" & Text0.Text & "*'" 

This is working fine in the label, as it is showing up the way I want
it...although I just noticed that I only have single quotes...hmmmm. I
bet if I can get double quote in there it works.

Right now, if I put "t" into Text0, I see: Like 't*' in Text2, and in
the query I have [Forms]![enterfrm]![Text2] in the criteria section.
This little bugger is turning out to be...well...a little bugger ;(

>>> pharold at proftesting.com 7/8/2005 9:32 AM >>>
Append the global "*" to whatever is the value entered (as a string)
with the "&" character and then submit to the query.

Perry Harold

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Clark
Sent: Friday, July 08, 2005 9:25 AM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] "Like" operator help

I should clarify that I did get:

Like "ty*"

to work, but I want to leave it to the user to enter the letter(s).
And, I am using A2K

>>> John.Clark at niagaracounty.com 7/8/2005 9:20 AM >>>
This is probably beyond simple, but I really don't use it very often,
and I just ran into a problem.

I am trying to whip up a table of approximately 20,000 drugs. Many of
the drug listings are actually the same drug, but with different
strengths. For example:

Field5	ID	Field1	Field2	Field3	Field4	Field6	Field7
ABILIFY 1 MG/ML
SOLUTION	13	BEX	59148-0012-15	2.31031		0
OTSUKA
AMERICA
ABILIFY 10 MG
TABLET	14	BEX	59148-0008-13	10.04479		0
OTSUKA
AMERICA
ABILIFY 15 MG
TABLET	15	BEX	59148-0009-13	10.04479		0
OTSUKA
AMERICA
ABILIFY 20 MG
TABLET	16	BEX	59148-0010-13	14.20458		0
OTSUKA
AMERICA
ABILIFY 30 MG
TABLET	17	BEX	59148-0011-13	14.20458		0
OTSUKA
AMERICA
ABILIFY 5 MG
TABLET	18	BEX	59148-0007-13	10.04479		0
OTSUKA
AMERICA

I want to build a query that let you type in Tylenol and get to that
drug, or even "T" and get to that point of the list, where the "t"s are
located. I tried using a "Like" statement in the query, but it didn't
work. How is this done?

Thank you!

John W Clark
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com 

**********************************************************************
WARNING: All e-mail sent to and from this address will be received,
scanned or otherwise recorded by the CPI Qualified Plan Consultants,
Inc.
corporate e-mail system and is subject to archival, monitoring or review
by, and/or disclosure to, someone other than the recipient.
**********************************************************************
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

**********************************************************************
WARNING: All e-mail sent to and from this address will be received,
scanned or otherwise recorded by the CPI Qualified Plan Consultants, Inc.
corporate e-mail system and is subject to archival, monitoring or review 
by, and/or disclosure to, someone other than the recipient.
**********************************************************************



More information about the AccessD mailing list