In my database i have one blank table for store data that get from many query for share to other user use for make report or export to excell for what they want.
in my process :
1-I have one blank table
2-I create action query (delete query) for deleted previous data to make table clean prevent from duplicate data
3-I create action query (Append query) for add data from the query to the blank table
** I want to make command button with code that user can run those two queries in one click without confirm any question.
Thanks for any ideas.
Sokkheng
in my process :
1-I have one blank table
2-I create action query (delete query) for deleted previous data to make table clean prevent from duplicate data
3-I create action query (Append query) for add data from the query to the blank table
** I want to make command button with code that user can run those two queries in one click without confirm any question.
Thanks for any ideas.
Sokkheng