Hello,
I could do with some help. I have set up in excel, to import queries from access that refreshes every minute. These results update every minute but only when the access file is open on the same computer and a recent task on the database has taken place.
This database is used by several different people using their own laptops. The database queries are imported from excel to provide a live information feed displayed on a TV. The PC that will be running the excel programme will not be used by anyone and therefor the database will not be updated via this machine.
Do you know how I can get live information sent to excel, do I need to write code in excel to open the database and enter into a form on the splashboard, then close and set timing to run that every minute?
Should I write code in access to export the file to excel every minute, if I was to do that then would I need to write code into the excel file to close current file and then re-open straight away, to display the most up to date information on the TV?
Another option I'm considering is creating a 'ghost' database, which will run on the pc that the excel file is located, this will draw information from the main database that the users will fill in, from there I write code in the 'ghost' database to open and close a screen repetitavley and that will update the queries that refresh every minute in excel?
Which option is best and, what code can I use for opening and closing forms?
Thanks in advance.