Search results

Thanks. Worth trying. Any other takers on a possibly simpler process (TIF side)?

Hi - we received thousands of .bin files. They are in actuality either TIF or PDF files, but we're not told which. Any VBA coding to determine if a file is a TIF or PDF file? Thanks!

Right - in my case I load a table with possible values and the user can then see a "Legend" of possible values. Normally I use contextual drop-downs to show the "legend" but this scenario was different.

That was perfect. Thanks again. Now, when I know the form and the field, I have a mapped table that tells the user - here are the translations of various codes in those fields.

Nice.

Hi - what triggers the SetControl function? I put a breakline there and it never runs for me in my database. I created a global variable and created the subform function SetControl to set global variable to ActiveControl, but it never triggers. Thanks! What you gave me is perfect - if I can get...

Thanks - will check it out!

Purpose is to do a look up from a table that has "form", "field", "valid values" to choose from.

Hello - Have a main form with several subforms (on tabs within a Tab control). Whenever someone clicks on a subform (or using a Timer is fine too), I'd like to know which form was most recently focused on, and which field was focused on (the subforms are Datasheets). I'd love to do it...

Thanks - good idea. I happened to find this which did the trick... for future reference if it helps: Remove Open\Save Dialog ------------------------------------------------------ Windows Registry Editor Version 5.00 [-HKEY_CLASSES_ROOT\AcroPDF.FDF.1] [HKEY_CLASSES_ROOT\AcroPDF.PDF.1]...

Again, I'd have to get IT okay to update the REG keys. That's why I opened the file as a text file and I don't see any reference to PDF files. So I'm not against the idea... it would just take me time to get approval, etc.

See discussion above - I tried it with my tool, and isladogs sample tool... still getting a prompt with PDFs.

Here's another idea. Is there a way to grab the prompt window and force it to choose "open" automatically?

I hesitated due to IT policy. But I opened it in Notepad just to check it out. No mention of PDFs. I think it addresses how to behave when opening Office files, but not PDFs.

Not sure I'm following 100%. I am able to open PDFs in Web Browser control. It just gives me a silly prompt to open/save every time. I click on open and it works fine. But the prompt is annoying.

I downloaded (thanks) and opened a sample PDF. It prompted me first to open or save. I'm guessing it's an IT policy of some sort.

From what I can tell, the prompt is often a function of which Windows you're running, IE version, etc. (I've googled left and right). So I may be stuck b/c my IT dept has their standards. It really seems to be a question of Internet Explorer, not Access, doing the prompt. So I was trying to see...

Um. I hate to admit it. But that worked. Thanks! I should have guessed. :)

Thanks. Problem is that Web Browser has other issues. And vhung seemed to suggest he got it working? One of the issues I run into is when opening PDF in Web Browser control in Access form (IE 11), it ALWAYS prompts to Save or Open. And I can't get it to automatically just open the PDF for...

I have Acrobat Reader DC installed - can't find out how to register an ActiveX control for this? Please help - Thanks! I'm using a 64 bit server BTW with Access 2016. (PS I had been using web browser control but too many other issues so I thought I'd try to get the Adobe control going).