Search results

Thanks! Let me know please if you find that.

The coding above, for example, is good coding, but doesn't handle Binary. But thanks!!!

Thanks. I'm going with the route of using Cmd prompt via VBA... that might do the trick and have less limitations, and allow me to change Binary values.

Sorry I wasn't clear. I wasn't against WS. I didn't think theDBguy's example was even using that.

I don't think this does the trick, but thanks - most of the examples I found online use Windows scripting. But few address the Binary issue.

Anyone have code that can read/write registry values, including (importantly) Hex/Binary values? THANKS!

NICE GUYS!!!

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?