How can I allow comments by users in a report?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to set up a facsimile transmittal that will be printed.

Most of the fields can be retrieved throughout my database, but two sections:

1. The number of pages that will be faxed
and
2. Comments that the sender wants to write

are not found in any table, or query.

I want users to be able to put whatever they want in these fields.

Is a parameter query good for this?

How do I set up such a thing?
 
Just add an unboud field to your report and put something like...

=[EnterNumberofPages]

or...

=[TypeComment]


When the user runs the report, they will be prompted for the entries.


Rick B
 
Wonderful.

But what if they need to input more than one line for a comments field?



Rick B said:
Just add an unboud field to your report and put something like...

=[EnterNumberofPages]

or...

=[TypeComment]


When the user runs the report, they will be prompted for the entries.


Rick B



Monique said:
I want to set up a facsimile transmittal that will be printed.

Most of the fields can be retrieved throughout my database, but two sections:

1. The number of pages that will be faxed
and
2. Comments that the sender wants to write

are not found in any table, or query.

I want users to be able to put whatever they want in these fields.

Is a parameter query good for this?

How do I set up such a thing?
Click to expand...
Click to expand...
 
They should be able to type as much as they want in that field.

If you want, you could pop up a form and have the user fill in those two
value, then click a button on the form to run the report and get the data
from that form.

All depends on how much you want to put into it.

Rick B


Monique said:
Wonderful.

But what if they need to input more than one line for a comments field?



Rick B said:
Just add an unboud field to your report and put something like...

=[EnterNumberofPages]

or...

=[TypeComment]


When the user runs the report, they will be prompted for the entries.


Rick B



Monique said:
I want to set up a facsimile transmittal that will be printed.

Most of the fields can be retrieved throughout my database, but two sections:

1. The number of pages that will be faxed
and
2. Comments that the sender wants to write

are not found in any table, or query.

I want users to be able to put whatever they want in these fields.

Is a parameter query good for this?

How do I set up such a thing?
Click to expand...
Click to expand...
Click to expand...
 
I believe they can, but I need them to be able to hit enter, and start a new
'paragraph' if necessary.

The box needs to be able to expand (and auto-new line)if the information
exceeds the page limits.

Any other way to do this?

Rick B said:
They should be able to type as much as they want in that field.

If you want, you could pop up a form and have the user fill in those two
value, then click a button on the form to run the report and get the data
from that form.

All depends on how much you want to put into it.

Rick B


Monique said:
Wonderful.

But what if they need to input more than one line for a comments field?



Rick B said:
Just add an unboud field to your report and put something like...

=[EnterNumberofPages]

or...

=[TypeComment]


When the user runs the report, they will be prompted for the entries.


Rick B



I want to set up a facsimile transmittal that will be printed.

Most of the fields can be retrieved throughout my database, but two
sections:

1. The number of pages that will be faxed
and
2. Comments that the sender wants to write

are not found in any table, or query.

I want users to be able to put whatever they want in these fields.

Is a parameter query good for this?

How do I set up such a thing?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top