M
Mike
I have a database that I've put together that consists of three letters that
need to be generated for the user. Each letter has its own query that I have
already built which determines which records belong in which category. Again
there are only 3 letters/categories in which can be generated. At the
moment, I've created a form with seperate buttons that run each function.
For instance, on the form, I have a button called "Update Letter A", which in
turn runs the query I have built specifically for that letter. This is a
make table query so after it is ran, the table associated with this query
gets updated. After that is selected the user presses the "Merge Letter A"
button. This in turn opens another form where the user must select the
letter AGAIN and run the merge again. This part was created from finding
pieces of information on the internet and a whole lot of trial and error in
order to get it work. It works however what I'm trying to do is press ONE
button that does it all. Like a macro of some sort. Is there a way that I
can create a button that simply runs the queries which differentiate the
letter type, updates the table data to be merged, then opens MS Word and
merges the data? If so, how would I go about doing this?
need to be generated for the user. Each letter has its own query that I have
already built which determines which records belong in which category. Again
there are only 3 letters/categories in which can be generated. At the
moment, I've created a form with seperate buttons that run each function.
For instance, on the form, I have a button called "Update Letter A", which in
turn runs the query I have built specifically for that letter. This is a
make table query so after it is ran, the table associated with this query
gets updated. After that is selected the user presses the "Merge Letter A"
button. This in turn opens another form where the user must select the
letter AGAIN and run the merge again. This part was created from finding
pieces of information on the internet and a whole lot of trial and error in
order to get it work. It works however what I'm trying to do is press ONE
button that does it all. Like a macro of some sort. Is there a way that I
can create a button that simply runs the queries which differentiate the
letter type, updates the table data to be merged, then opens MS Word and
merges the data? If so, how would I go about doing this?