Attached is an application which records responses to a survey for a medical clinic. It was created by a coder as a standalone app but I took out a few forms and integrated it into an existing application we have. Because of that you may need to declare an ADODB connection variable called "conn", and a "strUsername" variable as well. Other than that I don't think you should have any problems adding these objects to a blank project, and after running the SQL script everything should work fine - let me know if you still have problems. Also attached is a scan of what the entire survey looks like - the scan is large - 30MB. What I need you to do is create a routine to create a printable version of the survey which looks sort of similar (doesn't need to be EXACT but needs to be in the same order). It needs to show the caption (from the scan) and after that show the reponse from the database. It's probably too many fields for a VB Data Report and we don't have a Crystal license, so perhaps the easiest way for you to do it is to have it generate an HTML file? Then we'd just open that file in a browser window. You should create a module called modWTCprint which has a sub printRecord(lngSerial as long) which prints the associated record from the database. With your bid please tell me how you are going to create the report. I'll accept the bid within 24 hours so plan to start work immediately, and the deadline is 2 1/2 days - plan to have it 100% completed by then. Ask any questions!
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows? (depending on the nature? of the deliverables):
a)? For web sites or? other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software? installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
VB6, MSSQL 2000