Access 2003: Quest 1: Datasheets - as subforms on main form - (revised/simplified 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_SortByLNAME

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 questions are:

a) the record navigators on the detail datasheet are not showing...how can they be made
    to show

c) i put a text box in the detail section and it is not showing.... how can it be made to show



    uploaded a test mdb  and screen shot below

    tx in advance for your ideas, sandra

bmp
 bmpEE-MatchM4-Upload-frontend.mdb
mytfeinAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jeffrey CoachmanMIS LiasonCommented:
<So my questions are:>
Question(S)?
What happened to one question per post?
;-)

To answer Question a,

The navigation button are not showing because you have turned then off.
If you want to see them, set the "navigation Button" property of that subform to: Yes

The rest of your question are not clear...

ex: Q b:
<i put a text box in the detail section.>
In which detail section of which form?, Please be specific...

< and it is not showing>
Not showing what?

<d) if i click on a column on the header datasheet,  the detail datasheet IS refreshing
    but it is keeping the original query's columns.... any advice to see the columns
    behind the new underlying query....>
You have not explained what this form (and its subforms) are supposed to be displaying.
So it is extremely difficult to determine what this means...
Perhaps this should be a separate, new question...


JeffCoachman
0
mytfeinAuthor Commented:
tx jeff for writing....

i just posted the more complicated part of my question as a new post,

let me read what you wrote, and get back to you.... s
0
mytfeinAuthor Commented:
Hi Jeff,

In the detail section of the form in design view you will see an ORANGE text box and a
BLACK separator line...

The do not show in view mode....

Any ideas why?

i'll post a new post for the other question....

tx, s
0
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

Jeffrey CoachmanMIS LiasonCommented:
<The do not show in view mode....>
Again, please be clear...
There is no specific "View Mode" for an Access form.
There are specific "Views" allowed for your main form, though...
These views are:
Form View
Datasheet View
Pivot Table View
Pivot Chart View
Design View

For me, the ORANGE text box with the BLACK separator line displays just fine in "Form View" and "Design View" (as is clear in your screenshot)
screen
JeffCoachman
0
mytfeinAuthor Commented:
Hi Jeff,

i understand the confusion....

i am using 2003, and you are using a later Access version

so the orange text box and line are showing beautifully on your pc,
 
but they are not showing at all on my pc that using a2003 - pls see the 2nd screen shot

above, orange text box and line are not showing....

tx, s
0
mytfeinAuthor Commented:
Jeff,

in fact i like your screen better, to me, it looks more pleasing to the eye

i have so much grey space in my screen shot....

i like that your empty space is filled with empty rows...

is there any way i can get my screen to look like yours in a2003?

tx, s
0
Jeffrey CoachmanMIS LiasonCommented:
I have to go home and try this in Access 2003...
0
mytfeinAuthor Commented:
tx Jeff,

btw, are u using a2007 and a2010,

tx again, s
0
Jeffrey CoachmanMIS LiasonCommented:
yes, at work I only have 2007 and 2010

At home I have 2003, 2007 and 2010 all running on the same machine...
0
Jeffrey CoachmanMIS LiasonCommented:
Screen in Access 2003.

Orange box and separator line clearly visible
.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
mytfeinAuthor Commented:
tx so much Jeff for taking time to check it at home ...

maybe the a2003 that i have/or the pc itself has an issue....

tx again, s
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.