Show Bid Request Fix Recurring appts Bid Request Id: 56752 Bookmark in my 'To Do' list Posted by: Jamie GGG (30 ratings) (Software buyer rating 10) Non-action Ratio: Very Good - 17.95% Buyer Security Verifications: Excellent Approved on: Apr 8, 2003 7:53:23 AM EDT Bidding Closes: Apr 9, 2003 9:52:01 AM EDT Viewed (by coders): 32 times Deadline: 4/9/2003 11:51:07 PM TIME EXPIRED Phase: 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, Language Specific, Visual Basic Enter chat room for this bid request (0 active users at Jul 16, 2003 2:05:01 AM EDT) Description: I had a coder do this work for me back in January. A function was created for an appointment screen which would stop users from overwriting or overlapping appointments when recurring appointments are made. It works sometimes, but sometimes it doesn't catch the other appointment blocks. Start time-end time etc. Other coder is busy with other projects and I need this ASAP! Please review how it all functions and make any necessary changes to it. This function is very important to the program. I can delete records and add future appts as expected. It just the protection for overwrites and overlapping of appts that is a problem. Problem:2 items 1.I have added future appointments on 4/14/03. Assume that these appointments are made one by one by double clicking the cell on the grid and adding a customer, and were not created using the "recurring" feature. (People will often call a salon by phone, and make their appointments in two weeks etc. So a salon will book not only recurring appointments when the customer is in the salon, but single appointments for sometime in the future.) Now go back to 4/7/03 and make an appointment for 10:30 am for some customer using the recurring feature and add this recurring appt for say the next 4 weeks into the future. It allows the appointment to be made, even though there is already an appointment on 4/14/03 from 10am through 11 am. 2.Also for example, on the 4/14/03 the cell from 12:00 to 12:15 is open as no appt was made there. But if you were to go to 4/7/03 and book a recurring appt for 12:00 for color which is a 60 min appt, it overwrites and overlaps on the 4/14/03 appt for 12:30 It didn't allow me to make a recurring appt at 9am, yet as I continued to try to add more recurring appts down the column, it began to allow the overwrite of the appointments. Sometimes it seems to find the overlapping or pre exisiting appointment, and sometimes it doesn't. I thought that this only happened when the user would continually add recurring appointments while the frmappointment form was opened. However, it seems to occur without any real reason that I can see. I thought that on the initial load of the appt screen that this didn't happen, but it does on the initial load of the screen as well. Deliverables: 1) Complete and fully-functional working program(s) and complete source code of all work done. 2) Complete ownership and distribution copyrights to all work purchased. Platform: vb6 windows ME/98/XP Must be 100% finished and received by buyer on: Apr 9, 2003 11:51:07 PM 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! D Lee (3 ratings) in Boondall, QLD Australia Bid id: 610,079   $15 (USD) Apr 8, 2003 8:13:07 AM EDT  10 (Excellent)     Hi, Send me the VB 6 source and I will fix it. This should be either today or tomorrow as I am not available after that. Thanks, Dennis Ps. I will keep you informed of my progress during the course of the project.           See 2 private reply(ies) to/from D Lee.