Recent content by gswan

  1. G

    Using the IN operator with IIF in a query criteria

    That helped! Thanks for the info, it is now working!
  2. G

    Using the IN operator with IIF in a query criteria

    Here's what I've done, and it doesn't work, so I'm obviously not doing what you're suggesting - Column 1- Field: PositionID Criteria: LCase([Enter Y or N]) Column 2 Field: PositionID Criteria: (In (3,5,7,9) And "Y") Or: (In (2,4,6,8) And "N") The error message is - This expression is typed...
  3. G

    Using the IN operator with IIF in a query criteria

    Can you give more details? I don't understand what to do from what you've shown.
  4. G

    Using the IN operator with IIF in a query criteria

    I am trying to select specific records based on input in a query. This criteria currently works to select everything with an ID less than 21 or 31 based on the users entry: <IIf([Enter "Y" for List 1]="Y",21,31) I now need to change the query so that only certain records are selected based on...
  5. G

    Combobox Autoexpand Question

    Sorry about that John. I'm pretty new to Access and VERY new to Visual Basic. It took me quite a while to figure this out, but I believe I've got it. I'm posting the sample DB just in case it might help another user in the future. Thanks for you help!
  6. G

    Combobox Autoexpand Question

    I'm trying to get tblMembers.AddressID to update with the AddressID of the Member I choose in the Lookup/Combobox. Here's the code I've got in my Form. Option Compare Database Private Sub Text14_AfterUpdate() End Sub Private Sub Combo1_Change() 'Force Members combo to drop down when...
  7. G

    Combobox Autoexpand Question

    I think I see - it's this part, right? Private Sub Form_Current() 'set the Row source for the suburbs combo and requery and populate the postcode text box Me.Combo6.RowSource = "SELECT TBL_Pcode.PCodeID, TBL_Pcode.Locality, TBL_Pcode.Pcode, TBL_States.StateID " & _...
  8. G

    Combobox Autoexpand Question

    I see that the Post Code Combobox and Suburb text field are connected the way I need. But there's a lot of code in there! What part of the code populates the Suburb text field when a Post Code is selected? That's the only piece I'm looking for.
  9. G

    Combobox Autoexpand Question

    Here are the applicable portions of my database design – tblMembers.MemberID (Primary Key) tblMembers.AddressID (foreign Key – Addresses table) tblMembers.FirstName tblMembers.LastName tblMembers.SponsorID tblAddresses.AddressID (Primary Key) queryMembersAddressIDs.MemberID (from tblMembers)...
    • gswan
    • Thread
    • Replies: 8
    • Forum: Forms
  10. G

    Select ONLY rows with a value, but do not otherwise appear

    That works! Thanks for the help!
  11. G

    Select ONLY rows with a value, but do not otherwise appear

    Ok, that wasn't exactly it. What I discovered is that some Members might have multiple entries with a 2 or a 3, so the table would look like this - Name IDNum John 1 John 2 John 3 Mary 1 Mary 2 Mary 3 Paul 2 Paul 2 Larry 1 Larry 2 Larry 3 Joe 3 Joe 3 Joe 3 Joe 3 Betty 2...
  12. G

    Select ONLY rows with a value, but do not otherwise appear

    That was it! It was a little more complicated than I thought it would be! Thanks so much for the help!
  13. G

    Select ONLY rows with a value, but do not otherwise appear

    I want the ones that have a 2 OR a 3. Some members may have both a 2 AND a 3, I would want the ones who have just one record where the ID is a 2 or a 3. I would not want to see the members who have both a 2 AND a 3.
  14. G

    Select ONLY rows with a value, but do not otherwise appear

    I am trying to select the people in a table that exist with a certain value in one field, and do not otherwise appear in the table. Here’s a sample of the data in the table: Name IDNum John 1 John 2 John 3 Mary 1 Mary 2 Mary 3 Paul 2 Larry 1 Larry 2 Larry 3 Joe 3 I need a query...
  15. G

    Conditional Query to Concatenate Fields

    Yes, that .mdb example does what I'm looking for! Thanks! Now I just have to learn a lot more about visual basic and what you did with those queries!
See more
Back
Top Bottom