When I switch from datasheet view to single form view, the header will show, but
then the details won't. Any clue?
bob
On 4 Jun 2006 at 7:36, John Viescas wrote:
> bob-
>
> Is the default view of the form inside the subform control Single Form or
> Continous Form? If so, then records in the Form Header section should
> appear in the subform control. You won't see the headers if the form is in
> Datasheet view.
>
> John Viescas, author
> Building Microsoft Access Applications
> Microsoft Office Access 2003 Inside Out
> Running Microsoft Access 2000
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Paris, France)
> For the inside scoop on Access 2007, see:
> http://blogs.msdn.com/access/
>
>
> -----Original Message-----
> From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf
> Of Bob Rosenblum
> Sent: Sunday, June 04, 2006 12:45 AM
> To: [email protected]
> Subject: RE: [ms_access] Re: headings in sub forms
>
> John I think I misunderstood your question. Yes, the detail lines in the
> subform are
> linked to actual fields on one of the tables.
>
> Here is an overview. It is a Donor Database. There is one table for donors
> and
> another for donations.
>
> So, Donor is the form and donations the subform.
>
> When I put a heading in the subform, it doesn't show. The data for the
> subform
> DOES show. Every donation made by a particular donor shows up.
>
> Does that help?
>
> bob
>
> On 3 Jun 2006 at 23:11, John Viescas wrote:
>
> > bob-
> >
> > Unless you define bound controls in the detail section, you won't see any
> > data. And if the record in the outer form has no related records in the
> > subform, you might not see the headers either if the Record Source of the
> > subform is not updatable. When you open a form on a non-updatable
> recordset
> > that has no records, the form will appear blank. What is the Record
> Source
> > of your subform?
> >
> > John Viescas, author
> > Building Microsoft Access Applications
> > Microsoft Office Access 2003 Inside Out
> > Running Microsoft Access 2000
> > SQL Queries for Mere Mortals
> > http://www.viescas.com/
> > (Paris, France)
> > For the inside scoop on Access 2007, see:
> > http://blogs.msdn.com/access/
> >
> >
> > -----Original Message-----
> > From: [email protected] [mailto:[EMAIL PROTECTED] On
> Behalf
> > Of Bob Rosenblum
> > Sent: Saturday, June 03, 2006 6:12 PM
> > To: [email protected]
> > Subject: RE: [ms_access] Re: headings in sub forms
> >
> > Sorry for waiting so long to reply.
> >
> > I do not have bound controls defined in the detail section.
> >
> > What is happening, is I am creating a subform. Then using the heading for
> > the
> > subform to place a label in. When going to form view, this label is not
> > visible.
> >
> > bob
> >
> > On 21 May 2006 at 20:08, John Viescas wrote:
> >
> > > Bob-
> > >
> > > Do you have bound controls defined in the Detail section of your form
> > > design? What exactly do you mean by "disappear on me?"
> > >
> > > John Viescas, author
> > > Building Microsoft Access Applications
> > > Microsoft Office Access 2003 Inside Out
> > > Running Microsoft Access 2000
> > > SQL Queries for Mere Mortals
> > > http://www.viescas.com/
> > > (Paris, France)
> > > For the inside scoop on Access 2007, see:
> > > http://blogs.msdn.com/access/
> > >
> > >
> > > -----Original Message-----
> > > From: [email protected] [mailto:[EMAIL PROTECTED] On
> > Behalf
> > > Of Bob
> > > Sent: Sunday, May 21, 2006 7:55 PM
> > > To: [email protected]
> > > Subject: [ms_access] Re: headings in sub forms
> > >
> > >
> > > I tried doing that, but when I select single or continuous, the
> > > heading shows just fine, but the details disappear on me.
> > >
> > > bob
> > >
> > > --- In [email protected], Lonnie Johnson <[EMAIL PROTECTED]> wrote:
> > > >
> > > > You subform's default view must be "single" or "continuous" (cannot
> > > be datasheet) and you must put the controls in the subform's "FORM
> > > HEADER" section and not the "PAGE HEADER" section.
> > > >
> > > > Bob <[EMAIL PROTECTED]> wrote: I find that whenever I try to put headings in
> > > subforms, they
> > > > disappear...Can anyone tell me how to get them to show?
> > > >
> > > > bob
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > SPONSORED LINKS
> > > > Microsoft access database Database development software
> > > Database management software Database software Inventory
> > > database software Membership database software
> > > >
> > > > ---------------------------------
> > > > YAHOO! GROUPS LINKS
> > > >
> > > >
> > > > Visit your group "ms_access" on the web.
> > > >
> > > > To unsubscribe from this group, send an email to:
> > > > [EMAIL PROTECTED]
> > > >
> > > > Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> > > Service.
> > > >
> > > >
> > > > ---------------------------------
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > May God bless you beyond your imagination!
> > > > Lonnie Johnson
> > > > ProDev, Professional Development of MS Access Databases
> > > > Visit me at ==> http://www.prodev.us
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > ---------------------------------
> > > > Feel free to call! Free PC-to-PC calls. Low rates on PC-to-Phone.
> > > Get Yahoo! Messenger with Voice
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > Yahoo! Groups Links
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > Yahoo! Groups Links
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > --
> > > No virus found in this incoming message.
> > > Checked by AVG Free Edition.
> > > Version: 7.1.392 / Virus Database: 268.6.1/344 - Release Date: 5/19/2006
> > >
> >
> > ~
> > Bob Rosenblum
> > PO Box 3027
> > Albany, NY 12203
> > Phone: 518-459-6212
> > Email: [EMAIL PROTECTED]
> >
> >
> >
> >
> >
> >
> >
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
> >
> >
> >
> > --
> > No virus found in this incoming message.
> > Checked by AVG Free Edition.
> > Version: 7.1.394 / Virus Database: 268.8.1/355 - Release Date: 6/2/2006
> >
>
> ~
> Bob Rosenblum
> PO Box 3027
> Albany, NY 12203
> Phone: 518-459-6212
> Email: [EMAIL PROTECTED]
>
>
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
> --
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.1.394 / Virus Database: 268.8.1/355 - Release Date: 6/2/2006
>
~
Bob Rosenblum
PO Box 3027
Albany, NY 12203
Phone: 518-459-6212
Email: [EMAIL PROTECTED]
SPONSORED LINKS
| Microsoft access database | Database development software | Database management software |
| Database software | Inventory database software | Membership database software |
YAHOO! GROUPS LINKS
- Visit your group "ms_access" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
