Solved

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

Posted on 2012-03-21
11
218 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
  • 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
 
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
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

920 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now