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...