Displaying Database change date in report heading

[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

 

[Allen Browne]

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

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.

 

[Marv]

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

 

[Allen Browne]

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.

 

[Marv]

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

 

[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]

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

Talk to the folks that maintain the master database and see if they can make
the necessary changes.

Chuck

 

[Chuck]

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.

If the data does not exist in the database you get, maybe you could get a list
of log off date/times for the individuals who are authorized to enter/edit data
and use the last log off date/time. However, as Allen stated, just because
someone opened the database does no mean the they made any changes.

Basically, if the data does not exist somewhere, you can not include it in a
report.

I'm with Allen. Just use the date the report was printed (or the date you
received it). This tells the reader that no changes made after that date can
be in the report. This is not such a bad idea. I'll bet that the database is
constantly kept up to date and what is delivered to you has the very latest
updates included.

Chuck

 

[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