Enhancements to MS Access database

Requirements Program Name: [login to view URL] Tables: US & EA Forms: EA Payment Entry US Payment Entry Summary: The EA Payment Entry and US Payment Entry forms are identical. Each form points to a seperate table (ex. EA Payment Entry points to the EA table, US Payment Entry points to the US table). Each form will be need to have the identical VBA code added. The following is the requirements: Field Name Requirement Post_Dated Default value = “No” Processing_Date If Processing_Date = “No” then Processing_Date = current date mm/dd/yyy. If Processing_Date=”Yes” then compare the Processing_Date to the current date. If the number of days is more than 7 days, then pop-up error message = “Date more than 7 days”. Allow the end-user to enter a new date. P-First_Name If Payees = “Same As Above” then P-First_Name = C- First_Name P-Last_Name If Payees = “Same As Above” then P-Last_Name = Last_Name P-Address If Payees = “Same As Above” then P-Address=Address P-City If Payees = “Same As Above” then P-City = City P-State If Payees = “Same As Above” then P-State = State P-Zip If Payees = “Same As Above” then P-Zip = Zip Routing_Number If Payment_Method = “Card” then hide Routing_Number field Account_Number If Payment_Method = “Card” then hide Account_Number field Check_Number If Payment_Method = “Card” then hide Check_Number field Check_Amount If Payment_Method = “Card” then hide Check_Amount field Card_Type If Payment_Method = “Check” then hide Card_Type field Experation_Date If Payment_Method = “Check” then hide Experation_Date field Card_Amount If Payment_Method = “Check” then hide Card_Amount field Deliverables: [login to view URL] Access program with VBA logic Seperate document indicating where the new source is located in the [login to view URL] program. Also, the document will include the source code. Once we're satisifed with the program we will pay $125.00 US dollars.