How Software Gets Done  


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
My Affiliate Account
Affiliate help
Affiliate FAQ
Latest news
Newest Bid Requests.
(See all)
Flash Interface for MySQL Report Builder
By g8z on Sep 11
Max Bid: $1,800

Transfer data over phone line
By Aboka on Sep 10
Max Bid: Open to fair suggestions

Remote PC Access Software Product
By jajaman on Sep 10
Max Bid: Open to fair suggestions

Java Database Developer
By bbase on Sep 9
Max Bid: $1,000

Add 'table maker' option to online WYSIWYG Editor
By christopher_bra gg on Sep 10
Max Bid: $35

(Screen Shot)

Clone of the Web Administration Panel of the Web Q ...
By Sarder Hasnut [Microsoft Certified Solution Developer] on Sep 10
Max Bid: Open to fair suggestions

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

Open Work Categories.
(173 open)
(60 open)
(97 open)
(11 open)
   SQL Server 
(70 open)
   Other DB 
(21 open)
Documentation / Tech Writing 
(25 open)
   Language (Human) Translations 
(10 open)
Data Entry 
(34 open)
Game Development 
(13 open)
Graphics / Art / Music 
(49 open)
(61 open)
     Adobe AfterEffects 
(7 open)
     Adobe Photoshop 
(25 open)
     Adobe Premiere 
(6 open)
     3d Animation 
(21 open)
   Art (Misc.) 
(10 open)
(8 open)
(6 open)
   3d Modeling 
(14 open)
Language Specific 
(128 open)
   Assembly / Machine language 
(9 open)
(64 open)
   ASP .NET 
(69 open)
(72 open)
   C++ / C 
(136 open)
   Carbon (Mac OS) 
(4 open)
   Cocoa / Obj-C 
(3 open)
   Cold Fusion 
(15 open)
(48 open)
(83 open)
(14 open)
(42 open)
(5 open)
(107 open)
(34 open)
   Visual Basic 
(171 open)
   Visual Basic .Net 
(111 open)
(73 open)
(34 open)
(1 open)
(5 open)
(31 open)
   Video Editing 
(11 open)
(33 open)
   Network Design 
(5 open)
   Network Implementation 
(4 open)
(71 open)
(191 open)
     MS Exchange 
(7 open)
     MS Office 
(17 open)
(10 open)
(2 open)
   Embedded Systems 
(3 open)
   Hand Held/PDA Programming 
(11 open)
   Internet Browser 
(56 open)
(52 open)
   Lotus Notes / Domino 
(1 open)
(24 open)
(14 open)
(26 open)
Testing / Quality Assurance 
(17 open)
(186 open)
   Page Design 
(87 open)
(53 open)
(3 open)
     Search Engine Optimization 
(1 open)
     Marketing (Other) 
(1 open)
   Web Services 
(86 open)
   Web (Other) 
(95 open)
(10 open)
   Computer Based 
(8 open)
Other Sites

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

Quick MS Access Help Needed
Bid Request Id: 29938
Bookmark in my 'To Do' list
Posted by: Wampy1 (39 ratings)
(Software buyer rating 10)
Non-action Ratio: Above Average - 29.31%
Buyer Security Verifications: Excellent
Approved on: Oct 5, 2002
5:15:41 PM EDT
Bidding Closes: Oct 19, 2002
5:22:07 PM EDT
Viewed (by coders): 151 times
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, Visual Basic
Enter chat room for this bid request
(0 active users at Sep 11, 2003 2:21:08 AM EDT)

I need a coder to write a Module and Query in MS Access 2000 that will take a field and depending on its content modify it, removing extra charactors within the field.

Here is a list of some samples of the fields now:
3 Certificates 7.49; C1 Bastard Boss 0.00 7.49; C2 Bitch Of the Year 0.00 7.49; C3 Ass Kisser 0.00

3 Gift Certs 2.99; Gift Cert # 1 Dr.Kervorkian 0.00 2.99; Gift Cert # 2 One Nation Under God 0.00 2.99; Gift Cert # 3 Martha Stewart 0.00

Smasher Combo - 21.89; Smasher # 1 BaseBall 0.00 21.89; Smasher # 2 Golf Ball 0.00

3 B-Stickers - 4.89; Bumper Sticker # 1 Hang Up and Drive 0.00 4.89; Bumper Sticker # 2 PETA 0.00 4.89; Bumper Sticker # 3 My Kid Kicked The Crap 0.00

3Weenies- 34.67; Weenie Baby # 1 PEPE The Pig 0.00 34.67; Weenie Baby # 2 DING A LING LING the Panda 0.00 34.67; Weenie Baby # 3 ICE PUBE the Polar Bear 0.00

3 Prank Envelopes 4.29; Envelope # 1 HotDogs are Great 0.00 4.29; Envelope #2 Ring My Telephone 0.00 4.29; Envelope # 3 Summer Is Not Winter 0.00

Combo - 3 Pack of Magnetic Gag Signs 9.49; Bumper Gag # 1 Ring My Bell 0.00 9.49; Bumper Gag # 2 I eat Taco Salad 0.00 9.49; Bumper Gag # 3 Young and The Wrestless 0.00

Here is how I would like them to appear :

3 Certificates - Bastard Boss, Bitch of The Year, Ass Kisser

3 Gift Certficates - Dr. Kervorkian, One Nation Under God, Martha Stewart

Smasher Combo - BaseBall, Golf Ball

3 B-Stickers - Hang Up and Drive, Peta, My Kid Kicked The Crap

3 Weenies - PEPE The Pig, DING A LING the Panda, ICE PUBE The Polar

3 Prank Envelopes - Hot Dogs are Great, Ring My Telephone, Summer is Not Winter

Combo - 3 Pack of Magnetic Gag Signs - Ring My Bell, I Eat Taco Salad, Young and The Wrestless

As you can see it appears a ; seperates the fields, but I want all the 0.00 and 7.49's etc removed.

You can not hard code the 3 options as they will change. For instance in the last example, there are 10 different Magnetic Bumper Signs that could be listed, but only 3 at any one time.

I would like a working query and the code for the module.

I need as soon as possible.

First bidder to bid with working a working sample wins the project. You can see by my feedback, I am an honest buyer.

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

2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request.

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

Access 2000

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.
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!
(22 ratings)
in Toronto, Ontario
Bid id: 334,940
$10 (USD) Oct 5, 2002
7:59:08 PM EDT
(Above Average)
Hey This is a simple VBA script. Let me know I can finish it in 1 hour. Let me know.

Bid Request 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.
Top Coders.

Rated a 9.97 on 120 jobs 
Rated a 9.84 on 91 jobs 
Rated a 9.97 on 158 jobs 
Andrei Remenchuk
Rated a 10 on 14 jobs 
Rated a 9.93 on 39 jobs 
Rated a 10 on 121 jobs 
Rated a 10 on 22 jobs 
Maxnet Technologi es Private Limited
Rated a 9.93 on 84 jobs 
Rated a 10 on 56 jobs 
Rated a 9.76 on 102 jobs 

See all top coders...

(What makes a top coder?)

Top Exam Scorers

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.