Forum Discussion
Multiple similar Tables in you database, is it possible to run queries etc by pre selecting.....
Hi, I have a number of similar linked sharepoint lists in a database, specific to different job sites, is it possible to run queries and forms on a particular job only, by selecting the job I want to work on by using a button / combo box on a menu screen?
You asked the same question here:
If you have multiple similar Tables in you database, is it possible to - Microsoft Community
4 Replies
You asked the same question here:
If you have multiple similar Tables in you database, is it possible to - Microsoft CommunityYes that is correct.
Hi,
If I understand you correctly you want to use/select different Sharepoint lists as source of queries and forms by choosing them in a "menu screen" = form?
If yes, then you could create a form with e.g. a list box or combo box with the names of the Sharepoint lists, select one from the list and write/execute VBA code in the After Update event of the list/combo box that changes the SQL text (especially the FROM clause) of the queries you want to use directly or as record source of forms.
Servus
Karl
****************
Access Forever News DevCon
Access-Entwickler-Konferenz AEKKarl
Thank you for your advice. I will give this a go.
Henry
