Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 234
  • Last Modified:

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
0
mytfein
Asked:
mytfein
  • 6
  • 5
2 Solutions
 
Jeffrey CoachmanCommented:
<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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Jeffrey CoachmanCommented:
<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 CoachmanCommented:
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 CoachmanCommented:
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 CoachmanCommented:
Screen in Access 2003.

Orange box and separator line clearly visible
.
0
 
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

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

  • 6
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now