Search results

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!

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