L
Les
Hello all,
I was given the advice below by Justin Hoffman for my problem of
refreshing my tables the first time the DB is opened and not again
until the next day after 11am, but as a newbie i am not sure how to do
it, could somebody help me out please?
Create a new table to hold general info about the database e.g.
tblDbInfo
give it an ID column of type long with a validation rule of "=1" so the
table can only ever have one row. Another column should be
LastImportDate =
Date/Time.
The import routine should update the LastImportDate column after it has
finished, so then when somebody ones the database the macro only runs
if
this field is at least 1 day old.
I was given the advice below by Justin Hoffman for my problem of
refreshing my tables the first time the DB is opened and not again
until the next day after 11am, but as a newbie i am not sure how to do
it, could somebody help me out please?
Create a new table to hold general info about the database e.g.
tblDbInfo
give it an ID column of type long with a validation rule of "=1" so the
table can only ever have one row. Another column should be
LastImportDate =
Date/Time.
The import routine should update the LastImportDate column after it has
finished, so then when somebody ones the database the macro only runs
if
this field is at least 1 day old.