Print the location of the batadase on the report

[Karen]

Could anyone help me put the path and the data base name
on the report. I am working with Access 2000.

Thanks

 

[Sandra Daigle]

Add an unbound textbox to the report and then using one of the format event
for the appropriate section assign the value like this:

Private Sub ReportHeader_Format(Cancel As Integer, FormatCount As Integer)
Me.Text13 = CurrentDb().Name
End Sub

 

[Karen]

I can only put an expression in the data field of an
unbound text box. I am working with Access 2000. Does it
ahve anything to do with it?

-----Original Message-----
Add an unbound textbox to the report and then using one of the format event
for the appropriate section assign the value like this:

Private Sub ReportHeader_Format(Cancel As Integer, FormatCount As Integer)
Me.Text13 = CurrentDb().Name
End Sub

--
Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.

Could anyone help me put the path and the data base name
on the report. I am working with Access 2000.

Thanks

.

 

[Sandra Daigle]

Hi Karen,

I'm not sure what you mean. The code I gave you is VBA that would go into an
Event Procedure.

Are you saying that you can't use VBA?

--
Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.

I can only put an expression in the data field of an
unbound text box. I am working with Access 2000. Does it
ahve anything to do with it?

-----Original Message-----
Add an unbound textbox to the report and then using one of the
format event for the appropriate section assign the value like this:

Private Sub ReportHeader_Format(Cancel As Integer, FormatCount As
Integer) Me.Text13 = CurrentDb().Name
End Sub

--
Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.

Could anyone help me put the path and the data base name
on the report. I am working with Access 2000.

Thanks

.

 

[Karen]

Thanks Sandra

It workd!!! It was my mistake.

Karen

 

[Sandra Daigle]

No problem - glad it's working now.