Search results

AOB, I just noticed that you require 3 criteria for the Parent Child relationship. You can still do that in Access just separate the fields with a ";" like so: ID;Date;Date It's just another solution. I understand if you decided to go with your method perhaps for visual reasons.

AOB, I read through this briefly. I am just curious why you didn't embed Subform2 into Subform1 and repeated the Master Child relationship like that. So you have two levels of nesting. With this approach you will not get any errors and it's quite easy. If you make the second subform a...

Try the free JStreet Table Re-Linker. http://www.jstreettech.com/downloads.aspx Try the J Street Access Relinker version 1 that is not in Beta.

I agree with VbaInet. Typical reports are sent as attachments in PDF. Instead of outputting to HTML output to PDF and then attach the file to the MyItem. DoCmd.OutputTo acOutputReport, "compliance", acFormatPDF, "compliance.pdf", True MyItem.AddAttachment "compliance.pdf"

vbaInet. He is using 2013 so he can use the built in PDF output. It's true that in 2003 you had to use Lebans solution. 'Use Built in PDF with Access 2007 or higher DoCmd.OutputTo acOutputReport, strReportName, acFormatPDF, strFolderPath & "\" & strFileName & ".pdf", True

In VBA dont' use the Hex use the Long equivalent which jdraw gave you.

Put ... Like [forms]![Calibration Query]![Line1] & "*" ... into the query builder for the criteria. I think it will work.

vbaInet, I contacted a colleague who uses similar code / JavaScript and he said he experienced the same error sometimes. He couldn't explain it but his recommendation was to make a copy of the HTML file and replace the original. That sometimes fixes this error for him. I will give this a try...

vbaInet. I'll try to prepare something for you tomorrow. It's time for bed here. Thanks

The original error "Access Denied" is triggered when VBA tries to execute the below call. I am not fully certain how running it through the Document Object Model would assist. Please note that at medium IE 11 security settings I don't experience any errors on my machine running the same OS...

vbaInet, The error thrown on my machine is thrown by IE not MS Access. The dialog is an IE dialog. The error that my users experience which I cannot reproduce is displayed in a standard VBA msgbox. I don't believe the javascript even executes on the user's machines but in my case it does.

I disabled every scripting setting in IE 11 and surprisingly the JavaScript starts but I get the same error as on High settings shortly after the JavaScript executes. That is not what I expected.

My IE 11 security settings were on Medium and there was no problem executing the JavaScript from VBA. When I put the Security settings on High I did get an error but it was thrown from within the Script meaning the script executed. The original error is thrown by VBA and the script doesn't...

It happens on some Windows 7 Pro machines but generally works on Windows 7 Pro Machines. I am going to play around with IE security settings to see if I can reproduce the error on my Windows 7 Machine. I get very little time with the machines that actually generate the error since they are on...

I wrote the JavaScript. It's embedded in an HTML file that I created which is embedded in a Web Browser Control on an MS Access form. Typically there is no issue but on some machines I get the mentioned error.

On some machines I receive the Error: "Access is Denied" Error #: -2147024891 when initiating JavaScript from within VBA. Call Forms("frmMap").WebBrowser.Document.parentWindow.execScript("initialize()", "", "JavaScript") Is this a security setting in Internet Explorer ? I don't have much...

Simon, I would like the image in the clipboard. I have a good reason for it. Thank you.

Hello Access Expert, I would like to place an image file located at e.g. "C:\MyImages\image.png" into the clipboard. I have not been able to figure out how to do this. I have been able to place Text into the Clipboard using the DataObject late binding sub below. Thank you Public Sub...

Thank you for your response. 1. Interesting I never thought of that. 2. I actually did. I used the forum search function and didn't find anything. 3. I am using Access 2007. Does it only work in 2010? Thanks

Hello Access Expert. I have a form that contains one WebBrowser Control. In this WebBrowser control I interact with the Google Maps API to produce a map. I would like to save the contents of the WebBrowser Control (Google Map) to an image file. I have not been able to figure out how to do...