I have program made in MS Access 2003 and I need some improvements and modifications. The program named Faxer now does the following. Briefly, throw a query, with field’s iddate,doctor, patient and exam, collects and send the data to a report. The report(s) had been split by doctor field and by picking up the corresponding e-mail (or fax), from the table docmail, directed, throw MSoutllook, to mail addresses in a faxserver ([url removed, login to view]). Simultaneously a field named Printed changes his value from 0 to 1. After that the faxserver has trying 3 times to send the faxes. Subsequently the server of mailfaxes returns back reports with sign status “delivered” or “not-delivered” according to the success of the transmission. At the same time informs a table tblDeliveries. The program then, by pressing a button, search the MSoutlook and depending of the above mentioned status changes the field printed from 1 to 0, if the status is “non-delivered” and subsequently mark the correspondence records on table tblDeliveries I have the code that is explanatory.
What I want from the program is after the mailFaxes had been sent to a server and the sign status “delivery” or “non delivery” come to my mail the .RTF files that produced by the program went to a directory “exprFiles”. So there are few steps after that 1. The .RTF must monitored by a table like tblRecoveries, if the transmission produce “non-delivered” the .RTFs should be moved to a directory named “failed”. The program now should has two options , one is to send all the “non-delivered” again to FaxServer or to send the above to a local fax driver, lets say Microsoft fax, but there’ll be another option on what faxDriver we can use (discuss this case). The re-send files should be return to the original directory. There must be a notice if a conventional fax (not a faxmail) doesn’t transmit successfully and a time scheduler into the database that could monitor the transmision of files, if we want. Further minor modifications should be discussed during the project.
15 freelancers are bidding on average $205 for this job
This can certainly be done using Access VBA in which I have extensive experience. Please allow some days for communication, timeline difference, etc. I am ready to start IMMEDIATELY. Please refer to PM.
We are serious abt ur project. plz checkout our company details. The bid amt and time is forwarded to u after formal discussion with our experts. Thanks Regards SHESHPUSHPA INFOMATRIX PVT.LTD.