Hello,
I have two databases and I'd like a button in one to be able to open the other. I've written this code:
Call Shell ("""C:\Program Files\Microsoft Office\Office16\MSACCESS.EXE"" ""C:Users\me\myfilename.accdb")
This works like a charm to actually open the database but with one issue - the newly opened file is underneath the existing one and therefore not obviously visible to the user. Is there a way to force it to open over top, like a pop up window?
Thanks!
I have two databases and I'd like a button in one to be able to open the other. I've written this code:
Call Shell ("""C:\Program Files\Microsoft Office\Office16\MSACCESS.EXE"" ""C:Users\me\myfilename.accdb")
This works like a charm to actually open the database but with one issue - the newly opened file is underneath the existing one and therefore not obviously visible to the user. Is there a way to force it to open over top, like a pop up window?
Thanks!