Search results

OKay more info. Getting sql server error 10054. I'll also google in the meantime. --------------------------- Microsoft SQL Server Login --------------------------- Connection failed: SQLState: '08001' SQL Server Error: 10054 [Microsoft][SQL Server Native Client 11.0]TCP Provider: An existing...

Hi - have you ever had a random disconnect to SQL server? I've gotten that but MORE relevant now, it seems our tech guys have implemented a time-out feature to disconnect ODBC connections after some time. Is there a way to "catch" such a disconnect and force a reconnection especially when...

Yeah for end users I'm trying to avoid that. I re-tried putting Trusted_Connection = Yes in the string and so far seems to be working, so maybe just a fluke.

I use connection strings to connect to SQL server and attach tables. For a while I used "SQL Server" such as: ODBC;Driver={SQL Server};Server=SERVER-NAME;Database=DATABASE-NAME;Uid=USER-NAME;Pwd=PASSWORD;Encrypt=No;Trusted_Connection=No This worked just fine. I could refer to the tables in...

Yes - I'm building a complex report in Excel and grabbing different data elements as needed. If ADODB lookup is 50% faster (0.25 seconds versus 0.5 seconds), that would add up I guess.

Hello - I often, for a quick data point lookup, use DAO, such as: Dim sql as string, qdf As DAO.QueryDef, rst as DAO.recordset sql = "SELECT BirthDate FROM tblPerson WHERE Name = 'John'" Set qdf = CurrentDb.CreateQueryDef("") qdf.Connect = CONNECTION_STRING qdf.ReturnsRecords = True qdf.sql =...

P.S. Maybe I don't have the right Tool references either? The database worked fine prior to 64-bit.

Hi - I had the following declarations that are now "expired"... how do I modernize them to 64 bit Access? Thanks! Declare Function CreateCompatibleDC Lib "gdi32" (ByVal hdc As Long) As Long Declare Function SelectObject Lib "gdi32" (ByVal hdc As Long, ByVal hObject As Long) As Long Declare...

Hi - I have a web-browser control that takes up 100% of a form (on purpose). But if the user resizes the form, or maximizes it, I want the Form detail section + web-control to also re-size accordingly. Any suggestions? Thanks!

Not using a bound form connected to the data I am updating. The subform looks at a temporary local table that mirrors the data I update via SQL. So it's client/server set up.

I have a few subforms on a main form and when a record is changed, I use before/after update events to write data to a SQL server. It normally works perfectly fine. I can edit a row in a subform, click to the next row, and the data gets written. But if I edit a cell and then click on ANOTHER...

Cool - I added a button - turns off updating / calculates / turns it back on. Thanks!

Hi - I have an XLSM file running and it calculates REALLY slowly when I'm viewing code. When I close the view code window, the calculation happens very quickly. You can the VBA window flashing as if it's updating the screen as it calculates. Any cheats to make re-calculating faster with VBA open?

Thanks. Doesn't seem to help. I didn't see successful application and/or it seems the function gives you the total # of pages in the PDF, not the page you are currently looking at. Also, it seems the API would only work if I maybe use an Adobe control, versus using a web-browser. But right now...

Hello - I have a form that has a web-browser-control that opens up PDFs. Is there any way to "grab" the page # that the person is viewing when they, say, click a button on the form? The PDF within the web-browser shows the page #, but I'm not aware of an easy way to grab that page #. But perhaps...

It doesn't seem to work if you have a worksheet open as an object.

So I have two recordsets open using ADO. One holds the Excel table. One is referring to an Access table. is there a quick way to say Contents of RS1 get added to Contents of RS2?

I think I can use this? Anyone have hints / things to watch out for? https://support.microsoft.com/en-us/topic/excelado-demonstrates-how-to-use-ado-to-read-and-write-data-in-excel-workbooks-bfb26f12-ba6a-91be-7fd4-4aadf1ff1afa

So to transfer from recordset to excel, you can just use this: ExcelRange.CopyFromRecordset RecordsetObjectName Nothing similar to go back to Access? For Transfer Spreadsheet, I wonder if you have to save the Excel file each time (say you're running back calcs)? I'd like to import from Excel...

Hi - I have some good coding that takes a recordset in Access and plugs it into a range in Excel (so that I don't have to move cell by cell). But does anyone have a trick to take a whole range in Excel and suck it back into an Access table, without going cell by cell? Thanks!