Show Bid Request
Custom Access Database using VBA
Bid Request Id: 16453
|
|
|
|
Posted by: |
benboul (7 ratings)
(Software buyer rating 10)
|
|
Non-action Ratio: |
Very Good - 0.00%
|
Buyer Security Verifications: |
Excellent
|
|
Approved on: |
May 15, 2002
5:25:53 PM EDT
|
|
Bidding Closes: |
May 29, 2002
5:30:40 PM EDT
|
|
Viewed (by coders): |
528 times
|
|
Deadline: |
6/1/2003
TIME EXPIRED
|
|
|
|
|
Description:
I need a Microsoft Access/VBA programmer to create an Access application for tracking Supplier Request For Quotations (RFQ&'s). The database must be for multiple users and a user must have the ability to automatically create Microsoft Word or Excel Spreadsheets (I will provide the templates) from the information he or she inputs into the database.
A user must be able to do the following once he or she logs in:
I. Create Procurement Package:
b. The user will be able to enter information concerning the Request For Quotation. Some of the fields will be Project, Inquiry Number, Inquiry Description, Field Need Date… etc (Parent Table(s)).
c. The user should also be able to enter the individual line items for the Inquiry. It is not important to track pricing, but line numbers, tag or part numbers, description and qty must be stored (Child Table(s)).
d. The user will be able to enter the supplier he or she wants to send the RFQ too. This information will consist of Supplier Name, Street Address, Phone, Fax, Contact Name (Child Table(s)).
By using the information a user enters for the Procurement Package the user will need to the ability to create the following documents through VBA automation. The form will provided:
I. Create Bidders List (Word Documents)
a. Send email Requesting Supplier be added to Bidders list.
II. Create Request For Quote (Word Document)
III. Create Commercial Bid Form (Word Document)
IV. Commercial Bid Tab (Excel Spreadsheet)
V. Notification of Award (Word Document)
Once the documents are created he or she needs the ability to save the files with a default name and default address which is set-up when a users profile to log on is created. I would also like the ability to email the files.
II. View His or her own procurement Packages and export to Excel or view all procurement packages created in systems.
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.
Platform:
Windows N, Access 2000 or 97, Word,Excel 97, 2000.
Must be 100% finished and received by buyer on:
Jun 1, 2003 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.
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!
|
$40 (USD)
|
May 17, 2002
5:22:05 AM EDT
|
9.24
(Superb)
|
|
|
I worked with VBA for all Office applications (please have a look at my resume and my pas bids) and I think there will be no problems with it.
Is the bid amount OK?
Endre |
|
|
|
|
|
|