I have a "Form" in MS Access where I enter data, that in turn is
stored in a record in a "Table".
I created a button on the "Form" that runs a "Macro". It currently
exports data from a record# that I set in the macro to an html file,
in a Access default format. However, I would like it to do two
different things, that I cannot get to work properly.
1) I would like it export data from the current record, seen when
clicking on the button in the form view. So, I need to know how to
set the macro to export only the current record opened in the form
when I click the button, versus all records or the one I specify in
the macro.
2) I also cannot get a template html to work. I set the path, but it
never uses it when creating the new html file. I would like certain
variables to appear in certain spaces.
I have tried to read and follow pages upon pages of access
instructions. So, what I am looking for is a concise answer on how to
accomplish the above goals. Thank you in advance for your time. |