I record a macro when I do the MS query data.
The resulted macro as follow :
The "bulan" means Month, The "tahun" means Year.
My plan is that before the query runs, I use application.inputbox (or maybe listbox/combobox with month option in userform),
so the user can input what month and year he wants to query.
To check whether it will work or not, I've tried this first:
But it doesn't work.
It didn't threw me an error message, but the query result contains all months which are in the "linked" data.
How do I have to code ?
And also, as seen in the recorded macro - what does it mean
Any kind of help would be greatly appreciated.
Thank you in advanced.
Bookmarks