I am using access 2003 and have created a form that works great, then within the form i have also created a query. Also works super.
My problem is that i want to now create a button that will export all the columns in that query to excel or use that same query withing the column to do a mail merge to a document in word.
I would like to do all this with a button. Of course i will have to do some coding in VBA and thats what i need to know most of all....
thank you in advance for anyones help.
ben
My problem is that i want to now create a button that will export all the columns in that query to excel or use that same query withing the column to do a mail merge to a document in word.
I would like to do all this with a button. Of course i will have to do some coding in VBA and thats what i need to know most of all....
thank you in advance for anyones help.
ben