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!

  • Congratulations wOOdy-Soft 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. BingeThinker

    what is the command in Access code

    what is the command in Access code to bring back field data from a table or query? do you use the DoCmd object? I can get this far: DoCmd.OpenQuery "QueryName" DoCmd.GoToRecord acDataQuery, "QueryName", acFirst But I don't know how to get to a specific field on that...
  2. BingeThinker

    How to call a query, loop through it and return values???

    Hi, I have two tables. One table is a "family" table and the other is "family members". There is a one to many relationship. I have a calculated field which is "family make-up" and I want to query the "family members" table based on the "Family...
  3. BingeThinker

    How to access a query, loop through it and extract info??

    Hi, I have two tables. One table is a "family" table and the other is "family members". There is a one to many relationship. I have a calculated field which is "family make-up" and I want to query the "family members" table based on the "Family...
  4. BingeThinker

    Calculate a field after user clicks "next record" button

    On a normal Access form (I am using Access 97), a form which is linked to a table or query has a control for moving through the recordset at the bottom of the form which only shows up in the "View" mode. I want to calculate a field after the user clicks the "next record&quot...
  5. BingeThinker

    Can you to decrement AutoNumber??

    Hi, Background ---------- I have a database with two tables. One table has families in it and the other table has family members. They family table has a primary key called FamilyID and the member table has a foreign key called FamilyID. There is a one to many relationship (one family to one...

Part and Inventory Search

Back
Top