Access 2003 Bugs

B

Brennan

Hello:

I have recently begun to use Office 2003 (SP1) and I am noticing a problem
with Microsoft Access. In one case, I have a query that has a date
parameter. Nothing fancy, just gives me all the records requested between
date1 and date2. When I run the query, it doesn't return the correct number
of records. When I remove the parameter, it works fine. When I put it back,
it causes the same problem. I know for a fact that the syntax is correct.

Another problem I am having is that I am trying to change the format of a
report to legal from letter. The program let's me make all of the
appropriate selections but it doesn't apply them to the report.

Are these known bugs or is something funky going on with my install?

I also tried it on another PC running Office 2003 and got the same issues.

Thanks
Brennan
 
W

Wayne Morgan

For the date parameter problem, have you defined the parameter as a date
data type? This tends to be a problem with dates. To define the data type,
first make sure that the data type in the table is Date/Time. Next, if this
parameter isn't hard coded into the query, open the query in design view. Go
to Query|Parameters on the menu bar. Copy and paste the name of the
parameter into the dialog box and set its data type to Date/Time. The
resulting SQL will look something like:

PARAMETERS [Enter Start Date] DateTime, [Enter End Date] DateTime;
SELECT ......
or
PARAMETERS [Forms]![MyForm]![txtMyTextbox] DateTime;
SELECT .....

In what way are the selections not being applied to the report? It won't
change the size of the report in design view, going from letter to legal
will just let more records print in the detail area. Do you have any code
that limits the number of records that print per page? Could your printer
driver be over riding the setup?
 
Top