Displaying Database change date in report heading

  • Thread starter Thread starter Marv
  • Start date Start date
M

Marv

Hi,

How do I capture and display the change date of the mdb file in the heading
of a report.

I'm using Access 2003.

Thanks,

Marv
 
Marv said:
How do I capture and display the change date of the mdb file in the
heading of a report.
Click to expand...

That would be:
=Date()

Unlike a Word or Excel document that only changes if you edit something, the
MDB file date changes when you open the file. So if you're in there, working
with reports, the MDB will have today's date.
 
Allen,

Thanks for your quick response.

After I read your answer I realized that I had ask the wrong questions.

The question should have been:

How do I display the date of the mdb file that I use as a source for my
report file?

I download a 165mb database every two weeks and use it to print a report in
another report generator program.

I had been using =Date() but this gave me the date of my report generator
mdf file.

I want to show the date of the source file in the heading of the reports so
there is no question when the roster was valid.

Marv
 
If it's an external file, you could use this kind of thing:
FileDateTime("C:\MyFolder\MyFile.mdb")

Let us know if that achieves what you want.
 
Allen,

It worked like a charm. Exactly what I needed.

Thanks

Marv

Also thanks to Chuck for the response. I will try to use it to learn more
about programming Access.

Marv
 
Chuck,

Although this fix could work I cannot use it since I only get a copy of the
master database each time from a location isolated from the main server for
security reasons.

Thanks,

Marv
 
Chuck,

The master database contains all the membership activities of our SCORE
Atlanta GA chapter and changes daily. The membership status changes slowly.
The report I created only uses the Membership Status fields.

However as we all know a published report only reflects the status of a
database on the date it was created. By including the date of the datafile
in the heading of the report it should alert the reader to the fact that the
viewed or printed report may be invalid after that date.

Thanks again for your continuing interest is helping solve this problem.

Marv
 
Back
Top