Recent content by PGL

Chart issues: Can you please assist me with the code to resolve these problems in MS Access?

Thank you Pat, Scenario 1: Access cannot copy the sheets from SharePoint. BUT, SP can export the sheets to a local hard drive effectively and keep it 'mirrored'. The problem here is that the exported sheet's extention is .iqy and Access does not recognised it. Scenario 2: I can try this but...

I have a number of Excel spreadsheets (data sources) hosted on Sharepoint that I need to link to one single Access database. At first. I cannot link the spreadsheets directly to Access because Access cannot read the spreadsheets on SharePoint to make the links. Secondly, I can export the...

Tx, but is still funny that the de activated choice remains the same as the activated choice. Can you perhaps send me an example of where and how to use Currentdb.Execute and dbFailOnError please? Appreciate Tx

Hi, I have a huge database with many Action Queries. I cannot "hide" the Action Query Messages like SetWarnings previously. My setting in properties is not active. See pic.......... Tx

Hi, I managed to compile Bar Charts but no Pie Charts. :mad:

Tx.............

Any new ideas?

Let's try again..........

I hope the attachment went through.

Tx..... yes everything is OK there.

As soon as I try to create a PivotChart, the form screen goes blank or the dropzones vanishes. Any advice please. :banghead:

Is it possible to link a PivotChart created in Exel to Access - without VBA code?

Hi All, I have a db with about 30 tables. What is the easiest (if possible) to copy field names to paste it into Exel or Word? I need to distribute it to other people. Tx for your help. PG

Thank you for your prompt responses. sxschech: Unfortunately no two reports are the same. Pat Hartman: I will try and see how the Themes option will work. Even if it is probably too late, I will anyway try it on existing reports. Many thanks to you two.