Entering miscellaneous information into a report

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

Guest

I have created a standard report which runs off of a query. The report is
going to be used as a packing slip, sent with equipment that has been
purchased from were I work. At the bottom I included a Comments/Additional
Items Ordered section. Originally the person filling out the packing slip
would be hand writting this information in, but the owner has decided that he
would like it typed in instead. Is there a way that this can be done prior
to printing the report out? A data entry pop up box maybe that will appear
after they select the record number they want to print? I am very new to
Access and would really appreciate step by step how to's in plain English (I
don't get expressions at all, they confuse me to no end!)

Thank you so much, I really appreciate all the help I can get on this!!!!!!

Teri C.
 
Add an UNBOUND TEXT BOX on your report where you'd like the data to print.
In it put something like the following...

=[Enter Comments to Appear on Form]


This will cause the prompt you want and whatever the user enters will appear
on your report.
 
I tried it and it does give me the dialog box I was hoping for, I also found
that when the report comes up after I go through these dialog boxes it says
"Error" where the information is supposed to appear. Is there a special
formatting option I need to do or a limit on characters (though it says error
even if I don't enter anything).

thanks again,

Teri.



Rick B said:
Add an UNBOUND TEXT BOX on your report where you'd like the data to print.
In it put something like the following...

=[Enter Comments to Appear on Form]


This will cause the prompt you want and whatever the user enters will appear
on your report.

--
Rick B



Teri said:
I have created a standard report which runs off of a query. The report is
going to be used as a packing slip, sent with equipment that has been
purchased from were I work. At the bottom I included a
Comments/Additional
Items Ordered section. Originally the person filling out the packing slip
would be hand writting this information in, but the owner has decided that
he
would like it typed in instead. Is there a way that this can be done
prior
to printing the report out? A data entry pop up box maybe that will
appear
after they select the record number they want to print? I am very new to
Access and would really appreciate step by step how to's in plain English
(I
don't get expressions at all, they confuse me to no end!)

Thank you so much, I really appreciate all the help I can get on
this!!!!!!

Teri C.
 
That should not happen if it is in an unbound text box. Open the properties
box and tell us what you have for that object. What is in the "Control
Source"?
Also, what is the "Name"?


--
Rick B



Teri said:
I tried it and it does give me the dialog box I was hoping for, I also
found
that when the report comes up after I go through these dialog boxes it
says
"Error" where the information is supposed to appear. Is there a special
formatting option I need to do or a limit on characters (though it says
error
even if I don't enter anything).

thanks again,

Teri.



Rick B said:
Add an UNBOUND TEXT BOX on your report where you'd like the data to
print.
In it put something like the following...

=[Enter Comments to Appear on Form]


This will cause the prompt you want and whatever the user enters will
appear
on your report.

--
Rick B



Teri said:
I have created a standard report which runs off of a query. The report
is
going to be used as a packing slip, sent with equipment that has been
purchased from were I work. At the bottom I included a
Comments/Additional
Items Ordered section. Originally the person filling out the packing
slip
would be hand writting this information in, but the owner has decided
that
he
would like it typed in instead. Is there a way that this can be done
prior
to printing the report out? A data entry pop up box maybe that will
appear
after they select the record number they want to print? I am very new
to
Access and would really appreciate step by step how to's in plain
English
(I
don't get expressions at all, they confuse me to no end!)

Thank you so much, I really appreciate all the help I can get on
this!!!!!!

Teri C.
 
I got it! Thanks Rick B! You have been a tremendous help!!!

Rick B said:
That should not happen if it is in an unbound text box. Open the properties
box and tell us what you have for that object. What is in the "Control
Source"?
Also, what is the "Name"?


--
Rick B



Teri said:
I tried it and it does give me the dialog box I was hoping for, I also
found
that when the report comes up after I go through these dialog boxes it
says
"Error" where the information is supposed to appear. Is there a special
formatting option I need to do or a limit on characters (though it says
error
even if I don't enter anything).

thanks again,

Teri.



Rick B said:
Add an UNBOUND TEXT BOX on your report where you'd like the data to
print.
In it put something like the following...

=[Enter Comments to Appear on Form]


This will cause the prompt you want and whatever the user enters will
appear
on your report.

--
Rick B



I have created a standard report which runs off of a query. The report
is
going to be used as a packing slip, sent with equipment that has been
purchased from were I work. At the bottom I included a
Comments/Additional
Items Ordered section. Originally the person filling out the packing
slip
would be hand writting this information in, but the owner has decided
that
he
would like it typed in instead. Is there a way that this can be done
prior
to printing the report out? A data entry pop up box maybe that will
appear
after they select the record number they want to print? I am very new
to
Access and would really appreciate step by step how to's in plain
English
(I
don't get expressions at all, they confuse me to no end!)

Thank you so much, I really appreciate all the help I can get on
this!!!!!!

Teri C.
 
Back
Top