Create database and form for patient records

[Amiranda]

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!

 

[Steve]

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.

Steve
(e-mail address removed)

 

[John... Visio MVP]

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
(e-mail address removed)

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)

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

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.

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

 

[Dorian]

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

 

[Gina Whipp]

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/accessjunkie/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]

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,

 

[Keith Wilby]

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

 

[Keith Wilby]

You have a lot to learn

No, *you* have a lot to learn, rules of the group for starters.

 

[Gina Whipp]

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