MS access help

Add New Partnership Form AND Edit Partnership Form:

1) When user clicks “save record”, a confirmation box comes up which says something like “user has been saved successfully” HOWEVER it does not work in Access 2007. It only works in Access 2010. Please make it work in Access 2007!!!

2) Delete ‘Status” Field in ALL forms/tables/reports etc…

View Renewable Partnership:

1) When invoked, it should ask me how many number of months from expiry date (1 to infinity) (you did this before but it is not working now … not sure why)

· Once user enters number of months in step 1 (above), data should be generated in a REPORT

Switchboard:

1) When the “Search” function on the switchboard is invoked, it is going directly to “edit partnership”. The search function should allow me to search the entire database.

· Make sure results appear as a REPORT

2) View Renewable Partnerships Function: When this button is invoked by user, it should give me the option to view the renewable partnership BY

· “AGREEMENT TYPE” (User should be able to click Which agreement type they want to view (MOU, Student Exchange, Mobility Project, Conference etc…), make sure you list all of the agreement types

· AND by how many number of months from Expiry Date (1 month to infinity)

· Results should show up as REPORT