Search results

Hi The "event" of opening Access (or some other event like a button) is set to cause excel to refresh so whenever you open Access your data is up-to-date automatically but I don't know a way of having Access running in the background and knowing that someone has completed the form and so respond...

I'm not sure of the problem you describe so I'll mention 2 things. (1) It might be as simple as making XLsheet2 the location linked to gsheet and then XLsheet1 cells equal to XLsheet2. I'll give more detailed sub-steps. in XLsheet go to Data-From Web and a little window opens up like a...

Here is my solution. My situation, I run a sporting comp - I want potential players to register using google forms. - Have the form saved in a googlesheet - Have the information from that sheet available to Access - Having manipulated information publish the draw etc to the web. I have seen a...

Here is my solution. My situation, I run a sporting comp - I want potential players to register using google forms. - Have the form saved in a googlesheet - Have the information from that sheet available to Access - Having manipulated information publish the draw etc to the web. I have seen...