[Pharmwaste] Access database for use for inventory of collected pharmaceuticals

Jaramillo, Jeanie Jeanie.Jaramillo at ttuhsc.edu
Thu Dec 17 11:56:24 EST 2009

Hi Ed,

We held our first event on Sep. 12th.  Our poison educator, Ronica Farrar, developed an Access database and form for inventory of items collected.  It has about 600 medications pre-entered.  There were still numerous meds that we manually entered as people brought tons of alternative products, etc.  There are a few fields that you would need to customize for your event.  I tried to send you the Access database, but the file was too large.  So, we have added it to our Medication Disposal Google Group website.  I've attached a document explaining how to join our Google Group.  If you would like to view the documents we have, many of them are posted there and the database is now there too. (Go to "files" "view all"; the database is labeled "Medication Cleanout Database A"). You are welcome to use any of those materials and modify them in any way needed.  Our next event is also in March and we will likely be adding more to the database.  If you aren't already planning to do a participant survey, you might consider it.  One of the most valuable things we did was to ask every participant what they would have done with the meds if they could not have brought them to the collection.  55% said they simply would have KEPT them!!!! From memory, about 12% would have trashed them and ~10% would have flushed.  I'd be happy to have a phone conference or GoToMeeting if you would like.  Good luck!

Jeanie Jaramillo, PharmD
Managing Director, Texas Panhandle Poison Center
Assistant Professor, Texas Tech UHSC School of Pharmacy
1501 S. Coulter St.                   
Amarillo, TX 79106
P: (806) 354-1611
C: (806) 672-0833
F: (806) 354-1667
Cisco IP: 30412

-----Original Message-----
From: Ed Gottlieb [mailto:egottlieb at cityofithaca.org] 
Sent: Wednesday, December 16, 2009 6:15 AM
To: pharmwaste at lists.dep.state.fl.us
Subject: [Pharmwaste] Needed: pharm inventory spread sheet for collection event

Hi All,

We are organizing our first pharm waste and sharps collection event in Tompkins County, NY for March, 2010.  We are planning on inventorying what is received.  To do this easily, we will need a spread sheet listing the most commonly turned in prescription and over the counter medications.  Do you have one that we can use?  Thanks very much!

I'm about to submit my work plan as part of the permit application process in NY.  I'm attaching it for those interested.  If you have any feedback, I'd be happy to get it.  If you have changes to suggest, please send them along right away so I can utilize your ideas.


Ed Gottlieb
Pretreatment Coordinator
525 3rd Street
Ithaca, NY  14850
(607) 273-8381

-------------- next part --------------
A non-text attachment was scrubbed...
Name: PDF Google group instructions.pdf
Type: application/octet-stream
Size: 444553 bytes
Desc: PDF Google group instructions.pdf
Url : http://lists.dep.state.fl.us/pipermail/pharmwaste/attachments/20091217/3ed25d5b/PDFGooglegroupinstructions-0001.obj

More information about the Pharmwaste mailing list