Recent content by HickoryII

  1. H

    Transpose Vertical text values to Horizontal

    Thanks for all the input from everyone. I'm sure I'll be able to achieve the desired results with the references so helpfully provided; especially the one offered by Galaxiom. This is a wonderful forum for solving Access problems. :)
  2. H

    Transpose Vertical text values to Horizontal

    Right now they are all listed as simply Assistant in the "Description" column. I'm kind of new to this so if you could explain a little more fully exactly how I go about setting this up I'd be very grateful. Thanks:o
  3. H

    Transpose Vertical text values to Horizontal

    I have a Volunteer Database that has teams. There is only one team leader but some of the teams have two or three assistants. Currently I have a query that lists all the assistants for each team vertically. I've attached a picture of the query I'm using. What I want to do is list the Assistants...
  4. H

    Sync two combo boxes; Error 7777

    :) thanks so much (Beetle)Sean. It worked perfectly; and so simple. I told you I was new at this. I wanted to mark this thread as solved but don't know where or how to do it. Anyway thanks again. Bob (Hickory)
  5. H

    Sync two combo boxes; Error 7777

    Hi Beetle, Thanks for your input. Here's the rowsource for Combo208: SELECT DISTINCTROW [Main Volunteer List].[Volunteer Number], [Main Volunteer List].[Last Name], [Main Volunteer List].First, [Main Volunteer List].Middle FROM [Main Volunteer List] ORDER BY [Main Volunteer List].[Last Name]...
  6. H

    Sync two combo boxes; Error 7777

    This is my first post and I'm not an expert in Access nor VBA but I've solved a lot of problems in programming by using this forum. It's been a great help. I have an Access .mdb database of about 1300 volunteers. On my main volunteer form I have two unbound combo boxes that I use to select...
  7. H

    Auto fill values when checkbox selected

    I’m a beginner at Access and would like to know: Is there a way to automatically fill in specific values in a table or datasheet form when a form checkbox is selected?
Back
Top Bottom