Search results

Hi Colin, Well as it happens this app has a 'dashboard' form which is always visible on screen, because it presents notifications to the user. So to do as you suggest is quite straightforward, especially since the mulitple form instances I spoke of are spawned from the dashboard too- makes...

Hi All, I'm working on a project where a user will typically have a number of minimised instances of an Access popup userform at the bottom of their screen - they're using Access 2016 on Windows 7. I'm setting the form caption in VBA to something appropriate for each instance, which is great...

I hope not, but possibly! I'm just researching that now. O365 makes extensive use of Sharepoint, OneDrive for Business is actually just that- as you can see from the path ([username]-my.sharepoint.com/personal/...) that you see when working with it. Anyhoo... I agree with you that it should...

Hi NauticalGent. Okay here is the scenario, and please forgive me for going through it step by step but I want to be clear about this in case what I am doing is not valid. I am no expert in Access! A Sharepoint list is created in Sharepoint 365 via the web interface- create a new site, then...

Hi All, What's the best practice for refreshing a table linked from a list in Sharepoint 365? I have tried: CurrentDb.TableDefs([table name]).RefreshLink Which works; however: * It is slow and impacts on the performance of Access * It seems to be only applicable to the the particular...

Hi Guys, Thank you very much for all of your replies. The fix was, as suggested by arnelgp, implementing a persistent connection to the BE by creating a form containing a view of the Sharepoint list, and running this form first. I'll simply hide it in the production app. I also implemented...

Hi guys, I'd appreciate your views on this odd thing... I'm building a system for a transport firm, using MS Powerapps which integrates to an Access app in the office. The system uses a number of Sharepoint lists as the point of integration, using Office 365. The Access DB is not currently...

Hi Everybody, My name is Alan Cordwell and I live in Sheffield, UK. I'm a professional freelance developer working mainly on web apps in PHP and MySQL but I do get the occasional job the requires Access and VBA. I find this forum invaluable (what would we do without forums?!) and thought its...