Search results

  1. W

    Cascading Combobox based on TWO "WHEREs?

    I want a combobox based on the value of two other comboboxes but I am not sure how to write it in VB. I would have though something like: Private Sub cboT_AfterUpdate() On Error Resume Next cboC.RowSource = "Select DISTINCT tblCables.C " & _ "FROM tblCables " & _ "WHERE tblCables.T = '" &...
  2. W

    Using a checkbox to get a value from a table.

    Hi all, I want to use a combination of two checkboxes to retrieve a value from a table however that table is quite complex. My table consists of four fields: 'Flower', 'NumberofFlowers', 'Weight1' and 'Weight2'. E.g. Select type of flower in combobox, and then the number of flowers...
  3. W

    Question Generate info from form selections?

    I want to create a form with cascading combo boxes ... but I want to generate coes from this e.g. E.g. Drop Down 1 Meat Vegitables Drop Down 2 (when meat has been selected in 1) Beef Lamb Pork or Drop Down 2 (when veg. has been selected) Carrot Pea I have done that with cascading...
  4. W

    Multiple Drown Down Boxes

    Hi, I want to use a drop down list containing one value, and depending upon this value I want my next dropdown box to only display certain options. Is this possible? E.g. Drop Down 1 Meat Vegitables Drop Down 2 (when meat has been selected in 1) Beef Lamb Pork or Drop Down 2...
  5. W

    Input Mask

    Hi there, Really simple one (but I'm new to Access!). Just trying to have a look about before I start some serious training. I am trying to make a mark for a UK post code field. Post codes in the UK can either be XX1 1XX or XX11 1XX Where: X = Letter 1 = Number. I was just...
Back
Top Bottom