Search results

Two Access MVPs advised this. Both suggested I at least uninstall and re-install Office 2007 after un-installing the Office 2013 trial. One of the MVP's said to be completely safe I should consider reformatting. Please note I am creating MDE and ACCDE files and distributing them into unknown...

Hello, I purchased a new machine. I didn't realize Office 2013 trial was installed as there was no indication that it was in <All Programs> etc... I installed Office 2007 and spent many hours setting up my new development environment only to realize an Office 2013 trial was installed when I...

Will do vbaInet.

I swapped the HTML file that had the embedded JavaScript and the error persists. One one machine with the below specs it works. On a second machine with the below specs the error is thrown. Internet Explorer 11 Security settings at Medium-Low Windows 7 64 Bit SP 1 Windows Updates set to...

I turn OFF Subdatasheets at the table level for the reason vbaInet mentioned but I have had no issues with implementing Drill Down at the Form level by nesting two Datasheet subforms and linking Parent / Child. I also don't always use this approach because at times you want to fully control the...

Thanks Galaxiom.

I am curious what is the advantage / difference of using DateAdd("d",[Date Generated],[# of days]) vs. [Date Generated] + [# of days] Will the results always be the same?

If anyone is interested I started a new thread about DPI Scaling. How do you handle DPI Scaling other than 100%? http://www.access-programmers.co.uk/forums/showthread.php?p=1373177#post1373177

As more and more laptops and monitors come with higher resolution screens DPI scaling other than 100% is becoming more popular. At 125% DPI Scaling some field captions in my software built for 100% get cut off or are misaligned. Also the DPI scaling can theoretically be anything as it can be...

Thanks CJ London. I actually have that FMS product but never used it. I am not sure if it would work for DPI as the user never resizes the form but perhaps it would? I am going to contact FMS and ask. I will also start a new Thread about this to see what others are doing about DPI settings...

So far I have not had any need to reconfigure Access due to Teamviewer but I have had issues with labels being cut off when the user is using DPI Scaling other than 100%. I would be interested if there is a custom built VBA solution for detecting the user's DPI Scaling settings and adjusting...

Understood VBAInet. Thanks

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