Prev: How do I set it up so that the table and form shows 2 decimal plac
Next: Subforms
From: forest8 on 25 Mar 2010 16:21
Hi

I need to print a record for an individual student.

I have created a report that contains the same information as my form.

I want to create a button on my form that when clicked on the report for
that individual is the one being printed.

I also want the button to be able to print all the records for the same
individual.

I must admit the queries confuse me so any guidance will be helpful.
From: Duane Hookom on 26 Mar 2010 00:54
Take a look at the solution found at
http://www.mvps.org/access/reports/rpt0002.htm. You can get a kick start by
creating a button using the command button wizard.

--
Duane Hookom
MS Access MVP


"forest8" <forest8(a)discussions.microsoft.com> wrote in message
news:CC4C0130-53F9-4ACE-84E5-4A0A8C7041B9(a)microsoft.com...
> Hi
>
> I need to print a record for an individual student.
>
> I have created a report that contains the same information as my form.
>
> I want to create a button on my form that when clicked on the report for
> that individual is the one being printed.
>
> I also want the button to be able to print all the records for the same
> individual.
>
> I must admit the queries confuse me so any guidance will be helpful.

From: forest8 on 28 Mar 2010 01:20
An addendum to my question.

Can you please explain how this works if originally I had a main form and a
subform and I created a report that had both forms on it?

My main form has information on a student, i.e. name, age, program of study.
The subform is a tabcontrol that deals with detailed information on the
student.

If there are 100 students, how do I only print out the information for
student 79?

I hope this isn't too silly to ask but I don't really understand how this
works. I understand forms but not reports.

Thank you

"Duane Hookom" wrote:

> Take a look at the solution found at
> http://www.mvps.org/access/reports/rpt0002.htm. You can get a kick start by
> creating a button using the command button wizard.
>
> --
> Duane Hookom
> MS Access MVP
>
>
> "forest8" <forest8(a)discussions.microsoft.com> wrote in message
> news:CC4C0130-53F9-4ACE-84E5-4A0A8C7041B9(a)microsoft.com...
> > Hi
> >
> > I need to print a record for an individual student.
> >
> > I have created a report that contains the same information as my form.
> >
> > I want to create a button on my form that when clicked on the report for
> > that individual is the one being printed.
> >
> > I also want the button to be able to print all the records for the same
> > individual.
> >
> > I must admit the queries confuse me so any guidance will be helpful.
>
From: Duane Hookom on 28 Mar 2010 12:05
The answer is the same as I suggested. You need to substitute your field,
control, and report names for the ones in the sample on the web page.

I generally start by using the command button wizard to write the code to
open the report. Then I modify the code as per the suggested code on the web
page.

If you can't figure this out, come back with the code the wizard has created
as well as the field name storing the "79".

--
Duane Hookom
MS Access MVP


"forest8" <forest8(a)discussions.microsoft.com> wrote in message
news:AF396D8D-8A43-4D3E-A51C-CD2649F8699E(a)microsoft.com...
> An addendum to my question.
>
> Can you please explain how this works if originally I had a main form and
> a
> subform and I created a report that had both forms on it?
>
> My main form has information on a student, i.e. name, age, program of
> study.
> The subform is a tabcontrol that deals with detailed information on the
> student.
>
> If there are 100 students, how do I only print out the information for
> student 79?
>
> I hope this isn't too silly to ask but I don't really understand how this
> works. I understand forms but not reports.
>
> Thank you
>
> "Duane Hookom" wrote:
>
>> Take a look at the solution found at
>> http://www.mvps.org/access/reports/rpt0002.htm. You can get a kick start
>> by
>> creating a button using the command button wizard.
>>
>> --
>> Duane Hookom
>> MS Access MVP
>>
>>
>> "forest8" <forest8(a)discussions.microsoft.com> wrote in message
>> news:CC4C0130-53F9-4ACE-84E5-4A0A8C7041B9(a)microsoft.com...
>> > Hi
>> >
>> > I need to print a record for an individual student.
>> >
>> > I have created a report that contains the same information as my form.
>> >
>> > I want to create a button on my form that when clicked on the report
>> > for
>> > that individual is the one being printed.
>> >
>> > I also want the button to be able to print all the records for the same
>> > individual.
>> >
>> > I must admit the queries confuse me so any guidance will be helpful.
>>
From: John W. Vinson on 28 Mar 2010 17:45
On Sat, 27 Mar 2010 22:20:02 -0700, forest8
<forest8(a)discussions.microsoft.com> wrote:

>My main form has information on a student, i.e. name, age, program of study.
>The subform is a tabcontrol that deals with detailed information on the
>student.
>
>If there are 100 students, how do I only print out the information for
>student 79?
>
>I hope this isn't too silly to ask but I don't really understand how this
>works. I understand forms but not reports.

I think you need to clarify your understanding of forms too.

You say that your main form has information. IT DOESN'T.

Your *tables* have information. That's the only place in your database that
the information is stored!

A Form is a tool to display information from a table on the screen in a way
that lets you view, edit, and add more information... to the tables.

A Report is a tool to display information from a table in a way that lets you
print it (or print preview it).

Either a form or report can be based directly on a Table, or (much more
usefully!) on a Query which selects desired fields and records from the table.

If you want to see information about student 79 printed, you can base your
Report on a Query selecting information only about that student. A common way
to do this is to use a Parameter Query, with a criterion referencing a form.
E.g. if you have frmStudents, with a control named StudentID, you could base
your report on a query with a criterion

=Forms!frmStudents!StudentID

on the ID field. This will pull data for the student whose ID is currently on
the form, from the table or tables, and lay it out on the report.
--

John W. Vinson [MVP]
 | 
Pages: 1
Prev: How do I set it up so that the table and form shows 2 decimal plac
Next: Subforms