Show Bid Request
Split a Table in Access db into Many Tables
Bid Request Id: 61113
|
|
|
|
Posted by: |
melyas (17 ratings)
(Software buyer rating 10 )
|
|
Non-action Ratio: |
Very Good - 21.62%
|
Buyer Security Verifications: |
Good
|
|
Approved on: |
May 3, 2003
1:13:37 AM EDT
|
|
Bidding Closes: |
May 15, 2003
1:12:08 PM EDT
|
|
Viewed (by coders): |
249 times
|
|
Deadline: |
5/16/2003 1:12:08 AM
TIME EXPIRED
|
|
|
|
|
Description:
1. Select ANY Access db in ANY format with ANY fields and field names.
2. Select table or query within that db
3. If query is selected and needs input boxes, prompt user for that information.
4. Prompt user for the number of records per output table, (default value should be 500)
5. Create a new Access db. Allow the user to select the path of the access db.
6. Split the selected table into many smaller tables. Each table should contain no more than the “number of records per table” value entered previously. Create the new tables within the new db that contains no more than the “number of records per table” value entered previously. For example if source table has 2200 records then you should have 4 target tables that contain 500 records each and one target table that contains 200 records, ALL within ONE Access database.
7. Name the TARGET tables them as such:
tblOld_Table_Name_r1_to_r500 and tblOld_Table_Name_r501_to_r1000 and so on ….
tblOld_Table_Name = is the table name of the source db
r501_to_r1000 = is the record numbers in this table
8. Give a quick report that contains the procedure and save a record of that in the log with time, date, and the rest of the info. Everytime the app is run just append to this log file.
9. At this time I want to make this an exe file that runs by itself. However, I will later need to use this as a procedure that will have this as one of its sub routines.
10. Must be done in Visual Basic 6.0 and must run on WIN 98
Deliverables:
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.
Platform:
WIN 98
VISUAL BASIC
ACCESS
Must be 100% finished and received by buyer on:
May 16, 2003 1:12:08 AM EDT
Deadline legal notes: All times are expressed in the time zone of the site EDT (UT - 5). If the buyer omitted a time, then the deadline is 11:59:59 PM EDT on the indicated date.
Additional Files:
This bid request includes IMPORTANT additional attached files. Please download and read fully before bidding.
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!
|
$25 (USD)
|
May 3, 2003
1:56:31 AM EDT
|
9.5
(Excellent)
|
|
|
Hello,
I'm experienced VB and MS Access coder. I already completed a lot of applications using VB 6.0 and MS Access 97/2000/2002 database as backend. Your project is very interesting for me, I really want do it and I would like to help you.
I can complete work for two days (as maximum, may be even more quickly), so you will receive application very fast. I can start immediately, so please accept my bid and your program will be at your computer very soon.
Best wishes,
Oleg.
|
|
|
|
|
|
|