Search results

  1. A

    Filtered Query

    Try this. I retained some sample data.
  2. A

    Filtered Query

    Nope. I get this error. I'm going to try cutting and pasting into another query too. This one was built as a Union Query and maybe the program doesn't expect the ANDs. EDIT: Cutting and pasting into a new query didn't work either. If someone with a more critical eye than myself can point...
  3. A

    Filtered Query

    It's a Union Query, so each set of statements is separated by UNION. I think I tried replacing UNION with AND, but got an error. Here is the text of the query.
  4. A

    Filtered Query

    I am very new to Access, and I am having a lot of trouble figuring out how to get a query I want created. I was able to create a query which prompts the user for input in four different fields and searches based on those entered keywords, however the query returns records that have any of...
  5. A

    Auto Populate Form Controls from Form List Box selection

    That's not going to work. The db is currently 20MB zipped. File size restrictions here are under 1MB for ZIPs.
  6. A

    Auto Populate Form Controls from Form List Box selection

    This doesn't appear to be working. I am uploading what I have on the Form Design screen in a jpeg. I want the highlighted controls to auto-populate with values from the SetNames table when a value is selected in the SetName list.
  7. A

    Auto Populate Form Controls from Form List Box selection

    That's alright. It is entirely possible that I am being dense. Does this mean I have to remove the list box control I already created, add the controls for the other two values, and then recreate the list box as you have explained? I'll give it a try on a copy of the database. Thanks again.
  8. A

    Auto Populate Form Controls from Form List Box selection

    Thank you for your response, but I think you misunderstood my request. I have a list box control on the form already pulling the list from a column in the SetNames table, and storing the selected value in the SetName field for each record in the Miniatures table. That much was easy. What I am...
  9. A

    Auto Populate Form Controls from Form List Box selection

    Nothing yet? Bump.
  10. A

    Auto Populate Form Controls from Form List Box selection

    I am a very green Access user and am trying to create a database for tracking a plastic miniatures collection. I have already looked through the forums and frankly the responses to similar topics have been above my head. Feel free to address me like a child. :) The structure I have is two...
View older results
Back
Top Bottom