were in a group project in vb 6 here in college and we are very very stuck in our hospital program, that we are making. we cant seem to get simple things to work
like:
adding searching and deleting records from a database.
and looking up medical history.
if any of you would look at it and point us in the right direction that would be super....its 2am here and it has to be in for 12pm (a few hours away)
you should zip you code then attach it to your post so someone can look at it
Please support one of my projects? TKForums.com Web Forum JavaScript Wiki
________________________
If somone helps you, please rate their post, by clicking the to rate their post
The VB part of the assignment is worth 50 points, I'd work on that first.
Easiest thing to do is to use a datagrid for listing, entering and deleting patients. Of course, its been so long since I've used vb6, i couldn't tell you where to even begin anymore.
Well your screens look OK, but you are relying on bound controls everywhere. It is not easy to follow any program flow with that I am afraid.
Also, I was amazed that there was not a single module in your project - just forms.
A hint or two and a good solid answer on a sticky point - yep, no problem - this is the place. But a project write is asking a lot. Sorry guys, Its 2.17AM my end and there is no way I could start it let alone fit it in. I am almost asleep at the keyboard now.
I wish you luck - you are going to need it.
David
Learn the Rules so that you know how to break them properly.
OK - that free's up the forms so they should do the job. I have just had a look at your database and the relationships are huge.
When you try to add a record now, one of the relationships is stopping you from doing that. As you built the databse I am afraid that one is yours to figure. But your add and delete forms should now work. I will re-post so you can see what I did.
Don't use my project as i had to point the data objects to a different directory to get at the database.
EDIT - Typos and attachment
Last edited by David.Poundall; Dec 8th, 2004 at 09:43 PM.
David
Learn the Rules so that you know how to break them properly.
You get the same problem when trying to delete. To many interrelated tables. You may need to release some of the relationships in order to get add and delete to work. But then things may not work as you intended.
That's all I can do for you guys.
Good luck and goodnight.
David
Learn the Rules so that you know how to break them properly.
Perhaps you need to think about a change in career direction.
On the face of it it may look like you are close to a solution but the two parts don't hang together. your best bet is to find the guy that did the database and get him to change the table structure around to match your code.
The database being the more complex of the two codes.
David
Learn the Rules so that you know how to break them properly.
I took a look at your db model, and it was definitely far too much...
With the diagram pic I have attached, you have the db structure you need to accomplish the assignment.
I'm looking into to some other parts of the db, mainly the forms, im not sure why there are some in the access db itself (perhaps the guy was just testing it)
Well, first off- I have a revised model, don't worry too much on the database, ill upload it once im done revising it.
Here's a few questions though:
true or false...
1) An appointment can be made because of one or more ailments?
2) An appointment can have one or more results... ?
I assume true to both.
There is no need for a patient history table, because really all you are going to do is check the appointment table for anytime that patient made an appointment. With that data, you will be able to surmise what ailments there were, and/or what results (refered, given a prescription, etc).
Attached is a pic of what I believe is the final model of the database.
ONE MORE QUESTION: Does your assignment requires that the database has forms, or just the VB6 app, or do both need to have forms (for instance, if you open up the database and in the forms, you will see Patient... does that need to be there?)
Last edited by nemaroller; Dec 8th, 2004 at 11:45 PM.
We have appended our relationships to the specifications in your attatchment. We are attatching the new vb, can you see if this is correct as you obviously have much more of an insight than us.
Your project requires you be able to append one or more ailments, and one or more results to any one appointment.
Like I said, I have the database side finished except for one question...
DOes the database need to have forms inside of it? Yours did... I think maybe only so the person who created it could test his relationships... I didn't see anything in the project requirement that stated so.
If the database doesn't need its own internal forms, then I can upload the db to
you right now, and start helping you with the vb side.
I've been through this once before long ago myself, so I know where you're coming from.
Reply With Quote
to rate their post
Perhaps you need to think about a change in career direction. 