Need help in coding a simple 4 button program connected to a DB using a Class Module.
Posted on 2003-03-30
I was given a simple 4 button application that I am to break down and duplicate. Unfortunately the data that is to be pulled for the application is connected to a MS Access Database for its information.
The 4 buttons include "Open Database", "Test Delete", "Test Insert" and "Test Update".
The database I have completed and its fields are PartNumber, Quantity In Stock, Cost and Sales Price.
So far, that sounds fairly simple.
Here is the sticky part, all or most of the coding for the applications buttons is supposed to be done through a Class Module.
I have to create the code for the "OpenDB" method which accepts one argument, the file name of the Database to open.
For the "Insert" button, I have to create 4 arguments which are all the fields of the database.
For the "Update" button, it should accept all the arguments that the "Insert" button has and update all the fields.
Finally, the "Delete" button deletes all records on the bases of the part number only.
The biggest problem I see with this is the fact that on the original application, I see underlined letters that are used as Ctrl shortcut keys and I'm not sure how those can be used since they are not menus, but cmdButtons. I have worked with coding these types of programs in the past, but not using "Class Modules" and connecting these to one. The other problem is that the program doesn't produce any visible output, therefore I can't see what is happening behind the scenes.
I apologize if this sounds extremely stupid, but being a nooby at this, I'm really at a loss with Class Modules and have no other help on this.
Any help would be greatly appreciated