Okay, below is what i have for a text field in a report....
="Performance Information " & [Enter a User Name] & "
for the period between " & Format([Enter a Start Date],"mmm dd"", ""yyyy") &
" and " & Format([Enter an End Date],"mmm dd"", ""yyyy")
However, I want the Enter a User Name to lookup in the User table the if
someone is to use the Informal of their first name (i.e. Nick) for Nicholas I
want the Dlookup to pull the field first name; instead of the informal name
field. Can someone help me? Please
Judy, I assume that each time the report is run, it reports one person.
There are some conceptual problems here: What if the person requesting the
report types in a name that doesn't match? What happens if it matches more
than one name? What if s/he's not sure of the name because others are close?
You would be much better off by using a dialog form with a combo box that
displays the User Names from the User table and lets the operator choose
one. This would allow you to use the informal name from the get-go.
A second problem is that you can't request user input from text boxes in a
report. The 2 date parameters should be added to the query that is the
recordsource for the report, or better they can be eliminated by the
operator entering them in text boxes on the form along with the User Name
combobox. Then modify the query to look at the form for the three entered
variables.
Add a command button on the form so that after the three fields are filled
in, a click event procedure could run the report.
HTH, UpRider
> Okay, below is what i have for a text field in a report....
>
[quoted text clipped - 9 lines]
> name
> field. Can someone help me? Please
JudyT - 30 Jul 2007 13:30 GMT
It will only ever be "ONE" person at a time and it doesn't matter if the
person requesting is the person they are seeking! It will never be >1 person
at a time. this will be done by supervisor and they know "intimately their
name". If you could not answer my question, don't post
it!!!!!!!!!!!!!!!!!!111
> Judy, I assume that each time the report is run, it reports one person.
> There are some conceptual problems here: What if the person requesting the
[quoted text clipped - 27 lines]
> > name
> > field. Can someone help me? Please
UpRider - 30 Jul 2007 21:56 GMT
OK, I won't do it again. Sorry our time together couldn't have been more
pleasant.
UpRider
> It will only ever be "ONE" person at a time and it doesn't matter if the
> person requesting is the person they are seeking! It will never be >1
[quoted text clipped - 42 lines]
>> > name
>> > field. Can someone help me? Please