Interactive reports

  • Thread starter Thread starter Sophie
  • Start date Start date
S

Sophie

I putting the finalizing touches on my database and my
boss want for me to have this:
When I go to the reports menu and select Purchase
orders, he want for me to have a search doen of the PO I'm
looking for
EX:
When I choose to search by Vendor, he wants for me to
enter in a Text the name of the vendor and quickly do a
report of that Vendor and the jobs and purchase oder that
are bound to the Vendor. The same as by PO Number and Job
Number.
I did this by doing a simple query, but he does't want
that he wants a search box and the the report to refresh
everytime a new "Vendor, or Job number, or Po number
changes. Is this is possible by maacros or do I have to
use VBA?, which I don't know how to use.
T.I.A.
Sophie
 
Hi Sophie,

I also create PO reports, etc. on my job.

You may want to try the following:

1. Create an unbound form Named Search with three unbound
text boxes. Name them VenSearch POSearch and JobSearch

2. Go to your current simple query design view and Under
your Vendor column in the first Criteria row, type the
following [Forms]![Search]![VenSearch]. On the second
Criteria Row under your PO# column, type [Forms]![Search]!
[POSearch], then finally on the third Criteria Row under
your Job#, type Forms![Search]![Jobsearch].

3. Place a button on the form that will open your report
which will need to be based upon your newly revised query.

This new form will give your user an option to pull up the
report based on one or all of the search fields.

Hope this at least will point you in the general direction
you wish to go.
 
I did what you told me and it works but, when it comes to
PO Number, he then asks me parameter for the other
remainig fields.
WHAT SHOULD I DO?
T.I.A.
sophie
-----Original Message-----
Hi Sophie,

I also create PO reports, etc. on my job.

You may want to try the following:

1. Create an unbound form Named Search with three unbound
text boxes. Name them VenSearch POSearch and JobSearch

2. Go to your current simple query design view and Under
your Vendor column in the first Criteria row, type the
following [Forms]![Search]![VenSearch]. On the second
Criteria Row under your PO# column, type [Forms]![Search]!
[POSearch], then finally on the third Criteria Row under
your Job#, type Forms![Search]![Jobsearch].

3. Place a button on the form that will open your report
which will need to be based upon your newly revised query.

This new form will give your user an option to pull up the
report based on one or all of the search fields.

Hope this at least will point you in the general direction
you wish to go.
-----Original Message-----
I putting the finalizing touches on my database and my
boss want for me to have this:
When I go to the reports menu and select Purchase
orders, he want for me to have a search doen of the PO I'm
looking for
EX:
When I choose to search by Vendor, he wants for me to
enter in a Text the name of the vendor and quickly do a
report of that Vendor and the jobs and purchase oder that
are bound to the Vendor. The same as by PO Number and Job
Number.
I did this by doing a simple query, but he does't want
that he wants a search box and the the report to refresh
everytime a new "Vendor, or Job number, or Po number
changes. Is this is possible by maacros or do I have to
use VBA?, which I don't know how to use.
T.I.A.
Sophie

.
Click to expand...
.
Click to expand...
 
I see. Can you give me examples, whether they are dates
or other specifics?
-----Original Message-----
I did what you told me and it works but, when it comes to
PO Number, he then asks me parameter for the other
remainig fields.
WHAT SHOULD I DO?
T.I.A.
sophie
-----Original Message-----
Hi Sophie,

I also create PO reports, etc. on my job.

You may want to try the following:

1. Create an unbound form Named Search with three unbound
text boxes. Name them VenSearch POSearch and JobSearch

2. Go to your current simple query design view and Under
your Vendor column in the first Criteria row, type the
following [Forms]![Search]![VenSearch]. On the second
Criteria Row under your PO# column, type [Forms]! [Search]!
[POSearch], then finally on the third Criteria Row under
your Job#, type Forms![Search]![Jobsearch].

3. Place a button on the form that will open your report
which will need to be based upon your newly revised query.

This new form will give your user an option to pull up the
report based on one or all of the search fields.

Hope this at least will point you in the general direction
you wish to go.
-----Original Message-----
I putting the finalizing touches on my database and my
boss want for me to have this:
When I go to the reports menu and select Purchase
orders, he want for me to have a search doen of the PO I'm
looking for
EX:
When I choose to search by Vendor, he wants for me to
enter in a Text the name of the vendor and quickly do a
report of that Vendor and the jobs and purchase oder that
are bound to the Vendor. The same as by PO Number and Job
Number.
I did this by doing a simple query, but he does't want
that he wants a search box and the the report to refresh
everytime a new "Vendor, or Job number, or Po number
changes. Is this is possible by maacros or do I have to
use VBA?, which I don't know how to use.
T.I.A.
Sophie

.
Click to expand...
.
Click to expand...
.
Click to expand...
 
Back
Top