If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below. If you don't like Google AdSense in the posts, register or log in above.

Pivot tables Refresh within onClick()

Hi i would like when i select my button on my access form, for the file to refresh, at the moment i've got the code below to open the form, but i would like the data to be refreshed also, the data is coming from a connection to a Access database.

If at all possible i like to intergate the code into my on button click. or in the excel sheet.

Re: Pivot tables Refresh within onClick()

This may seem like a silly question, but my data is coming from a access database and i only have the work sheet name, but were do i name the pivot table or were can i find the default name this is given to it. maybe it's the sheet name ?