asked on 10/10/2011

Adding filename and path on a report in Access 2007

I have used the code below to insert the database table name in a report, but it is not working in Access 2007. Can someone please tell me the new code to use.

=[CurrentDb].[Name]

Microsoft Access

Last Comment

Delores_C

10/10/2011

peter57r

10/10/2011

=currentproject.FullName

Dale Fye

10/10/2011

Where are you putting this value?

Have you tried: =Currentproject.fullname

Delores_C

10/10/2011

ASKER

text box, source code

Delores_C

10/10/2011

ASKER

I tried putting your code in the text, report footer. It did not work

Dale Fye

10/10/2011

strange, works for me.

Try this. Replace the textbox with a label (lbl_database).

Then in the report footers Format event, try this:

Private Sub ReportFooter_Format(Cancel As Integer, FormatCount As Integer)

Me.lbl_Database.Caption = CurrentProject.FullName

End Sub

peter57r

10/10/2011

Are you displaying your report in Preview or Report or Layout view?

Delores_C

10/10/2011

ASKER

Preview

Still getting an error. See exactly what I have entered and the message received

Private Sub ReportFooter_Format(Cancel As Integer, FormatCount As Integer)
Me.lbl.Database.Caption = CurrentProject.FullName
End Sub

Error Message received “ A custom macro in this report has failed to run, and is preventing the report from rendering.”

ASKER CERTIFIED SOLUTION

Dale Fye

10/10/2011

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

Delores_C

10/10/2011

ASKER

Thanks, it worked