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...
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...
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...
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"...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.