Hi, fairly new to the VBA world. I', trying to grab the Date Modified of a
table, how would I do this in VBA? I'm going to put this in a If statement.
If the table is over 7 days old than update data.

? CurrentDb.TableDefs("abc").Properties("LastUpdated")


as example.



Vanderghast, Access MVP



"Greg T" <(E-Mail Removed)> wrote in message
news:2819B011-46AB-4AD9-9000-(E-Mail Removed)...
> Hi, fairly new to the VBA world. I', trying to grab the Date Modified of
> a
> table, how would I do this in VBA? I'm going to put this in a If
> statement.
> If the table is over 7 days old than update data.
>

"Michel Walsh" <vanderghast@VirusAreFunnierThanSpam> replied in message
news:eNwgxZ$%(E-Mail Removed)...
>> Hi, fairly new to the VBA world. I', trying to grab the Date Modified
>> of a table, how would I do this in VBA? I'm going to put this in a If
>> statement. If the table is over 7 days old than update data.
>
>? CurrentDb.TableDefs("abc").Properties("LastUpdated")

Greg, Michel has answered your question, but I'm hoping you are clear that
this will tell you the date of the last design change, not when the data was
changed last.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

Add a field named DateModified to the table, Data Type of Date/Time,
Default Value of Now(). When records are inserted, the value is set to
the current date time. When you do updates, you need to update the
value to Now().

Good luck!

John

Greg T brought next idea :
> Hi, fairly new to the VBA world. I', trying to grab the Date Modified of a
> table, how would I do this in VBA? I'm going to put this in a If statement.
> If the table is over 7 days old than update data.