Access Database Reports

Hello Klatuu,

First, thank you for this very prompt response. Please forgive me but I am
very new to Access. I have created a database with a number of tables. I
created a report with various fields from each of two of the tables. I want
to create a report each time I enter information into one of the tables,
using data from both tables. Only the information from one of the tables
changes. So, I have a table of 'customers' which remains the same
throughout. Then I have a table of 'orders', where I enter new orders as
they arrive. I combine the information from both tables to create a 'report'
which is actually an order confirmation to be sent back to the customer.
Does this make any sense?

"Klatuu" wrote:

> You cannot edit an Access report. It is not an interative object (other than
> in design view). It is only a view of a set of data based on some criteria
> at the point in time the report was created.
>
> What is it you are trying to accomplish?
> --
> Dave Hargis, Microsoft Access MVP
>
>
> "Steve" wrote:
>
> > I want to edit an access report. Whenever I try to add more database
> > information to a report, the report is appended. I do not want multiple
> > pages, I just want to insert new database entries into the report, print it
> > to .pdf (an easy one I can already do) then edit the report with new data and
> > keep repeating the process. Please help, I'm really new to all of this.

So let me see if I understand.
When you create an order for a customer, you want to create a confirmation
report that includes only the newly created order, right?
--
Dave Hargis, Microsoft Access MVP


"Steve" wrote:

> Hello Klatuu,
>
> First, thank you for this very prompt response. Please forgive me but I am
> very new to Access. I have created a database with a number of tables. I
> created a report with various fields from each of two of the tables. I want
> to create a report each time I enter information into one of the tables,
> using data from both tables. Only the information from one of the tables
> changes. So, I have a table of 'customers' which remains the same
> throughout. Then I have a table of 'orders', where I enter new orders as
> they arrive. I combine the information from both tables to create a 'report'
> which is actually an order confirmation to be sent back to the customer.
> Does this make any sense?
>
> "Klatuu" wrote:
>
> > You cannot edit an Access report. It is not an interative object (other than
> > in design view). It is only a view of a set of data based on some criteria
> > at the point in time the report was created.
> >
> > What is it you are trying to accomplish?
> > --
> > Dave Hargis, Microsoft Access MVP
> >
> >
> > "Steve" wrote:
> >
> > > I want to edit an access report. Whenever I try to add more database
> > > information to a report, the report is appended. I do not want multiple
> > > pages, I just want to insert new database entries into the report, print it
> > > to .pdf (an easy one I can already do) then edit the report with new data and
> > > keep repeating the process. Please help, I'm really new to all of this.

Yes. Only the information from that order, along with the his/her
information from the 'customer' table.

"Klatuu" wrote:

> So let me see if I understand.
> When you create an order for a customer, you want to create a confirmation
> report that includes only the newly created order, right?
> --
> Dave Hargis, Microsoft Access MVP
>
>
> "Steve" wrote:
>
> > Hello Klatuu,
> >
> > First, thank you for this very prompt response. Please forgive me but I am
> > very new to Access. I have created a database with a number of tables. I
> > created a report with various fields from each of two of the tables. I want
> > to create a report each time I enter information into one of the tables,
> > using data from both tables. Only the information from one of the tables
> > changes. So, I have a table of 'customers' which remains the same
> > throughout. Then I have a table of 'orders', where I enter new orders as
> > they arrive. I combine the information from both tables to create a 'report'
> > which is actually an order confirmation to be sent back to the customer.
> > Does this make any sense?
> >
> > "Klatuu" wrote:
> >
> > > You cannot edit an Access report. It is not an interative object (other than
> > > in design view). It is only a view of a set of data based on some criteria
> > > at the point in time the report was created.
> > >
> > > What is it you are trying to accomplish?
> > > --
> > > Dave Hargis, Microsoft Access MVP
> > >
> > >
> > > "Steve" wrote:
> > >
> > > > I want to edit an access report. Whenever I try to add more database
> > > > information to a report, the report is appended. I do not want multiple
> > > > pages, I just want to insert new database entries into the report, print it
> > > > to .pdf (an easy one I can already do) then edit the report with new data and
> > > > keep repeating the process. Please help, I'm really new to all of this.

Okay, the Record Source of the report should be a query that joins the
customer information table with the order information table.

I don't know how you are opening your report, but I will assume you are
using a command button on your form that runs either some VBA code or a
macro to open the report.

To keep it as simple as possible for you, I would suggest you open the
report's record source query in design view and find the column with the
Order Number

The will be a row or rows labeled Criteria. In this row and in the Order
Number column, put a reference to the form and control name on the form where
the order number is. The syntax would be:

Forms!NameOfFormHere!NameOfOrderNumberControlHere

That will cause only that one order to be printed.
--
Dave Hargis, Microsoft Access MVP


"Steve" wrote:

> Yes. Only the information from that order, along with the his/her
> information from the 'customer' table.
>
> "Klatuu" wrote:
>
> > So let me see if I understand.
> > When you create an order for a customer, you want to create a confirmation
> > report that includes only the newly created order, right?
> > --
> > Dave Hargis, Microsoft Access MVP
> >
> >
> > "Steve" wrote:
> >
> > > Hello Klatuu,
> > >
> > > First, thank you for this very prompt response. Please forgive me but I am
> > > very new to Access. I have created a database with a number of tables. I
> > > created a report with various fields from each of two of the tables. I want
> > > to create a report each time I enter information into one of the tables,
> > > using data from both tables. Only the information from one of the tables
> > > changes. So, I have a table of 'customers' which remains the same
> > > throughout. Then I have a table of 'orders', where I enter new orders as
> > > they arrive. I combine the information from both tables to create a 'report'
> > > which is actually an order confirmation to be sent back to the customer.
> > > Does this make any sense?
> > >
> > > "Klatuu" wrote:
> > >
> > > > You cannot edit an Access report. It is not an interative object (other than
> > > > in design view). It is only a view of a set of data based on some criteria
> > > > at the point in time the report was created.
> > > >
> > > > What is it you are trying to accomplish?
> > > > --
> > > > Dave Hargis, Microsoft Access MVP
> > > >
> > > >
> > > > "Steve" wrote:
> > > >
> > > > > I want to edit an access report. Whenever I try to add more database
> > > > > information to a report, the report is appended. I do not want multiple
> > > > > pages, I just want to insert new database entries into the report, print it
> > > > > to .pdf (an easy one I can already do) then edit the report with new data and
> > > > > keep repeating the process. Please help, I'm really new to all of this.

I will try this. Is it possible that I can continue this thread a little
later? I will need some time, even though your instructions are excellent,
to work my way though this. I appreciate your help and patience.

"Klatuu" wrote:

> Okay, the Record Source of the report should be a query that joins the
> customer information table with the order information table.
>
> I don't know how you are opening your report, but I will assume you are
> using a command button on your form that runs either some VBA code or a
> macro to open the report.
>
> To keep it as simple as possible for you, I would suggest you open the
> report's record source query in design view and find the column with the
> Order Number
>
> The will be a row or rows labeled Criteria. In this row and in the Order
> Number column, put a reference to the form and control name on the form where
> the order number is. The syntax would be:
>
> Forms!NameOfFormHere!NameOfOrderNumberControlHere
>
> That will cause only that one order to be printed.
> --
> Dave Hargis, Microsoft Access MVP
>
>
> "Steve" wrote:
>
> > Yes. Only the information from that order, along with the his/her
> > information from the 'customer' table.
> >
> > "Klatuu" wrote:
> >
> > > So let me see if I understand.
> > > When you create an order for a customer, you want to create a confirmation
> > > report that includes only the newly created order, right?
> > > --
> > > Dave Hargis, Microsoft Access MVP
> > >
> > >
> > > "Steve" wrote:
> > >
> > > > Hello Klatuu,
> > > >
> > > > First, thank you for this very prompt response. Please forgive me but I am
> > > > very new to Access. I have created a database with a number of tables. I
> > > > created a report with various fields from each of two of the tables. I want
> > > > to create a report each time I enter information into one of the tables,
> > > > using data from both tables. Only the information from one of the tables
> > > > changes. So, I have a table of 'customers' which remains the same
> > > > throughout. Then I have a table of 'orders', where I enter new orders as
> > > > they arrive. I combine the information from both tables to create a 'report'
> > > > which is actually an order confirmation to be sent back to the customer.
> > > > Does this make any sense?
> > > >
> > > > "Klatuu" wrote:
> > > >
> > > > > You cannot edit an Access report. It is not an interative object (other than
> > > > > in design view). It is only a view of a set of data based on some criteria
> > > > > at the point in time the report was created.
> > > > >
> > > > > What is it you are trying to accomplish?
> > > > > --
> > > > > Dave Hargis, Microsoft Access MVP
> > > > >
> > > > >
> > > > > "Steve" wrote:
> > > > >
> > > > > > I want to edit an access report. Whenever I try to add more database
> > > > > > information to a report, the report is appended. I do not want multiple
> > > > > > pages, I just want to insert new database entries into the report, print it
> > > > > > to .pdf (an easy one I can already do) then edit the report with new data and
> > > > > > keep repeating the process. Please help, I'm really new to all of this.

Sure take all the time you need.
You have 10 minutes, starting now

No, really, at your convenience. Post back if you have additional questions.
Good luck.
--
Dave Hargis, Microsoft Access MVP


"Steve" wrote:

> I will try this. Is it possible that I can continue this thread a little
> later? I will need some time, even though your instructions are excellent,
> to work my way though this. I appreciate your help and patience.
>
> "Klatuu" wrote:
>
> > Okay, the Record Source of the report should be a query that joins the
> > customer information table with the order information table.
> >
> > I don't know how you are opening your report, but I will assume you are
> > using a command button on your form that runs either some VBA code or a
> > macro to open the report.
> >
> > To keep it as simple as possible for you, I would suggest you open the
> > report's record source query in design view and find the column with the
> > Order Number
> >
> > The will be a row or rows labeled Criteria. In this row and in the Order
> > Number column, put a reference to the form and control name on the form where
> > the order number is. The syntax would be:
> >
> > Forms!NameOfFormHere!NameOfOrderNumberControlHere
> >
> > That will cause only that one order to be printed.
> > --
> > Dave Hargis, Microsoft Access MVP
> >
> >
> > "Steve" wrote:
> >
> > > Yes. Only the information from that order, along with the his/her
> > > information from the 'customer' table.
> > >
> > > "Klatuu" wrote:
> > >
> > > > So let me see if I understand.
> > > > When you create an order for a customer, you want to create a confirmation
> > > > report that includes only the newly created order, right?
> > > > --
> > > > Dave Hargis, Microsoft Access MVP
> > > >
> > > >
> > > > "Steve" wrote:
> > > >
> > > > > Hello Klatuu,
> > > > >
> > > > > First, thank you for this very prompt response. Please forgive me but I am
> > > > > very new to Access. I have created a database with a number of tables. I
> > > > > created a report with various fields from each of two of the tables. I want
> > > > > to create a report each time I enter information into one of the tables,
> > > > > using data from both tables. Only the information from one of the tables
> > > > > changes. So, I have a table of 'customers' which remains the same
> > > > > throughout. Then I have a table of 'orders', where I enter new orders as
> > > > > they arrive. I combine the information from both tables to create a 'report'
> > > > > which is actually an order confirmation to be sent back to the customer.
> > > > > Does this make any sense?
> > > > >
> > > > > "Klatuu" wrote:
> > > > >
> > > > > > You cannot edit an Access report. It is not an interative object (other than
> > > > > > in design view). It is only a view of a set of data based on some criteria
> > > > > > at the point in time the report was created.
> > > > > >
> > > > > > What is it you are trying to accomplish?
> > > > > > --
> > > > > > Dave Hargis, Microsoft Access MVP
> > > > > >
> > > > > >
> > > > > > "Steve" wrote:
> > > > > >
> > > > > > > I want to edit an access report. Whenever I try to add more database
> > > > > > > information to a report, the report is appended. I do not want multiple
> > > > > > > pages, I just want to insert new database entries into the report, print it
> > > > > > > to .pdf (an easy one I can already do) then edit the report with new data and
> > > > > > > keep repeating the process. Please help, I'm really new to all of this.