Search results

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

Basically running through 100,000 records and that blows up both FE and BE quickly to 2Gigs. But I think I found the culprit. SubRoutine A would pick the 100,000 records and call the calculation procedure which would grab the history for each person and process it. The culprit is that for...

Okay - one thing I'm noticing (which hasn't impacted other projects like this)... the size grows when I run a query inside the front-end database (currentdb.execute(sql)) even if the sql only impacts a table in the back-end. Maybe I should run the query in the back-end database itself? (Or...

Relatively simple code... let me spend some time looking and see if I failed to close a recordset or something. (But it's client specific coding so I can't easily post).

Enough bloat to hit the 2 Gig limit. I keep looking through my code and I don't believe I'm using temporary tables. Everything needed for the calcs gets loaded into the Linked tables. I'm trying to think of a way to monitor when the size of the database changes so I can see at what step things...