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 |
#1
|
|||
|
|||
Create database and form for patient records
I need some help, i am a beginner when it comes to Access but have worked a
lot with Excel. I want to create a database and forms/reports to use in a small scale veterinary reception. Owners come to visit with their pets. For every visit i want to 1. Open up the record for this animal, see the history, and then create a new record with the same customer number with a reference to original old record. The original record should also contain information about the new records - date + one more field is enough. 2. Create new record if the patient haven't been here before. I want to be able to extract reports about : - a specific patient - e.g. the whole so called journal - a report on the current visit Can someone tell me where i can find out how to do this? The interface to enter all data needs to be nice to look at, and it have to be easy to search on different fields to find back old patients and old records. Does anyone know if there is an example to download that I can use to work from?? I was a bit overwhelmed when using the built in database guide. thanks a lot in advance! |
#3
|
|||
|
|||
Create database and form for patient records - Stevie Pimps AGAIN!
"Steve" wrote in message
... Hello Amiranda, ... don'tant ... I guess English is not your native language. I would like to offer to build the database for you. I provide help with Access, Excel and Word applications for a small fee. If you would like my help, contact me. Steve Now stevie, your lesson for today is that libel requires the explicit writing of known falsehoods. If you can point out what has been written that is untrue please do so. It took us a while for use to get you to understand that written communication does not count as slander. These newsgroups are provided by Microsoft for FREE peer to peer support. There are many highly qualified individuals who gladly help for free. Stevie is not one of them, but he is the only one who just does not get the idea of "FREE" support. He offers questionable results at unreasonable prices. If he was any good, the "thousands" of people he claims to have helped would be flooding him with work, but there appears to be a continuous drought and he needs to constantly grovel for work. A few gems gleaned from the Word New User newsgroup over the past Christmas period and a few gems from the Access newsgroups to show Stevie's "expertise". Dec 17, 2008 7:47 pm Word 2007 .......... In older versions of Word you could highlght some text then go to Format - Change Case and change the case of the hoghloghted text. Is this still available in Word 2007? Where? Thanks! Steve Dec 22, 2008 8:22 pm I am designing a series of paystubs for a client. I start in landscape and draw a table then add columns and rows to setup labels and their corresponding value. This all works fine. After a landscape version is completed, I next need to design a portrait version. Rather than strating from scratch, I'd like to be able to cut and paste from the landscape version and design the portrait version. Steve Dec 24, 2008, 1:12 PM How do you protect the document for filling in forms? Steve One of my favourites: Dec 30, 2008 8:07 PM - a reply to stevie (The original poster asked how to sort a list and stevie offered to create the OP an Access database) Steve wrote: Yes, you are right but a database is the correct tool to use not a spreadsheet. Not at all. If it's just a simple list then a spreadsheet is perfectly adequate... Sept 10, 2009 (In respose to a perfectly adequate GENERIC solution stevie wrote) This function is specific to the example but not generic for any amount paid out. Steve Sept 9, 2009 "Steve" wrote in message you can then return all the characters in front of it with the Left() fumction. Would look like: Left("YourString",Instr("YourString","VbCr" Or "VbLf") - 1) Steve No, it would not look like Left("YourString",Instr("YourString","VbCr" Or "VbLf") - 1) First of all, the constants are vbCr and vbLf: no quotes around them. With the quotes, you're looking for the literal strings. Second, you can't Or together character constants like that. Even if you could, Or'ing them together in the InStr function like that makes no sense at all. Sept 22,2009 Sorry Steve, even I can see that this is a useless answer. I made it pretty clear that "CW259" is just ONE possible value for the control. "Steve" wrote: Hello David, Open your report in design view and select txtOrderID. Open properties and go to the Data tab. Put the following expression in the Control Source property: =IIF([chkActive],"CW259","(CW259)") Steve John... Visio MVP |
#4
|
|||
|
|||
Create database and form for patient records
Developing applications in Access is not an easy thing to do for a beginner.
It requires some training. Your best approach is to find a pre-built application. It sounds like your requirements would be something that would have been developed many times in the past. -- Dorian "Give someone a fish and they eat for a day; teach someone to fish and they eat for a lifetime". "Amiranda" wrote: I need some help, i am a beginner when it comes to Access but have worked a lot with Excel. I want to create a database and forms/reports to use in a small scale veterinary reception. Owners come to visit with their pets. For every visit i want to 1. Open up the record for this animal, see the history, and then create a new record with the same customer number with a reference to original old record. The original record should also contain information about the new records - date + one more field is enough. 2. Create new record if the patient haven't been here before. I want to be able to extract reports about : - a specific patient - e.g. the whole so called journal - a report on the current visit Can someone tell me where i can find out how to do this? The interface to enter all data needs to be nice to look at, and it have to be easy to search on different fields to find back old patients and old records. Does anyone know if there is an example to download that I can use to work from?? I was a bit overwhelmed when using the built in database guide. thanks a lot in advance! |
#5
|
|||
|
|||
Create database and form for patient records
"Steve" schreef in bericht ... Hello Amiranda, Access and Excel are quite different! In fact, having worked a lot with Excel may be an impediment since it might unconsciously cause you to think in spreadsheet terms while you try to build your database. If you are in a hurry to get your database up and running shortly, it isn't going to happen. You have a lot to learn first and it's guaranteed to be frustrating doing it yourself. If you don'tant the frustration and need to be up and running shortly, I would like to offer to build the database for you. I provide help with Access, Excel and Word applications for a small fee. If you would like my help, contact me. Go go go go go go.... I guess you will never ever learn... never ever stop... I AM considering to hunt each and every post from you till the end of days... Get lost $teve. Go away... far away.... Again... Get lost $teve. Go away... far away.... Again... Get lost $teve. Go away... far away.... No-one wants you here... no-one needs you here... This newsgroup is meant for FREE help.. No-one wants you here... no-one needs you here... OP look at http://home.tiscali.nl/arracom/whoissteve.html (Website has been updated and has a new 'look'... we have passed 10.000 pageloads... it's a shame !!) Arno R |
#6
|
|||
|
|||
Create database and form for patient records
Amiranda,
Your needs are very specific and you are not likely to find a template that does exactly what you need. However, if you are willing to dive in yourself, check out these links: Jeff Conrad's resources page: http://www.accessmvp.com/JConrad/acc...resources.html The Access Web resources page: http://www.mvps.org/access/resources/index.html A free tutorial written by Crystal (MS Access MVP): http://allenbrowne.com/casu-22.html MVP Allen Browne's tutorials: http://allenbrowne.com/links.html#Tutorials http://www.databasedev.co.uk/table-of-contents.html And we, with the exception of one, are here to help for FREE! If you are looking to hire someone, check out you local Universities and Colleges. If you are looking to hire someone get refrences AND check them. GoodLuck! Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Amiranda" wrote in message news I need some help, i am a beginner when it comes to Access but have worked a lot with Excel. I want to create a database and forms/reports to use in a small scale veterinary reception. Owners come to visit with their pets. For every visit i want to 1. Open up the record for this animal, see the history, and then create a new record with the same customer number with a reference to original old record. The original record should also contain information about the new records - date + one more field is enough. 2. Create new record if the patient haven't been here before. I want to be able to extract reports about : - a specific patient - e.g. the whole so called journal - a report on the current visit Can someone tell me where i can find out how to do this? The interface to enter all data needs to be nice to look at, and it have to be easy to search on different fields to find back old patients and old records. Does anyone know if there is an example to download that I can use to work from?? I was a bit overwhelmed when using the built in database guide. thanks a lot in advance! |
#7
|
|||
|
|||
Create database and form for patient records
Thanks GIna for the tip, I will see if I can figure it out with help from the
links you gave, and then I'm sure I'll come back to ask more questions at a later stage :-) thanks again, "Gina Whipp" wrote: Amiranda, Your needs are very specific and you are not likely to find a template that does exactly what you need. However, if you are willing to dive in yourself, check out these links: Jeff Conrad's resources page: http://www.accessmvp.com/JConrad/acc...resources.html The Access Web resources page: http://www.mvps.org/access/resources/index.html A free tutorial written by Crystal (MS Access MVP): http://allenbrowne.com/casu-22.html MVP Allen Browne's tutorials: http://allenbrowne.com/links.html#Tutorials http://www.databasedev.co.uk/table-of-contents.html And we, with the exception of one, are here to help for FREE! If you are looking to hire someone, check out you local Universities and Colleges. If you are looking to hire someone get refrences AND check them. GoodLuck! Gina Whipp |
#8
|
|||
|
|||
Create database and form for patient records
"Amiranda" wrote in message
news I need some help, i am a beginner when it comes to Access but have worked a lot with Excel. I want to create a database and forms/reports to use in a small scale veterinary reception. Owners come to visit with their pets. For every visit i want to 1. Open up the record for this animal, see the history, and then create a new record with the same customer number with a reference to original old record. The original record should also contain information about the new records - date + one more field is enough. 2. Create new record if the patient haven't been here before. I want to be able to extract reports about : - a specific patient - e.g. the whole so called journal - a report on the current visit In addition to the other advice offered, one of the most important steps is to get your tables and their relationships structured correctly. Tables are the foundations for your app. To do this, think of entities and attributes. For example, a client is an entity with attributes such as surname, first name and title. A pet is an entity with attributes such as name, type and breed (eg Bonnie, Dog, German Shepherd). A client can have many pets, so there's a one-to-many relationship for starters. An appointment is an entity with attributes such as client, date and time. That's just a bit of food for thought, 2p supplied Keith. www.keithwilby.co.uk |
#9
|
|||
|
|||
Create database and form for patient records
"Steve" wrote in message
... You have a lot to learn No, *you* have a lot to learn, rules of the group for starters. |
#10
|
|||
|
|||
Create database and form for patient records
You are most welcome!
-- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Amiranda" wrote in message ... Thanks GIna for the tip, I will see if I can figure it out with help from the links you gave, and then I'm sure I'll come back to ask more questions at a later stage :-) thanks again, "Gina Whipp" wrote: Amiranda, Your needs are very specific and you are not likely to find a template that does exactly what you need. However, if you are willing to dive in yourself, check out these links: Jeff Conrad's resources page: http://www.accessmvp.com/JConrad/acc...resources.html The Access Web resources page: http://www.mvps.org/access/resources/index.html A free tutorial written by Crystal (MS Access MVP): http://allenbrowne.com/casu-22.html MVP Allen Browne's tutorials: http://allenbrowne.com/links.html#Tutorials http://www.databasedev.co.uk/table-of-contents.html And we, with the exception of one, are here to help for FREE! If you are looking to hire someone, check out you local Universities and Colleges. If you are looking to hire someone get refrences AND check them. GoodLuck! Gina Whipp |
Thread Tools | |
Display Modes | |
|
|