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. **********************************************************************