|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
July 21st, 2007, 03:13 PM
posted to microsoft.public.access.reports
|
|||
|
|||
Display File Date Modified
Hi,
How do I display the File Date Modified of the mdb file in a Report. Thanks for your help. Marv Trott 
|
|
#2
July 21st, 2007, 09:02 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Display File Date Modified
FileDateTime(CurrentDb.Name)
If you want a text box with that in it, you can set the text box's ControlSource to =FileDateTime(CurrentDb.Name). Alternatively, you can set the ControlSource to something like ="The file was last modified " & FileDateTime(CurrentDb.Name) -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "Marv" wrote in message ... Hi, How do I display the File Date Modified of the mdb file in a Report. Thanks for your help. Marv Trott
|
|
#3
July 22nd, 2007, 03:17 AM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Display File Date Modified
Hi,
To clarify my question: When I use this expresion [=CurrentProject.FullName] in a text Box how can I also show the Date the file was last modified? This is the information that is displayed in the Database Properties Window Thanks, Marv "Marv" wrote in message ... Hi, How do I display the File Date Modified of the mdb file in a Report. Thanks for your help. Marv Trott
|
|
#4
July 22nd, 2007, 11:43 AM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Display File Date Modified
Was there something wrong with the answer I gave you six hours before you
posted this follow up? Use the VBA FileDateTime function. =FileDateTime(CurrentProject.FullName) -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "Marv" wrote in message ... Hi, To clarify my question: When I use this expresion [=CurrentProject.FullName] in a text Box how can I also show the Date the file was last modified? This is the information that is displayed in the Database Properties Window Thanks, Marv "Marv" wrote in message ... Hi, How do I display the File Date Modified of the mdb file in a Report. Thanks for your help. Marv Trott
|
|
#5
July 22nd, 2007, 03:14 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Display File Date Modified
Doug,
Your answer was correct. I'm sorry about the second post which I made before I saw your answer. Thanks for your help. Marv "Douglas J. Steele" wrote in message ... Was there something wrong with the answer I gave you six hours before you posted this follow up? Use the VBA FileDateTime function. =FileDateTime(CurrentProject.FullName) -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "Marv" wrote in message ... Hi, To clarify my question: When I use this expresion [=CurrentProject.FullName] in a text Box how can I also show the Date the file was last modified? This is the information that is displayed in the Database Properties Window Thanks, Marv "Marv" wrote in message ... Hi, How do I display the File Date Modified of the mdb file in a Report. Thanks for your help. Marv Trott
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
