Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Jackcess

    Access books with VBA

    Hi everyone, I'm looking to buy some books to beef up my Access and VBA knowledge. can anyone recommend one they like? or just as helpful, suggest which ones to avoid? I was considering: Access 2000 Developer's Handbook Set Thanks in advance, Jack
  2. Jackcess

    Good Books?

    Hi everyone, I'm looking to buy some books to beef up my Access knowledge. can anyone recommend one they like? or just as helpful, suggest which ones to avoid? I was considering: Access 2000 Developer's Handbook Set Thanks in advance, Jack
  3. Jackcess

    Using IIF and OR

    linsk33, try using the LIKE instead of = for example, iif(name like 'A*', "Apple","Banana") I used it once and it worked. i might have the syntax above a bit screwy though.
  4. Jackcess

    Macro Override Command

    Hi everyone. I have this macro that runs a Make Table Query. When the query kicks off, it always gives me the warning message about how the table will be deleted etc etc. Is there anyway to automatically select "Yes" everytime so that the user does not have to sit there and click through...
  5. Jackcess

    Using IIF and OR

    Thanks! That worked.
  6. Jackcess

    Using IIF and OR

    Hi, I am trying to do the following in a query. If X equals A, B, or C, then return True, otherwise False. I've tried using the following syntax but can't seem to get it right: iif(x=A OR x=B OR x=C, "True","False) Any advice? Thanks! Jack

Part and Inventory Search

Back
Top