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
 

Affiliates

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


DVD COPIER CLONE
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.
Database 
(136 open)
   Access 
(49 open)
   MySQL 
(74 open)
   Oracle 
(8 open)
   SQL Server 
(56 open)
   Other DB 
(18 open)
Documentation / Tech Writing 
(23 open)
Game Development 
(22 open)
Graphics / Art / Music 
(50 open)
   Graphics 
(59 open)
     3d Animation 
(13 open)
   Art (Misc.) 
(20 open)
   Music 
(6 open)
   3d Modeling 
(12 open)
Language Specific 
(90 open)
   ASP 
(70 open)
   C# 
(34 open)
   C++ / C 
(103 open)
   Cold Fusion 
(4 open)
   Delphi 
(34 open)
   Java 
(48 open)
   Perl 
(28 open)
   PHP 
(80 open)
   XML/XSL 
(31 open)
   Visual Basic 
(165 open)
   Visual Basic .Net 
(62 open)
   Other 
(45 open)
Misc 
(37 open)
   CAD 
(8 open)
MultiMedia 
(25 open)
Network 
(32 open)
   Network Design 
(13 open)
   Network Implementation 
(13 open)
Platforms 
(61 open)
   Windows 
(133 open)
     MS Exchange 
(4 open)
     MS Office 
(1 open)
     Other 
(8 open)
   Internet Browser 
(51 open)
   Linux 
(41 open)
   UNIX 
(21 open)
   Hand Held/PDA Programming 
(15 open)
Requirements 
(10 open)
Security 
(24 open)
Testing / Quality Assurance 
(11 open)
Web 
(131 open)
   Page Design 
(65 open)
   Flash 
(33 open)
   Web Services 
(57 open)
   Web (Other) 
(56 open)
Training 
(5 open)
   Computer Based 
(6 open)
 
Other
 
Other Sites

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

Code
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
Phase:
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)

Description:
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
Form20.Show
Me.Hide

Hope some one can help with this for me.



Deliverables:
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: abuse@rentacoder.com.
 
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!
Timothy
(14 ratings)
in Pomona, California
United States
 
$5 (USD) Dec 7, 2001
3:23:01 PM EDT
 10
(Excellent)
   
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

 
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.
 

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 
RNA
Rated a 9.9 on 26 jobs 
Securenext
Rated a 9.97 on 51 jobs 
Andrei Remenchuk
Rated a 10 on 9 jobs 
teleCODERS
Rated a 9.93 on 59 jobs 
Buddies
Rated a 9.8 on 48 jobs 
Codman
Rated a 9.96 on 97 jobs 
ashben
Rated a 9.65 on 35 jobs 

See all top coders...

(What makes a top coder?)

Top Exam Scorers
 
Other
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.