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...
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)...
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??
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...
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...
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.