By dryan - 10/9/2009
Hello to all. My name is ryan and to get to the point, I'm a graduating student at a certain computer school here in the Philippines. For our final project, my instructor has instructed us to make a system. Now, i've already took this subject twice, having failed last time due to database error and now that it's my 2nd time taking up this subject. I would very much appreciate it if any of you could kindly help me out on how to make the database work.
Here are my specs :
Visual Basic Enterprise Edition
MS Office 2007 - I use the MS Access as database
Windows XP SP2
Anyway, the system is all about Dental System. I've already tried and tried and yet failed again to make the database work. I have no problem with designing and coding a few of the command buttons in the dental system. I'm still a beginner with programming so please bear with me.
Here's the problem, the system is all set in terms of design, now whenever i would try to make a database i do it this way;
1. Add - ins --> Visual Data Manager
2. VisData --> New --> Microsoft Access 7.0 MDB
When i get to this part and start designing the table;
1. Should I include all of the fields that i want to be recorded in the database?
2. Should I also include those that are combo boxes?
3. This system that I am making has a search function, can anyone please tell me how to make that work?
4. Where do I go from now?
Basically, I'm asking help for a step by step procedure on how to make the Database work.
My other problem, whenever I'm finished with the table structure and would start to connect it to the system and begin to add the coding for the SAVE Button
I would use
Data1.Recordset.MoveLast
Data1.Recordset.AddNew
txt1.SetFocus
that's my coding for the SAVE button but it doesn't seem to work cause whenever I would
try save a current record through the system an Error Message would pop up that says
Run Time Error ' 3021 '
" No Current Record " Then you have the option to Continue(grayed out) End Debug Help
Please.. Help me out here. I don't want to fail again on this subject. Please do help me.
Please kindly send me a step by step procedure on how to make the database work.
I don't care if I would have to start from the beginning and ruin the whole design of the system as long as the database can work.
I'm desperate right now. I hope that there's someone out there that can help me out T__T
here's my email address
lil_droj_666@yahoo.com
please please please. help me
|