Default format

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tcs - 08 Oct 2004 19:34 GMT

I'm trying to set up a default report format and found some info yesterday on
how to do it, from Allen Browne. Well, I'm having problems. In the lower left
corner I like to print the date and time. So I'm using:

="Date " & [Date] & "- Time " & [Time]

I copied this from the pages example that was included with the instructions:

="Page " & [Page] & " of " & [Pages]

My problem is that when I run this report, the query asks not only for the
PropCode (which it should), but also the "Date", "Time", and "Report Name:".

=[Report].Caption

BTW - this Access has changed from:

=[Report].[Caption]

and it won't leave it alone. And I'm not even sure this is where the prompt for
"Report Name:" is coming from. Even if I supply an answer, Access still doesn't
print anything. The box for the heading comes out blank.

What am I doing wrong?

I'm using Access 2000, SP-3.

Thanks in advance,

Tom

Reply to this Message

fredg - 08 Oct 2004 20:21 GMT

> I'm trying to set up a default report format and found some info yesterday on
> how to do it, from Allen Browne. Well, I'm having problems. In the lower left
[quoted text clipped - 26 lines]
>
> Tom

Is this all being done in a control's control source"
The functions in Access are Date() or Time() not [Date] or [Time].
In VBA code you would use Date or Time (but NOT within brackets].
That's telling Access it is a Field Name, and your parameter prompts
are asking for data that should be in a field.

Add an unbound control to your report.
Set it's control source to:
="Date " & Date() & "- Time " & Time()

Why not simply use:
=Now()
and format the control to General Date ?

On a multi-page report, the time will increment on each page.
You might want to have it print on just the first or final page.

Add another unbound control to the report.
If you wish the report's caption (if there is one),
set it's Control Source to:

= Caption

If you wish the report's name set it's control source to:

= Name

Signature

Fred
Please only reply to this newsgroup.
I do not reply to personal email.

Reply to this Message