Show Bid Request
Time Sheets
Bid Request Id: 37084
|
|
|
|
Posted by: |
tcsgreg (3 ratings)
(Software buyer rating 10 )
|
|
Non-action Ratio: |
Very Good - 0.00%
|
|
Posted: |
Nov 25, 2002
9:15:51 PM EDT
|
|
Bidding Closes: |
Dec 2, 2002
9:44:00 PM EDT
|
|
Viewed (by coders): |
247 times
|
|
Deadline: |
12/9/2002
TIME EXPIRED
|
|
|
|
|
Description:
Visual Basic Procedure for Microsoft Access 2000.
List Box that lists dates 4 weeks prior to and 4 weeks after todays date in one week increments (This part of the code is attached).
I don't know how to compare non-table/query data to table data using Visual Basic. In fact, I dont know much about Visual Basic.
Deliverables:
Revised Explanation.
The attached database contains a list box not bound to any Table/Query. It simply lists the dates for 4 Fridays previous to the current date and 4 Fridays after the current date. I want to compare the dates in the List Box to my table (Time Sheets) and exclude dates from the list box that appear in the table. The Criteria for the lookup in the table would be the EmployeeID.
Example: Today's date is 11/21/2002
List Box Results would be (as the code is now):
11/01/2002
11/08/2002
11/15/2002
11/22/2002
11/29/2002
12/06/2002
12/13/2002
12/20/2002
For a record with an EmployeeID of 1 in the "Time Sheets" tablethe following records may already exist:
WeekEnding
11/01/2002
11/08/2002
11/15/2002
List Box Results should be (the code I am looking for):
11/22/2002
11/29/2002
12/06/2002
12/13/2002
12/20/2002
I would like those 3 dates (WeekEnding) to not appear in the List Box.Somehow the dates in my existing code would have to be compared to the data in the "Time Sheets" table based on the EmployeeID which
will be used on a form.
Platform:
Microsoft Access 2000
Must be 100% finished and received by buyer on:
Dec 9, 2002 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!
|
$13 (USD)
|
Nov 26, 2002
1:45:08 AM EDT
|
10
(Excellent)
|
|
|
Hello,
I attached the file with your problem solved.
The combo box has now the row source type 'Value List' and the values are built on the fly when you enter an employee number.
Hope you accept my bid.
Best regards,
Daniel Vlas
|
|
|
Attached File
|
|
|
|
|
|
