Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Wease
  • Content: Threads
  • Order by date
  1. Wease

    multiple sorts on different variables within a report

    I'm trying to create a report that sorts on three different date fields by month. I'm creating a membership database where members could pay for their membership, campsite & building permits at three different times. The database keeps three different date fields for each payment type. I want...
  2. Wease

    Compare entered data to data in table and present Msg Box

    I've created a membership database, and I have a list of people who have been banned from membership. I want my users to be aware when they are entering a member name that they may be entering an individual who has been banned. My idea is to create a new table called "banned" with the first...
  3. Wease

    Where does Outlook store email history and address book?

    I recently bought a new PC, and removed the HD from my old PC. I hooked the old HD up to my new PC as a secondary drive so that I can copy my old files onto my new PC. I was hoping I could import my existing Outlook email (history, saved mail, etc) and address book from the old HD into my...
  4. Wease

    Sum a static amount?

    In a report I've created a text box with a data source of =200. So for all records the text box will always contain 200 and it's formated as currency. I want to create a text box in the footer that totals all the $200.00 entries? Can someone tell me how to do this? I can't figure how to...
  5. Wease

    Check one or the other, how do I set this up?

    I'm an Access newbie, so please bear with me. I have two check boxes (Single Membership & Family Membership). I only want one to be checked for a given individual. If one is checked the other must remain unchechecked. Can someone tell me how to do this? Also, upon checking one of these...
  6. Wease

    Return Datbase Record Number in Query ?

    I have a database that stores Membership Numbers, and I have a query that a user can search for a member by their membership number. Is there a way my query can return the Record Number for that member in the database ?
  7. Wease

    Queries on multiple fields or only updated fields ?

    I am trying to develop a "Search" function for my database that is accomplished by a Query. I have created 3 unbound text boxes that the Query will run from. For example, I have a "Member Number" text box, a "Member Last Name" text box and a "Vehicle...
  8. Wease

    How do I write a Record / Row specific query ?

    In my form I have Make & Model combo boxes. What I want to have happen is when a user selects a make (i.e. Honda or Yamaha), the model combo box will list only models associated with the Make selected. I have built a table called Make_Model that lists all the combinations of makes and models...

Part and Inventory Search

Back
Top