Search results

  1. P

    Making one field distinct with a "where" clause?

    Hello. I'm making a database to store movie info for a DVD collection. I have a table with fields: title, year, runtime and such. I want an indefinite number of genre to be associated with a movie, so I created a "genre" table and a junction table between that and the "movie" table. Now, on form...
  2. P

    Testing whether any controls excluding one are dirty...

    Hello all. I have a form with many text box controls and a couple combo box controls. I would like to test whether any of the controls are dirty--except for one, which I know is dirty. I have tried using the Tag property of the one control to exclude it in a For Each loop where I test if...
  3. P

    Adding field values from different related tables...

    I have two tables: Items and Quotes. They are related through the field: Item_Number. I have the field Factory_Cost in the Items table which I want to add with the field Freight_Cost in the Quotes table. I want to display the Factory_Cost + Freight_Cost in the Quotes form. How do I do this? Thanks.
  4. P

    Combo box filter reset or all option?

    Hello all. I am a new member on this forum, working on my first Access project using Access XP and 2003. My problem: I have a form sourcing records from a table of "items." In that form you can search for items by item number in a combo box. And you can filter the list of item numbers by...
Back
Top Bottom