mytfein
asked on
Quest 1b: Datasheets as Subforms - record navigator buttons(revised simplified the question)
Hi EE,
Am very new to datasheets.
In the near future i should ask how to use datasheets to drill down.
In the meantime asking about having more than one subform on a mainform.
Each subform would contain a datasheet.
header section - placed a datasheet to show totals (from sql: COUNT)
detail section - placed a datasheet to show students that reflect the total
the detail section datasheet opens with default record source of
a query: qp_050_Discoverer_SortByLN AME
i thought, that on on click event of a column in header section datasheet, would
populate the detail section datasheet with appropriate query name.
So my question is
the record navigators on the detail datasheet are not showing...how can they be made
to show
btw, i hid the record navigators on the header section datasheet, and that works ok.
tx for your ideas, sandra
EE-MatchM4-Upload-frontend.mdb
Am very new to datasheets.
In the near future i should ask how to use datasheets to drill down.
In the meantime asking about having more than one subform on a mainform.
Each subform would contain a datasheet.
header section - placed a datasheet to show totals (from sql: COUNT)
detail section - placed a datasheet to show students that reflect the total
the detail section datasheet opens with default record source of
a query: qp_050_Discoverer_SortByLN
i thought, that on on click event of a column in header section datasheet, would
populate the detail section datasheet with appropriate query name.
So my question is
the record navigators on the detail datasheet are not showing...how can they be made
to show
btw, i hid the record navigators on the header section datasheet, and that works ok.
tx for your ideas, sandra
EE-MatchM4-Upload-frontend.mdb
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
<when opening a query which i guess is in datasheet view, you can see the the
navigation buttons there...>
<also, i use a form as a "menu" screen, and have experimented with
docmd.OpenQuery
the query opens with the navigation row>
Yes, but that is with a *query*.
You are using it as a *Form* where you had turned off the Navigation button in the Form properties anyway...
There is no way to turn off the navigation button in a raw query, just like there is no way to turn them off in a raw table.
;-)
Jeff
navigation buttons there...>
<also, i use a form as a "menu" screen, and have experimented with
docmd.OpenQuery
the query opens with the navigation row>
Yes, but that is with a *query*.
You are using it as a *Form* where you had turned off the Navigation button in the Form properties anyway...
There is no way to turn off the navigation button in a raw query, just like there is no way to turn them off in a raw table.
;-)
Jeff
ASKER
tx.... ok
i just wanted to show total number of records, not so much for inserting records
when opening a query which i guess is in datasheet view, you can see the the
navigation buttons there...
also, i use a form as a "menu" screen, and have experimented with
docmd.OpenQuery
the query opens with the navigation row
so i was hoping the same would apply when i create
a datasheet form from scratch
however, i googled what you just wrote, and i see others who explain that it cannot
be viewed in datasheet view...
tx so much, s