Formatting and Report Header Issues

[Phillip Topping]

Hi there,
I have 2 questions, hopefully somebody can help me out.

The first one should be fairly simple, even if I cannot solve it.

I would like to know how I can format a text box on a form so that no matter
how the text is entered, it will be formatted
in Sentence case. I know Access can force txt to all upper case or all
lower case.....but how do I make the box contents to appear
as sentence case?

The 2nd question relates to inserting a chart in a report based on a
parameter query.

How do I stop Access asking me twice for the Start Date and End Dates?

Whenever I run the report it asks twice, once for the query and then once
again to build the chart in the report.

Shown below is the query used to build the chart.

SELECT (Format([Date of Incident],"MMM \'YY")),Count([Break and Enter]) AS
[CountOfBreak and Enter] FROM [Break and Enter] GROUP BY (Year([Date of
Incident])*12 + Month([Date of Incident])-1),(Format([Date of Incident],"MMM
\'YY"));


Is there a way around this??

Regards
Phillip

 

[Jim/Chris]

Question #2
Have your start date and end dates in unbound text boxes on
a form. Reference these dates in the criteria in the query
and in the control source of the field on the report.
[Forms]![form name]![start date]
[Forms]![form name]![end date]

Jim

-----Original Message-----
Hi there,
I have 2 questions, hopefully somebody can help me out.

The first one should be fairly simple, even if I cannot solve it.

I would like to know how I can format a text box on a form so that no matter
how the text is entered, it will be formatted
in Sentence case. I know Access can force txt to all upper case or all
lower case.....but how do I make the box contents to appear
as sentence case?

The 2nd question relates to inserting a chart in a report based on a
parameter query.

How do I stop Access asking me twice for the Start Date and End Dates?

Whenever I run the report it asks twice, once for the query and then once
again to build the chart in the report.

Shown below is the query used to build the chart.

SELECT (Format([Date of Incident],"MMM

\'YY")),Count([Break and Enter]) AS

[CountOfBreak and Enter] FROM [Break and Enter] GROUP BY (Year([Date of
Incident])*12 + Month([Date of Incident])-1),(Format([Date of Incident],"MMM
\'YY"));


Is there a way around this??

Regards
Phillip


.

 

[Larry Daugherty]

Hi Phillip,

StrConv() will answer your first question as asked. You'll find it in the
Access VBA reference.

A common way around the persistent popups in parameter queries is to create
a form to gather data and to launch your report. In other words, when
you're ready to generate the report your command button or other calling
mechanism will open the form instead. The form will have a text box for
each required parameter (you should write some validation code to assure
that the user has filled al blanks - could be as simple as testing for a
blank text box). Leave the form open as you launch your report. You can
have your report close the form as part of its termination. The ~OK command
on your form will launch the report. The parameter fields of the report's
query will refer back to the form and the appropriate field on it.

It's considered good form to ask only related, single subject, questions in
a single posting. I.e. trying to solve a single problem. I recommend a
visit to http://mvps.org/access You'll find a wealth of Access related
info and a netetiquette heading that gives guidelines for using the
newsgroups.

HTH