dlookup

[JudyT]

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

 

[UpRider]

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

 

[JudyT]

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
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....

="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

 

[UpRider]

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
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
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....

="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