i am using MSAccess 2003 with VB6.
in my frmAdd(VB
),i have txtTask,txtDocuments,DTPicker(to show due date),txtDays,txtAttach,txtNotes and command buttons,cmdSubmit,cmdBack. when i add new tasks, my program writes to the db which stores these added tasks and displays it in a report also in db.displaying in the report is fine!
meanwhile,say i add a task 'Appointment meeting' with all the necessary details in the appropriate txtboxes, i click submit, my task is stored in the db. then i add another task with the same name, but choose a different date from the DTPicker. now, my program should read that as a different task from the first one..but looks like, it completely ignores the first one added, and reads in the 2nd one as same as the 1st one.
in my db, i have a table 'AddRecord' where these added tasks are stored, it has the fields as from the frm, Task, Documents, DDate, Days, Notes, Attachment...i have id as an autofield number, should i assign this as my PK?