Search results

  1. C

    Solved Accdb: "WebBrowser" and "AcroPDF" (PDF viewer)

    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]...
  2. C

    Solved Accdb: "WebBrowser" and "AcroPDF" (PDF viewer)

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

    Solved Accdb: "WebBrowser" and "AcroPDF" (PDF viewer)

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

    Solved Accdb: "WebBrowser" and "AcroPDF" (PDF viewer)

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

    Solved Accdb: "WebBrowser" and "AcroPDF" (PDF viewer)

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

    Solved Accdb: "WebBrowser" and "AcroPDF" (PDF viewer)

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

    Solved Accdb: "WebBrowser" and "AcroPDF" (PDF viewer)

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

    Solved Accdb: "WebBrowser" and "AcroPDF" (PDF viewer)

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

    Convert BIN file to Image

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

    Solved Accdb: "WebBrowser" and "AcroPDF" (PDF viewer)

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

    Solved Accdb: "WebBrowser" and "AcroPDF" (PDF viewer)

    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).
  12. C

    Convert BIN file to Image

    I was given a bunch of BIN files (which I believe are TIFF or JPEG). I'm still working on confirming the image type. But does anyone have code to read in the BIN file and convert to an image file in VBA? Thanks!!!
  13. C

    Internet explorer object

    I've tried a few things and IE just acts strangely. Just hard to get a consistent and reliable way to open up 2 websites, one after another.
  14. C

    Internet explorer object

    I'll admit upfront i don't get the IE object. What I'm trying to do is open one web page and then open a 2nd page (as a 2nd tab). Using Access 2016 and IE11 in a corporate environment. Here's my code so far: ie.Navigate2 "msnbc.com", 2 + 65536 Pause (2) [calls a function that waits 2 seconds]...
  15. C

    Query DESIGN view - can't edit

    Do you ever (first time I see this after years of using Access) open a query that you can't edit at all? All the design buttons are greyed out. No VBA is running. What gives? Thanks!
  16. C

    FoxIt PDFs

    Anyone have luck opening PDFs in a form (webcontrol), using FoxIt, instead of Adobe? Any tricks? Thanks!
  17. C

    Deciphering SQL

    Thanks all!
  18. C

    Deciphering SQL

    That was an excerpt. Thanks for the help. But wouldn't an alias be written as "TABL1 AS ALIAS"?
  19. C

    Deciphering SQL

    Hi - working with data that came from an Oracle DB originally. Not sure if the SQL syntax is different, but there this coding that refers to "b". I suspect "b" is an alias (or maybe another query?) but here are the references to "b" I'm seeing. Any thoughts on what it means? Or is it a subset of...
  20. C

    Open Excel with MANUAL calc on

    Part of my problem!
Back
Top Bottom