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 Mike Lewis 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 access a query, loop through it and extract info??

    Tranman, Here is the info you requested. Thanks for your help! BT *** Access 97 Table 1 : Family Primary Key: FamilyID (autonumber long integer) FamilyType (text) Table 2 : FamilyMember Primary Key: PersonCode (autonumber long integer) Foreign Key: FamilyID (long integer)...
  3. BingeThinker

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

    I guess my basic question is how do I call a query (which is not tied to a particular form) using commands within the form's code window?? What is the correct syntax??
  4. 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...
  5. 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...
  6. BingeThinker

    Calculate a field after user clicks "next record" button

    excellent, thanks!
  7. BingeThinker

    Locking Controls

    Try "right-clicking" on the control on the design mode of the form, then selecting "properties", then going to the "data" tab, then setting "locked" equal to "true"? This will set the control default to locked. Then based on an event you can...
  8. 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...
  9. 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