Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2012-03-21
11
Medium Priority
?
230 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
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 
LVL 74

Assisted Solution

by:Jeffrey Coachman
Jeffrey Coachman earned 2000 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 2000 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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

705 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