Proper case and passing parameters

  • Thread starter Thread starter JimS
  • Start date Start date
J

JimS

I am trying to standardize the data in a text field. The data represents
names and I would like to use the strComp with vbProperCase to that they all
have the same look. Can this be done on a report?

I would like the headers for a report to be dynamic. I am using a report to
run a query. I would like the parameter for the query to be in the header
of the report. How can i do this?

Thanks for any and all help!
 
Jim:

I am uncertain exactly what you are trying to do with respect to your first
question.

With regard to your second question, you should be able to set the Control
Source property equal to the name of your query input parameter to show its
value in the report header.

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


I am trying to standardize the data in a text field. The data represents
names and I would like to use the strComp with vbProperCase to that they all
have the same look. Can this be done on a report?

I would like the headers for a report to be dynamic. I am using a report to
run a query. I would like the parameter for the query to be in the header
of the report. How can i do this?

Thanks for any and all help!
 
I am sorry David...et all
I am trying to proper case names on a report. I thought I would be able to
use a function but I havent been able to get it to work The function that I
would really like to have work is the strComp function.
Thanks


I am trying to standardize the data in a text field. The data represents
names and I would like to use the strComp with vbProperCase to that they all
have the same look. Can this be done on a report?

I would like the headers for a report to be dynamic. I am using a report to
run a query. I would like the parameter for the query to be in the header
of the report. How can i do this?

Thanks for any and all help!
 
Hello
I have tried this and it keeps prompting again for the input of the
parameter. Is their a way around this behavior?

Example:
Field name = birthday
table = members
sort = ascending
criteria = >=[?start date] And <=[?end date]

If its set to birthday its reported as the first birthday record. I would
rather report the range the the start and end date represent.

Thanks


Jim:

I am uncertain exactly what you are trying to do with respect to your first
question.

With regard to your second question, you should be able to set the Control
Source property equal to the name of your query input parameter to show its
value in the report header.

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


I am trying to standardize the data in a text field. The data represents
names and I would like to use the strComp with vbProperCase to that they all
have the same look. Can this be done on a report?

I would like the headers for a report to be dynamic. I am using a report to
run a query. I would like the parameter for the query to be in the header
of the report. How can i do this?

Thanks for any and all help!
 
Jim:

If [?Start Date] and [?End Date] are your parameters, your report should
recognize references to these parameters as if they were fields in your
query. For example, if you had a textbox in the header and wanted to
display the start and end dates, the Control Source property for the textbox
might look something like the following:

="From: " & [?Start Date] & " To: " & [?End Date]

Obviously, you will need to adjust this to your specific needs.

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


Hello
I have tried this and it keeps prompting again for the input of the
parameter. Is their a way around this behavior?

Example:
Field name = birthday
table = members
sort = ascending
criteria = >=[?start date] And <=[?end date]

If its set to birthday its reported as the first birthday record. I would
rather report the range the the start and end date represent.

Thanks


Jim:

I am uncertain exactly what you are trying to do with respect to your first
question.

With regard to your second question, you should be able to set the Control
Source property equal to the name of your query input parameter to show its
value in the report header.

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


I am trying to standardize the data in a text field. The data represents
names and I would like to use the strComp with vbProperCase to that they all
have the same look. Can this be done on a report?

I would like the headers for a report to be dynamic. I am using a report to
run a query. I would like the parameter for the query to be in the header
of the report. How can i do this?

Thanks for any and all help!
 
Jim:

My understanding of the strComp function is that it is used to compare two
strings. I am not sure how you plan to use strComp to generate proper case
names. You'll have to provide more information about what you are
attempting to do, including an example if possible.

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


I am sorry David...et all
I am trying to proper case names on a report. I thought I would be able to
use a function but I havent been able to get it to work The function that I
would really like to have work is the strComp function.
Thanks


I am trying to standardize the data in a text field. The data represents
names and I would like to use the strComp with vbProperCase to that they all
have the same look. Can this be done on a report?

I would like the headers for a report to be dynamic. I am using a report to
run a query. I would like the parameter for the query to be in the header
of the report. How can i do this?

Thanks for any and all help!
 
I am sorry...way too long a day! I typed the wrong function. I am trying
to proper case names in a report. The names are contained in fields. I was
trying to accomplish the conversion by using the StrConv function. This
should work as follows (well this is how I understand the function)
StrConv([field_name], vbProperCase). I am having problems with this
function in a report. It doesnt seem to recognize that its a function call.
I dont show any missing references but I didnt add any additional modules to
the project.

Thanks


Jim:

My understanding of the strComp function is that it is used to compare two
strings. I am not sure how you plan to use strComp to generate proper case
names. You'll have to provide more information about what you are
attempting to do, including an example if possible.

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


I am sorry David...et all
I am trying to proper case names on a report. I thought I would be able to
use a function but I havent been able to get it to work The function that I
would really like to have work is the strComp function.
Thanks


I am trying to standardize the data in a text field. The data represents
names and I would like to use the strComp with vbProperCase to that they all
have the same look. Can this be done on a report?

I would like the headers for a report to be dynamic. I am using a report to
run a query. I would like the parameter for the query to be in the header
of the report. How can i do this?

Thanks for any and all help!
 
Jim:

I think the issue is with the vbProperCase constant which is not recognized
in the report. If you substitute the value of 3 for this named constant, I
believe it will process the strConv function for you in the report.

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


I am sorry...way too long a day! I typed the wrong function. I am trying
to proper case names in a report. The names are contained in fields. I was
trying to accomplish the conversion by using the StrConv function. This
should work as follows (well this is how I understand the function)
StrConv([field_name], vbProperCase). I am having problems with this
function in a report. It doesnt seem to recognize that its a function call.
I dont show any missing references but I didnt add any additional modules to
the project.

Thanks


Jim:

My understanding of the strComp function is that it is used to compare two
strings. I am not sure how you plan to use strComp to generate proper case
names. You'll have to provide more information about what you are
attempting to do, including an example if possible.

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


I am sorry David...et all
I am trying to proper case names on a report. I thought I would be able to
use a function but I havent been able to get it to work The function that I
would really like to have work is the strComp function.
Thanks


I am trying to standardize the data in a text field. The data represents
names and I would like to use the strComp with vbProperCase to that they all
have the same look. Can this be done on a report?

I would like the headers for a report to be dynamic. I am using a report to
run a query. I would like the parameter for the query to be in the header
of the report. How can i do this?

Thanks for any and all help!
 
Back
Top