11/2/2010

I changed the scheme for check out. The receipts may now be printed in batch for those who have not payed. The Attendee Checkout form no longer queries for the bidder number. The navigation is done using the tools of the form such as record number or search function. When the form opens, the receipt is no longer automatically opened because the amount owed is now on listed on the form. If you need to generate a receipt at this point, there is a button to bring it up. 

I added a feature to create an attendee list for printout to the Excel database.

3/20/2009

I added logic to the Excel spreadsheet to spot duplicate item, donor, and attendee numbers. It will not accept entry of a duplicate number. If you paste a duplicate number, the cell will turn red.

I had the catalog and the bid sheet files mixed up under the Excel and Access versions mixed up that

3/19/2009

Minor "cleaning and polishing." I added a min bid to the database. It only shows up in the Word version of the bid sheets as a first bid. I fixed a pagination issue with the Excel checkout page. I seperated the Bid Sheet and Catalog into Access and Excel versions.

3/14/2009

I fixed the sorting of the catelog.

3/9/2009

Added payment type and added report for list of winners without prices.

3/2/2009

I updated the instructions. The big point of emphasis is that a full version of Access is needed on each computer when networking them together.

5/30/2008

I updated the Excel sheets. I have turned protection on and hidden some of my columns. The idea is to make them more ready to use. I also fixed a potential lookup error in one of the sheets.

If you want to look at what I have done or make modifications, you can still turn off protection using Tools->Protection->Unprotect sheet. You can also unhide any columns. The idea of protections is to prevent you from accidentally erasing a formula.

4/5/2008

I tweaked the database in that I added another optional form for Who bought what. I also changed the documentation to a Word or Adobe Acrobat file.

3/31/2008

I changed the field names on the database and the column names on the Excel workbook to be consistent to allow the same fields to be used for the Microsoft Word catalog and bid sheets.