Project Detail

Description

1) Report List of Seguimiento: The last field, seguimiento, it is a little bit tricky. It must show, from the the table seguimiento the last field and the last date.


For example, the first registry of the table inquiry, the inquiry number DRA-93-324 has 3 status and 3 dates.


At the form LIST OF seguimiento form it must show the last status and the last date of those 3 (cancelled by client – 20/09/2008)



2) At the same report (List of Seguimiento) at the end of every single line it must appear a button that when you click on it, It must open the inquiries Form with the detail of that inquiry.


3) Warning: At the INQUIRIES FORM, you can see the checkbox warning. When the checkbox warning is checked it must work like this.



The program must send and email to the responsible 5 days and 1 day before then PT end date and the PC ends date. You have to be sure the program will send it only once, the program could be opened 1 time or 0 times a day if it opens 0 times it is ok not to send, it will send the very next day. The emails are already stored at the responsible table.

There must be another warning for follow up that we must discuss at skype.



4) Make it botable so it can be runed out of the access



5) Import the xls I will send to the database, just the fields with the same name to the table inquiries.



Find attached the current mdb.


Additional files submitted:
Target Input.rar