I need to instantiate Word docs from Access VBA and read the data therein, and I can read the various controls but not the drop down choice that was selected by the user. Trawling the internet I could only find a way to access the index number that was used but it appears that there is no way...
Perhaps, but the only way the large corporation can get this through without months of committee meetings is to use Access a smallish Office tool. .....
We need to install a database and make data accessible across the internet (via XML/txt or linked tables - can someone give me pointers on this ?
Microsoft's website has a page 'Creating a Web Service data connection' where Access 2010 can create a web service to a source and apparently link...
GaryPanic was probably right - if the fields/fieldname are not coming across from Excel it is proably becaue the need renaming to be acceptable for Access.
For your report, there are numbers of ways to do it - one way is:
To run your report: functionally your user should make their selection...
I have created a report, query and graph ("Combination" Type graph).
The Graph measures 5 indices correctly, changing across the 12 months (along the X axis), BUT my problem is that the system automatically decides which data series is going to be reflected as a line and which by a...