Display name of current file or current db (1 Viewer)

B

brucesilvers

Registered User.

Local time

Today, 01:19

Joined

Aug 4, 2000

Messages

70

• Dec 9, 2004

• #1

I know I can use Date() to display the current system date on a report.

Is there a similar command to display either the name of the current file or the name of the current database?

Thanks!!

 

W

WayneRyan

AWF VIP

Local time

Today, 09:19

Joined

Nov 19, 2002

Messages

7,122

• Dec 10, 2004

• #2

Bruce,

How 'bout CurrentDb.Name

Wayne

 

B

brucesilvers

Registered User.

Local time

Today, 01:19

Joined

Aug 4, 2000

Messages

70

• Dec 10, 2004

• #3

Thanks. I'd hoped there was something that could be used within the report-design GUI, similar to &[Page].

 

P

Pat Hartman

Super Moderator

Staff member

Local time

Today, 04:19

Joined

Feb 19, 2002

Messages

43,233

• Dec 10, 2004

• #4

add an unbound control and use the given expression as its controlsource:

=CurrentDb.Name

 

B

brucesilvers

Registered User.

Local time

Today, 01:19

Joined

Aug 4, 2000

Messages

70

• Dec 13, 2004

• #5

Thanks again!

As always, you've been very helpful