Recent content by Supertension

Perfect, thank you.

Hi, I'm using the report drawing methods when the detail section of a report formats (see Access ReportDraw (msaccessgurus.com) for an excellent reference). I'm drawing some geometric shapes and labeling them with some text. I have a problem with the Report.Print method and can't get it to...

I ended up using the series names from the query as you suggest. I have to say I find it strange that it is not possible/obvious to work with series names in Access but at least I have a way ahead now.

Hi, I have a classic chart in an access form and am trying to get a list of the names of the data series. I've pasted my code below and have marked where get an error. Can someone tell me what I am doing wrong? If I happen to know the name of a data series, I can access it. For example...

Hi, I wonder if @JoeJimenezMicrosoft has any feedback on the possible bug issue with spaces in local PDFs. Thanks.

Hi, Thanks for your reply. I'd already tried the Word viewer but, unfortunately, it allows users to make a copy in a Word document.

Hi, I can open a Word document as read only from Access but I'd also like to be able to prevent users using Save As to save a copy of the document. I can turn off Save As by writing some code within the Word document but I'd like to keep the Word document code free and control everything from...

I tried the "let me fix it myself" route suggested by arnelgp and it works perfectly. Thanks for all your help.

Thanks. I tried the DB posted by JHB but got the same problem - Word itself opens in a separate window. I'll try the "let me fix it myself" route suggested by arnelgp. It might be a few days before I can try.

Thanks JHB. The problem is there for doc files as well and for xls and xlsx files. I tried the link you suggested and tried to run the easy fix download but got a message saying the fix didn't apply to my operating system or application. I'm running Windows 10 and IE 11. I'll keep searching the...

Hi, I've have put a Microsoft Active X Web Browser control into an Access form and use the following code when the form loads: Private Sub Form_Load() MyPlace = "C:\test.pdf" Me.WebBrowser0.Navigate MyPlace End Sub This works well and the pdf file is displaced in the control. It also works...

Thanks for your replies. I opted to use ozinm's solution as it gives me greater flexibility.

Hi, I have three tab controls on a form. I can get the active control name using Screen.ActiveControl.Name I also need to be able to get the name of the tab control and the name of the tab control page on which the active control sits. Can anyone tell me how to do this please?