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 derfloh 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. flyagain

    DESIGN mode changes SQL query

    Though the advice may be valid, it does not answer the question. I already know how to devise parameter queries, etc. so I won't ask for that. I just wanted to know about the why's and how's of DESIGN mode vs. SQL mode for a query. By the way, one of the reasons that the client chose Access as...
  2. flyagain

    DESIGN mode changes SQL query

    The queries are actually the client's, not mine. When we added some tables to the db, we were asked for help in incorporating them into some existing queries. They were already using DESIGN mode to create and change criteria for queries. That is when we found that the sql was being changed...
  3. flyagain

    DESIGN mode changes SQL query

    I have a query designed in Access SQL mode. It contains a series of: where ... and where...this or where...this and this and this. The query runs correctly. If I then use Access DESIGN mode to change a criteria value, the query fails to run correctly. Looking at the SQL, it has been totally...
  4. flyagain

    public variable loosing value

    The variable in question is declared as Public at the module level. Can you explain why a Global declared at the module level would be different?
  5. flyagain

    public variable loosing value

    The variable is in a code module as 'public' and 'option explicit' is set in all class modules. What is the difference between 'public' and 'global'. The help definition of 'public' is exactly what I am looking for.
  6. flyagain

    public variable loosing value

    I have a public variable 'userid' which is set in 1 place only. It is used throughout the program to update records, but occasionally becomes blank. Is there any known problem with public memory getting overridden (such as not returning recordsets to nothing, thus hogging mem)?
  7. flyagain

    me! or me.

    Is there a difference between the use of me!controlname and me.controlname in VBA code?

Part and Inventory Search

Back
Top