Search results

  1. L

    Auction Database Report

    Auction Database Report showing like items only once. I have a auction databse for a small scholl. They have multiples of some items. What I would like to do in the main report that is going in a program is to have the multiple items just be listed once with all of the item numbers for it...
  2. L

    Assigning a range of numbers to a Category

    I am working on a small database for a school to track their live and silent auction. Currently I have a table set up as follows. Silent Auction table : Item Number Short Item Description Long Item Description there are more fields that I am not interested in right now. Mainly what I am...
  3. L

    Combo and list box help

    I have a small database to track childrens books for a Preschool. I am keeping the database as simple as possible for the director. I have 3 tables Book_Information Authors Book_Category I have relationships established and a form for them to enter data easily into. I used the OnNotInList code...
  4. L

    Totally Confused, OnNotInList, DAO or ADO

    I am totally confused. I have read many posts regarding the subjects above. I am using Access 2000 and have tried much of the code posted here to get OnNotInList to work. I keep getting errors and now I am lost. Please help. Thanks in advance.
  5. L

    Append current record on Form to another table

    I have a table lead_information and a table sold_jobs. I want to put a sold button on the form for lead_information. I want the sold button to append the current record to the sold_jobs table. The fields in each table are the same except for the sold_jobs table has fields that the...
  6. L

    Append current record on Form to another table

    I have a table lead_information and a table sold_jobs. I want to put a sold button on the form for lead_information. I want the sold button to append the current record to the sold_jobs table. The fields in each table are the same except for the sold_jobs table has fields that the...
  7. L

    Printing a single record from a form in report format

    I would like to add a button to my form that will print the active record in a report format. I am somewhat a rookie in working with Access so any help would be appreciated. Lee
Back
Top Bottom