I have an existing MS access database.
I need to make the following modifications.
1) I have a donor form. below the donor form there is a sub-form which brings up a list of donations that were made. I need to start a new list of donations, but I still want to see the old donations. I think that this is a union query but I am not sure.
2) I need a new form to enter in donations. On the form, I need a button to push which will open up a report which in essence will be a receipt for that donation. The receipt can be either open into a mail-merged microsoft Word document, or a custom report. The point is that I want to hit one button that will open the receipt for that donation record. I then want the record to be marked that I already issued the receipt.
3) lastly, I want to be able to scan a cheque form my scanner and attach it easily as an olm (?) object on the donation record through the form mentioned above.
Please send me a quote for this work. I am looking to spend under $100.
I'm a seasoned MS Access developer; I can update any existing forms and add any type of enhancements/customized VBA code. I'm ready to start working with you.