How Software Gets Done  

(No Login on Secured Page)

Custom Software Buyers
Request new bids
Search Coders
My Account
My Buyer 'To Do' List
My bid requests
  My escrow account
My General Info
Help for Buyers
Articles for Buyers
Latest News

Custom Software Coders

Newest open work
Browse all work
Search all work
My Account
My Coder 'To Do' List
My bids
My General Info
  My credit account
Help for Coders
Articles for Coders
Latest News


My account
My pipeline
My credit account
Help for Affiliates
Latest News
Newest Open Bid Requests.
Web Marketing
By blong24 on Jan 20
Max Bid: $500

By xswiss on Jan 20
Max Bid: $4,000

Commercial Management 1
By groovy_alexia on Jan 20
Max Bid: $100

analysis,design and implementation of a database a ...
By angelniki_07 on Jan 20
Max Bid: Open to fair suggestions

Java Applet for Mac (NDA)
By Napo on Jan 20
Max Bid: $500

Kazaa Protocol Project
By SrProjectManage r on Jan 20
Max Bid: Open to fair suggestions

Click here to put this ticker on your own site

Open Work Categories.
(136 open)
(49 open)
(74 open)
(8 open)
   SQL Server 
(56 open)
   Other DB 
(18 open)
Documentation / Tech Writing 
(23 open)
Game Development 
(22 open)
Graphics / Art / Music 
(50 open)
(59 open)
     3d Animation 
(13 open)
   Art (Misc.) 
(20 open)
(6 open)
   3d Modeling 
(12 open)
Language Specific 
(90 open)
(70 open)
(34 open)
   C++ / C 
(103 open)
   Cold Fusion 
(4 open)
(34 open)
(48 open)
(28 open)
(80 open)
(31 open)
   Visual Basic 
(165 open)
   Visual Basic .Net 
(62 open)
(45 open)
(37 open)
(8 open)
(25 open)
(32 open)
   Network Design 
(13 open)
   Network Implementation 
(13 open)
(61 open)
(133 open)
     MS Exchange 
(4 open)
     MS Office 
(1 open)
(8 open)
   Internet Browser 
(51 open)
(41 open)
(21 open)
   Hand Held/PDA Programming 
(15 open)
(10 open)
(24 open)
Testing / Quality Assurance 
(11 open)
(131 open)
   Page Design 
(65 open)
(33 open)
   Web Services 
(57 open)
   Web (Other) 
(56 open)
(5 open)
   Computer Based 
(6 open)
Other Sites

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

Bid Request Id: 6169
Bookmark in my 'To Do' list
Posted by: Uksoftware (2 ratings)
(Software buyer rating 9.5)
Posted: Dec 7, 2001
1:17:07 PM EDT
Bidding Closes: Dec 21, 2001
1:17:54 PM EDT
Viewed (by coders): 120 times
100% of work was accepted by buyer. Coder account has been credited.
Max Accepted Bid: Bidding is closed
Project Type: Personal Project / Homework Help
Bidding Type: Open Auction
Categories: Visual Basic
Enter chat room for this bid request
(0 active users at Jan 20, 2003 3:44:40 PM EDT)

I am looking for some code i am using an adoc1 control to the access database and the query code is below what i am looking for is if no results are found to disply a message box no plans

Private Sub BuildSearchSQL()

Dim sSQL As String

' We will look the Combo1.ListIndex for building the SQL
If Combo1.ListIndex = Combo1.ListCount - 1 Then
' "All Plans"
sSQL = "SELECT * FROM Plans"
ElseIf Combo1.ListIndex = 0 Then
' Nothing selected get lost from here
Exit Sub
ElseIf Combo1.ListIndex = 1 Then
sSQL = "SELECT * FROM Plans WHERE (Type= 'Fixed')"
ElseIf Combo1.ListIndex = 2 Then
sSQL = "SELECT * FROM Plans WHERE (Type= 'Discount')"
ElseIf Combo1.ListIndex = 3 Then
sSQL = "SELECT * FROM Plans WHERE (Type= 'Variable')"
ElseIf Combo1.ListIndex = 4 Then
sSQL = "SELECT * FROM Plans WHERE (Type= 'Fixed' OR Type = 'Discount')"
ElseIf Combo1.ListIndex = 5 Then
sSQL = "SELECT * FROM Plans WHERE (Type= 'Variable' OR Type = 'Discount')"
ElseIf Combo1.ListIndex = 6 Then
sSQL = "SELECT * FROM Plans WHERE (Type= 'Variable' OR Type = 'Fixed')"
ElseIf Combo1.ListIndex = 6 Then
' if u add any thing else in the combo box
' please add the SQL
End If

' Now initialise the form and show the form
' this is how one shoulf pas the data to the form
' Also you can define publice variable in the form and pass the
' data with formname.variablename
' But the approch shown below is more convient and professional

Form20.InitFormWithData sSQL

Hope some one can help with this for me.

Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. Complete copyrights to all work purchased.

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, you can report it to:
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!
(14 ratings)
in Pomona, California
United States
$5 (USD) Dec 7, 2001
3:23:01 PM EDT
I produce quality work that will far exceed what you pay for. Mosly I just like the challenge of some of these projects and they're alot of fun. Doing this gives me a nice break from some of the more serious coding I do. I hope you accept my bid, you won't be disapointed.

All source code is fully commented.

  See 1 private reply(ies)
to/from Timothy.

Quick Search

 Advanced Search
Newest Open Work
Latest News



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.

Rent A Coder Top Coders.

Anuj Gakhar
Rated a 9.98 on 75 jobs 
Michael Sharp
Rated a 9.97 on 147 jobs 
Simon Price
Rated a 10 on 6 jobs 
Rated a 9.9 on 26 jobs 
Rated a 9.97 on 51 jobs 
Andrei Remenchuk
Rated a 10 on 9 jobs 
Rated a 9.93 on 59 jobs 
Rated a 9.8 on 48 jobs 
Rated a 9.96 on 97 jobs 
Rated a 9.65 on 35 jobs 

See all top coders...

(What makes a top coder?)

Top Exam Scorers
Rent A Coder is PayPal verified through it's 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.