Ok, yes this is an assignment. Yes It's due tomorrow, and yes I have spent countless hours trying to do this, my head is fried I start work in less than 6 hours and it's due in approximately 17hours time.
Main problems:
- I need to generate a Primary Key in VB for a MS Access database (im not allowed to use the auto-increment feature). This PK is going to be a number that increments +1 for each record added.
- I need to be able to delete records from the database. I view a record in VB (from the database) if the record status (I have a field in the database called AccStatus) = Yes. So when i delete a record I want the status = No, so it won't show up when I view all records, yet it will still exist in the database.
- Database connections must be carried out using ADO
Im after a quick solution (yes I know this totally goes agains the board rules but hey, its worth a try). Im also willing to pay whoever comes up with the full solution via paypal (a reasonable amount).
Here is what I have for generating the AccNum (primary key), pretty much pseudocode
On cmdAdd Click:
'Auto generate AccNum when adding new Account
Select LastAccNum from tblsystem (tblSystem is the table name that stores the last AccNum stored in another table called tblAccounts)
txtAccNum.text = LastAccNum + 1
I really need to get some sleep before work, so I'll check it in a few hours and if somebody is interested then please email me
and I can send you all the code I have and the MS Access Database, which will make solving this problem a helluva lot easier.
Im sorry I had to stoop this low
/can't believe how pathetic i've become. :/
p.s Just Noticed can add attachments - i've included it all as a zip.