Devam Ediyor

Enhancements to MS Access database

Requirements

Program Name: [url removed, login to view]

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:

[url removed, login to view] Access program with VBA logic

Seperate document indicating where the new source is located in the [url removed, login to view] program. Also, the document will include the source code.

Once we're satisifed with the program we will pay $[url removed, login to view] US dollars.

Beceriler: Visual Basic

Daha fazlasını görün: value city, vba error, end vba, vba compare, summary table, mm, mdb, access points, 2010 access, access vba program, added database, visual basic entry form, access summary, code database access, check compare, vba code compare, city state zip database, access database check, access database requirement, access vba 2010, hide code, access database code, name card entry, database vba, vba user form

İşveren Hakkında:
( 8 değerlendirme ) Camas, United States

Proje NO: #733458

Seçilen:

grtsolutions

Hi, how are you? Please, see PM.

0 gün içinde 125$ USD
(2 Değerlendirme)
2.7

4 freelancer bu iş için ortalamada 119$ teklif veriyor

schandraram

Hello - My bid is to create the VBA code within the supplied database. Thank you. Chandra Ram

in 0 gün içinde125$ USD
(55 Değerlendirme)
5.9
nukecoder

Expert ACCESS Developer. I can do it perfectly. Please check PM. Thanks

in 2 gün içinde100$ USD
(0 Değerlendirme)
0.0
heavyworker

ready to go,

in 2 gün içinde125$ USD
(0 Değerlendirme)
0.0