R
Robert Williamson
I am trying to create a macro that will look into a table
if possible to see what values are in the date field, I
ain't having any luck.
I need it to stop further processing of the macro if it
finds a record that matches the current date. My thinking
was to use something like now()=[issued date] and the
macro action would display a message box stating that a
report for this day had already been done and then it
would stop, if the above was not true it would generate a
report and use an update query to change the value in the
table to the current date.
I have been unable to get this to work with a table or
query, I have been forced to use a Form. Howeber the
macro appears to be having a problem with the now()
request on the form as it does not acknowledge it and
processes the full macro. I have changed the condition as
a test to [issued date] is null to see what would happen
with a nil entry in the table and it ackowledged this and
stopped the macro.
I hope I have made some sence and would appreciate any
help offered.
thanks
if possible to see what values are in the date field, I
ain't having any luck.
I need it to stop further processing of the macro if it
finds a record that matches the current date. My thinking
was to use something like now()=[issued date] and the
macro action would display a message box stating that a
report for this day had already been done and then it
would stop, if the above was not true it would generate a
report and use an update query to change the value in the
table to the current date.
I have been unable to get this to work with a table or
query, I have been forced to use a Form. Howeber the
macro appears to be having a problem with the now()
request on the form as it does not acknowledge it and
processes the full macro. I have changed the condition as
a test to [issued date] is null to see what would happen
with a nil entry in the table and it ackowledged this and
stopped the macro.
I hope I have made some sence and would appreciate any
help offered.
thanks