KG Old Wolf
Board Regular
- Joined
- Sep 20, 2009
- Messages
- 65
All,
In one Excel workbook I have several MS Queries which use a common set of parameters to extract data from different tables in an Access database. These work fine. (The database is read-only.)
I created a user form to enter the needed parameters. This works fine.
I placed a command button on the form to "refresh all" queries once the new parameters are entered BUT the "refresh all" only works after the user closes the form using the "big red X".
I want to be able to refresh all queries and return the user to another form once the query data is updated. The code I'm using is very simple:
Private Sub CommandButton1_Click()
ActiveWorkbook.RefreshAll
End Sub
This works if I just place a command button on the Excel worksheet but not in a user form; clearly missing something. Any ideas?
In one Excel workbook I have several MS Queries which use a common set of parameters to extract data from different tables in an Access database. These work fine. (The database is read-only.)
I created a user form to enter the needed parameters. This works fine.
I placed a command button on the form to "refresh all" queries once the new parameters are entered BUT the "refresh all" only works after the user closes the form using the "big red X".
I want to be able to refresh all queries and return the user to another form once the query data is updated. The code I'm using is very simple:
Private Sub CommandButton1_Click()
ActiveWorkbook.RefreshAll
End Sub
This works if I just place a command button on the Excel worksheet but not in a user form; clearly missing something. Any ideas?
