Search results

  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!
  16. G

    Conditional Query to Concatenate Fields

    I have a table of data about people. The fields I'm working with are PersonID, FirstName, LastName, and SpouseID. PersonID is the primary key. If two people (in different rows) are married, they each have their spouses PersonID number in their SpouseID field. Single people don't have any...
Back
Top Bottom