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 Rhinorhino 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. kieriosity

    Optimizing a Query

    Thanks for replying. The subselect query is getting the max routid for the each reference of MasterID in the routing table; that's what the Group By is for. I want a single RoutID for each MasterID. The MasterID is the FK in the routing table; it's the PK in the MASTER table. I tried the...
  2. kieriosity

    Optimizing a Query

    Does anyone know a better way to do the following query? SELECT [CCM_DETAIL_1_ACT].[FNAME], [CCM_DETAIL_1_ACT].[LNAME], [CCM_DETAIL_1_ACT].[ORG], [CCM_MASTER_1_ACT].[INPUT], [CCM_MASTER_1_ACT].[DUE], [CCM_MASTER_1_ACT].[FILENO], [CCM_MASTER_1_ACT].[DOCKET]...
  3. kieriosity

    Automatically selecting Yes/No/Cancel when running a query via VBA

    Woops... should have read the last sentence more carefully. I'll look at it and let you know if I come up with anything.
  4. kieriosity

    Automatically selecting Yes/No/Cancel when running a query via VBA

    You can turn off the warnings by using the following: DoCmd.SetWarnings False If you want to turn them back on after all queries have been run type: DoCmd.SetWarnings True Phil
  5. kieriosity

    Ruturning a Value from a Function in a Module

    Thanks for your reply. I got it to work, but without using the vResults=Call basSelectCriteria.selectCriteria(ctl). This would not work for me. I simply declared a global variable. Thanks.
  6. kieriosity

    Ruturning a Value from a Function in a Module

    I have the following bit of code placed in a module: Function selectCriteria(ctl) 'Flush out the Criteria variable before adding new data Criteria = "" 'Loop through the list box and build a string 'for all items selected For Each Itm In...
  7. kieriosity

    Version of Access

    This may help: http://www.mvps.org/access/api/api0065.htm Hope it does. Phil
  8. kieriosity

    Use Query Result as criteria for a second query

    OK, here is my situation. I have a table with a list of courses a student can take. In the same table is another field that lists the prerequisite course, if there is any. Now, there is a form that I've created that allows the user to add eligible students to a class (the class is related to...

Part and Inventory Search

Back
Top