Search results

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

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.

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

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!

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

Thanks all!

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

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

Part of my problem!

Thanks everyone. Yeah I just found https://stackoverflow.com/questions/17106544/how-to-set-calculation-mode-to-manual-when-opening-an-excel-file as well. However, that uses an Excel macro to open the 2nd TARGET file... but how can I then take over that TARGET file in Access VBA to manipulate it...

P.S. When I close the temp workbook, I can SEE the calc setting in Excel = automatic or manual. But I can't change it. And it remembers what I set it to if I save the temp Excel file, but as soon as I open the Excel file I'm really interested in, it goes back to Auto calc.

Hello, Trying to open an Excel worksbook from Access, but I don't want Excel to open it up with Automatic Calc mode on. Excel object won't let me set calculation mode to manual or automatic unless I have workbook open. So I open a temporary workbook, set calc mode to manual, then try to open the...

It was neither issue. It was my bad coding. I was referring to a similar, but wrong, variable in one spot. Thanks for listening anyway!

I have the following code to run sql commands as pass-throughs... Sub subRunSQL(pSQL As String, Optional pPrint As Boolean) On Error Resume Next Dim qdf As DAO.QueryDef Set qdf = CurrentDb.CreateQueryDef("") qdf.Connect = gsConnection qdf.sql = pSQL qdf.ReturnsRecords =...

And/or, if using a scanner is the ONLY way to go, how does that work? Thanks.

These would be already scanned PDFs that would be provided to me. My experience with Adobe and VBA has primarily been around letting Adobe do an OCR on files, and then reading in words on a page. But isn't a bar-code basically just a very funny font? So I thought there might be some tricks in...

Anyone have luck reading a bar code into a database, from a PDF? Suggested approaches? Thanks!

Thanks - I think the recordset approach earlier above is likely more efficient. Thanks everyone!

Yes the issue is the queries are very different formats, so I want to copy/paste each one separately to the same Excel tab.

Hello - anyone have simple coding I can steal that runs a query or two, copies and pastes into Excel and does it without the query opening visibly? (Or turn off screen updating I guess). I'm avoiding transferspreadsheet b/c I don't want to transfer the whole table AND I want to potentially copy...