If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
Datebase needed for tracking of drugs for a fire department!
Fred,
There are several websites devoted to matching business needs with availble developers, including for MS Access database development. The problem is that anyone can claim to be a professional developer and typically work goes to the lowest bidder, which is not the best approach to getting optimum solutions... There are good developers, don't get me wrong, but one has to be very careful. One of these website would be http://www.guru.com/index.aspx but there are tons more out there. I still prefer to find someone local that I can do a face to face with. -- Hope this helps, Daniel Pineault http://www.cardaconsultants.com/ For Access Tips and Examples: http://www.devhut.net Please rate this post using the vote buttons if it was helpful. "Fred" wrote: There ought to be a different (simple) place to go for people who decide that they want to pay for help, knowing that they want to get a lot more help than just a question answered. Maybe with the impramateur or vetting of having some type of criteria for the providers. Some people really need that. Is there such a place? That would meet that need without polluting the concept of this for a free forum. "Pete D." wrote: Steve is what is called in newsgroups as a troll trying to get money for what others believe should be provided free. Yes, if you could develop it in Excel then Access is a good expansion of your skills. Hardest part is to change how you view the data. Excel makes you think in math calculations. In access you can save yourself a lot of time with table relationships. For instance you no longer would create a new line for each drug of the same type. Instead you create a table of all your drugs and then adjust the quantities. Shelf life of the drug could be loaded once and then access would calculate expieration dates from your inventory update dates using the standard shelf life. This is simplified but many stock inventory programs deal with shelf life, usage and automatic usage of product restocking requirements. You could also easily add which unit has what and qty on the unit. Add in a personnel file and you can track who used it and who restocked. Now this could easily become part of a investigation so testing and proving it is critical but as a backup you can print reports on stock, restock and who did it weekly and have the station Chief master EMT sign the report and file in a secure location. Access will save you much of the repetitive work and help provide a good audit trail. Start by reading about relationships and post back as you play, many will jump in with free help with much more knowledge than myself or Steve. As you'll note, they don't troll newsgroups for business as they can get enough on reputations. Start with learning about relational databases. Check out http://allenbrowne.com/casu-06.html Pete D. "Mark" wrote in message m... I provide help with Access applications for a very reasonable fee. If you are interested in outside help, send me a copy your Excel workbook and a brief desacription of how it works and what you want the database to do and I will gladlt send you a quote to create the database you want. Steve "FIRESUPPORT" wrote in message ... I work for a fire department and one of my job duties is keeping track of drugs that we keep on Rescue's and Engines. Details of it is Date received, lot #, expiration date, and qty. We are using a excel program that i developed but since then it has grown. What i am looking for other than keeping track of them is that i have to make sure it is all seperated by drug so that way we can find out what's expiring, and how many, and when it came in. So we can order more. Is there a database out there already? Or do i just keep it simple in excel? Any help would be appreciated. Thankyou Fire Support |
#12
|
|||
|
|||
Datebase needed for tracking of drugs for a fire department!
FIRESUPPORT wrote:
I work for a fire department and one of my job duties is keeping track of drugs that we keep on Rescue's and Engines. For what it's worth I'm working on a Fleet Management system right now. I will shortly be working on inventory and should have it ready in a few months. This will include those requirements you've specified. See the Fleet Management system at http://www.granite.ab.ca/fleet/ Tony -- Tony Toews, Microsoft Access MVP Please respond only in the newsgroups so that others can read the entire thread of messages. Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/ |
|
Thread Tools | |
Display Modes | |
|
|