Solved

Access 2003:  Quest 1: Datasheets - as subforms on main form - (revised/simplified question)

Posted on 2012-03-21
11
227 Views
Last Modified: 2012-03-22
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
Comment
Question by:mytfein
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 5
11 Comments
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 37749342
<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
 

Author Comment

by:mytfein
ID: 37749364
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
 

Author Comment

by:mytfein
ID: 37749375
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
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 
LVL 74

Assisted Solution

by:Jeffrey Coachman
Jeffrey Coachman earned 500 total points
ID: 37749479
<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
 

Author Comment

by:mytfein
ID: 37749611
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
 

Author Comment

by:mytfein
ID: 37749625
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
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 37749688
I have to go home and try this in Access 2003...
0
 

Author Comment

by:mytfein
ID: 37749883
tx Jeff,

btw, are u using a2007 and a2010,

tx again, s
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 37750059
yes, at work I only have 2007 and 2010

At home I have 2003, 2007 and 2010 all running on the same machine...
0
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 500 total points
ID: 37750510
Screen in Access 2003.

Orange box and separator line clearly visible
.
0
 

Author Comment

by:mytfein
ID: 37752859
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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

635 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question