Prev: How to put "order details" on top of report?
Next: Horizontal Line Problems with ConvertReportToPDF
From: Francis Cunningham, Jr. on 29 Jun 2008 14:44
I have five different reports called 'Cooling, Electric, Gas, Heat Pump and
Oil'
I would like to create a one command button on a form called 'Contract',
that based on two fields on this form, called 'ContractNumber' and
'ContractType' will generate the specific report. The ContractNumber is
unique (primary key, required and no duplicates allowed) to the form
'Contract'. So based on the ContractNumber and the ContractType on the form I
would like the result to be the correct report for the customer.
How the forms are laid out are:
Form - Contacts, which includes name, address etc, phone number (which is
the ContractNumber)
Form – Contract, which includes the 'ContractNumber and the ContractType'
(Cooling, Electric, Gas, Heat Pump or Oil).
Can someone help?
Frank

From: Jeff Boyce on 29 Jun 2008 16:31
You asked about "reports" but described "forms". In Access, forms display
data on-screen, reports are for displaying data on paper.

So, what does form layout have to do with your reports?

What about ContractNumber and ContractType tells you which report to run?

Do you use queries to "fill" your forms? Do you base your reports on
queries?

More info, please...

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP
http://mvp.support.microsoft.com/

Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

<Francis Cunningham>; "Jr." <FrancisCunninghamJr(a)discussions.microsoft.com>
wrote in message news:0D731B47-8CC9-4BD4-9D50-3BC24362AECB(a)microsoft.com...
> I have five different reports called 'Cooling, Electric, Gas, Heat Pump
and
> Oil'
> I would like to create a one command button on a form called 'Contract',
> that based on two fields on this form, called 'ContractNumber' and
> 'ContractType' will generate the specific report. The ContractNumber is
> unique (primary key, required and no duplicates allowed) to the form
> 'Contract'. So based on the ContractNumber and the ContractType on the
form I
> would like the result to be the correct report for the customer.
> How the forms are laid out are:
> Form - Contacts, which includes name, address etc, phone number (which is
> the ContractNumber)
> Form – Contract, which includes the 'ContractNumber and the ContractType'
> (Cooling, Electric, Gas, Heat Pump or Oil).
> Can someone help?
> Frank
>

From: Francis Cunningham, Jr. on 30 Jun 2008 18:00
The result of clicking the command button is a report.
The form layout is just to give a visual of what I am doing.
By using the ContractNumber and the ContractType it narrows down the search
to the one specific record.
Queries do not complete the forms.
The reports are based on queries. I was not sure which community to post
this question. Hope this helps.
Frank


"Jeff Boyce" wrote:

> You asked about "reports" but described "forms". In Access, forms display
> data on-screen, reports are for displaying data on paper.
>
> So, what does form layout have to do with your reports?
>
> What about ContractNumber and ContractType tells you which report to run?
>
> Do you use queries to "fill" your forms? Do you base your reports on
> queries?
>
> More info, please...
>
> --
> Regards
>
> Jeff Boyce
> www.InformationFutures.net
>
> Microsoft Office/Access MVP
> http://mvp.support.microsoft.com/
>
> Microsoft IT Academy Program Mentor
> http://microsoftitacademy.com/
>
> <Francis Cunningham>; "Jr." <FrancisCunninghamJr(a)discussions.microsoft.com>
> wrote in message news:0D731B47-8CC9-4BD4-9D50-3BC24362AECB(a)microsoft.com...
> > I have five different reports called 'Cooling, Electric, Gas, Heat Pump
> and
> > Oil'
> > I would like to create a one command button on a form called 'Contract',
> > that based on two fields on this form, called 'ContractNumber' and
> > 'ContractType' will generate the specific report. The ContractNumber is
> > unique (primary key, required and no duplicates allowed) to the form
> > 'Contract'. So based on the ContractNumber and the ContractType on the
> form I
> > would like the result to be the correct report for the customer.
> > How the forms are laid out are:
> > Form - Contacts, which includes name, address etc, phone number (which is
> > the ContractNumber)
> > Form – Contract, which includes the 'ContractNumber and the ContractType'
> > (Cooling, Electric, Gas, Heat Pump or Oil).
> > Can someone help?
> > Frank
> >
>
>
 | 
Pages: 1
Prev: How to put "order details" on top of report?
Next: Horizontal Line Problems with ConvertReportToPDF