How Software Gets Done  


Login

Software Buyers
Request bids
Search coders
My Buyer Account
Buyer help
Buyer articles
Buyer FAQ
Latest news
 
Software Coders
Newest open work
Browse all work
Search all work
My Coder Account
Coder help
Coder articles
Coder FAQ
Latest news
 
Affiliates
My Affiliate Account
Affiliate help
Affiliate FAQ
Latest news
 
Newest Bid Requests.
(See all)
Oscommerce Fix - Category/Subcat egory Titles
By sistervisiontec h on Sep 8
Max Bid: $50


SQL Query & Stored Procedure - Oracle
By jpmarno on Sep 8
Max Bid: $200


Oscommerce Contributions - Affiliate Software
By sistervisiontec h on Sep 8
Max Bid: $40


Custom web mail
By TheBestCoder on Sep 8
Max Bid: Open to fair suggestions


Link Java Games to MS SQL
By TheBestCoder on Sep 8
Max Bid: Open to fair suggestions


Online pharmacy script
By jnzsoftware on Sep 8
Max Bid: $500


Click here to put this ticker on your own site and/or get live RSS newsfeeds

Open Work Categories.
Database 
(186 open)
   Access 
(60 open)
   MySQL 
(114 open)
   Oracle 
(14 open)
   SQL Server 
(80 open)
   Other DB 
(23 open)
Documentation / Tech Writing 
(30 open)
   Language (Human) Translations 
(10 open)
Data Entry 
(32 open)
Game Development 
(20 open)
Graphics / Art / Music 
(64 open)
   Graphics 
(68 open)
     Adobe AfterEffects 
(12 open)
     Adobe Photoshop 
(32 open)
     Adobe Premiere 
(11 open)
     3d Animation 
(23 open)
   Art (Misc.) 
(17 open)
   Music 
(10 open)
   Photography 
(10 open)
   3d Modeling 
(14 open)
Language Specific 
(126 open)
   Assembly / Machine language 
(11 open)
   ASP 
(65 open)
   ASP .NET 
(70 open)
   C# 
(78 open)
   C++ / C 
(152 open)
   Carbon (Mac OS) 
(7 open)
   Cocoa / Obj-C 
(4 open)
   Cold Fusion 
(12 open)
   Delphi 
(57 open)
   Java 
(83 open)
   JSP 
(13 open)
   Perl 
(48 open)
   Python 
(5 open)
   PHP 
(116 open)
   XML/XSL 
(41 open)
   Visual Basic 
(177 open)
   Visual Basic .Net 
(121 open)
   Other 
(79 open)
Misc 
(38 open)
   Middleware 
(1 open)
   CAD 
(5 open)
MultiMedia 
(36 open)
   Video Editing 
(15 open)
Network 
(35 open)
   Network Design 
(6 open)
   Network Implementation 
(4 open)
Platforms 
(79 open)
   Windows 
(206 open)
     MS Exchange 
(7 open)
     MS Office 
(19 open)
     Other 
(9 open)
   Darwin 
(3 open)
   Embedded Systems 
(2 open)
   Hand Held/PDA Programming 
(13 open)
   Internet Browser 
(58 open)
   Linux 
(53 open)
   Lotus Notes / Domino 
(2 open)
   UNIX 
(26 open)
Requirements 
(15 open)
Security 
(31 open)
Testing / Quality Assurance 
(22 open)
Web 
(202 open)
   Page Design 
(93 open)
   Flash 
(50 open)
   Marketing 
(1 open)
   Web Services 
(90 open)
   Web (Other) 
(98 open)
Training 
(11 open)
   Computer Based 
(11 open)
Other
 
Other Sites

Download the free Rent A Coder IE toolbar!
 
Show Bid Request

VB6 data_report NOT using dataenvironment
Bid Request Id: 30047
Bookmark in my 'To Do' list
Posted by: infomed (37 ratings)
(Software buyer rating 10)
Non-action Ratio: Very Good - 14.81%
Buyer Security Verifications: Good
Approved on: Oct 6, 2002
5:01:04 PM EDT
Bidding Closes: Oct 20, 2002
5:13:00 PM EDT
Viewed (by coders): 175 times
Phase:
100% of work completed and accepted. Coder has been paid.
Max Accepted Bid: Bidding is closed
Project Type: Very Small Business Project: under $100 (USD)
Bidding Type: Open Auction
Categories: Database, Language Specific, Visual Basic
Enter chat room for this bid request
(0 active users at Sep 8, 2003 8:19:52 PM EDT)

Description:
I am looking for the code (short, sweet, and well commented) to take a recordset (see example below) and print out a data report. The report will contain some client information at the top (e.g, name, address, etc.) then the rest of the page is blank. The next page will have record #2. The page after that record #3 from the dataset, and so on. The number of pages is variable from 1 to 100 or more. (The record set essentially is a list of folks being pulled from a medical schedule database. All the clients (aka patients) who have appointments will need their address and insurance information placed on the top of a form. Getting the patient info on the page, and then moving to the next patient on the next page is what I need to accomplish here.)

I realize that using a detail window makes sense, but I need to do this all in code, and NOT linking fields to the dataenvironment. How do I do this not using controls, but rather via code alone.


Thanks.
Jon

P.S. given the number of times I've been told this can be done, and then the accepted bidder can't do it, I will only select a coder who sends me the code or demo up front. Thanks.


Here is the code that pulls the recordset:

Dim cnn1 As ADODB.Connection
Dim strQry As String
Dim rs As ADODB.Recordset

strQry = "Select * from Scheduling Where Scheduling.Date Like '" & p_ScheduleDate & "' Order By Scheduling.Date"

Set cnn1 = New ADODB.Connection
cnn1.ConnectionString = g_ADOschedule
cnn1.Open

Set rs = GetRecordSet(cnn1, strQry) 'get the recordset

With rs
While Not rs.EOF

'my code that pulls the user's name, etc. go here, and this I don't need help with. Just the code that gets each 'recordset to be displayed on a seperate page.

rs.MoveNext
Wend
End With


Set cnn1 = Nothing
Set rs = Nothing


Deliverables:
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.


2) Complete ownership and distribution copyrights to all work purchased.



Platform:
win


Remember that contacting the other party outside of the site (by email, phone, etc.) on all business projects < $500 (before the buyer's money is escrowed) is a violation of both the software buyer and seller agreements. We monitor all site activity for such violations and can instantly expel transgressers on the spot, so we thank you in advance for your cooperation. If you notice a violation please help out the site and report it. Thanks for your help.
 
Bidding/Comments:
All monetary amounts on the site are in United States dollars.
Rent a Coder is a closed auction, so coders can only see their own bids and comments. Buyers can view every posting made on their bid requests.

See all rejected bids (and all comments)
Name   Bid Amount 
 
Date   Coder Rating  
This bid was accepted by the buyer!
Peter Dimitrov
(1 ratings)
in Sofia, Bulgaria
Bulgaria
Bid id: 335,778
 
$10 (USD) Oct 6, 2002
6:10:41 PM EDT
 10
(Excellent)
   
Here is my example. I am not using array or Dataenvironment. Only ADODB.Recordset. There is only 20 lines of code (include sorting). You can generate more records in the database to see how the reports works with 1, 100 or 5000 records.

Regards
Peter
Attached File
 
 
 
 
  There are 4 private replies to/from Peter Dimitrov. Click here to view them.
 




Bid Request Search
 Advanced Search
Newest Open Work
Latest News  
Credentials


 

 
Rent A Coder upholds the rigorous business practices required to be both a BBB member and Square Trade vendor.
  • All customer issues addressed within 2 days
  • Openly disclosed pricing and return policies
  • Participation in mediation at buyer request
  • Superior selling track record
This site is verified through its parent company, Exhedra Solutions, Inc.
 
Top Coders.

Securenext
Rated a 9.97 on 120 jobs 
Buddies
Rated a 9.84 on 91 jobs 
Codman
Rated a 9.97 on 157 jobs 
Andrei Remenchuk
Rated a 10 on 14 jobs 
D-N-S
Rated a 9.93 on 38 jobs 
hernest
Rated a 10 on 121 jobs 
markesh
Rated a 10 on 22 jobs 
Maxnet Technologi es Private Limited
Rated a 9.93 on 84 jobs 
florentin
Rated a 10 on 56 jobs 
PSergei
Rated a 9.76 on 100 jobs 

See all top coders...

(What makes a top coder?)

Top Exam Scorers

 
Other
Rent A Coder is PayPal verified through its parent company, Exhedra Solutions, Inc.

Created in partnership with:

 

Affiliate Sites
Latest News | About Us | Kudos | Feedback/Contact    Affiliates | Advertise    Privacy | Legal

Copyright © 2001, Exhedra Solutions, Inc. All rights reserved.
By using this site you agree to its Terms and Conditions.
"Rent A Coder" (tm), "Safe Project Escrow" (tm) and "How Software Gets Done" (tm)
are trademarks of Exhedra Solutions, Inc.