Recent content by MsAccessNL

Sub CloseAndQuitExcel() Application.OnTime DateAdd("s", 1, Now), "QuitExcelNow" End Sub Sub QuitExcelNow() Debug.Print "QuitExcelNow" 'Debug.Print Application.Workbooks.Count ThisWorkbook.Saved = True 'ActiveWorkbook.Close ThisWorkbook.Close SaveChanges:=False...

nothing, i got this db from ********, may be the load event is not the correct place. With the ie11 control i always first loaded a blank page..

.Navigate and .Controlsource don't work, no error. If I set the controlsource by hand in the settings, it will work (bit slowly). I didn't tried the hosts server hack (something chatgpt gave me), because this would not be practicle when selling an application.

Did something change? I have Access 2024 and don’t succeed in opening a local html file. Also not with” file and msaccess” added. It worked before. I downloaded the example db from ********, but also no success.

This is the chrome webbrowser, for those who don’tt like edge.

https://www.access-programmers.co.uk/forums/threads/webbrowser-in-form-without-control-years-to-late.334741/#post-1977534

I worked on this many years ago, my gut told me it should be possible, i was so close. Years later i solved the puzzle (bit to late..)Edit thread We could have worked with the modern webbrowsers inside access for many years already, without using any control. I can also open Excel, Word...

Do you know if it makes any difference in bloating if you store images as Ole object or as Base64 string? (i know storing path is the best, i am just curious).

' https://stackoverflow.com/questions/14219455/excel-vba-code-to-copy-a-specific-string-to-clipboard/60896244#60896244+ 'Overcomes error text to long in Access thnx to Arnelgp Function Clipboard$(Optional s$) Dim v: v = s 'Cast to variant for 64-bit VBA support With...

It works! What a great Hack, you are the best!

Thxs for the info.

At the end, yes, but know with testing, its a pain in the.., Is this a normal error in access, with pasting large text files?

That's not the problem. The Problem is that i can't past a long text (the base64 character string)

I have a long text field when i paste a text in the table or in a form, i get message "Text too long to be edited" , If i copy smaller parts it will work. (25000characters wil work). I want to store a picture as Base64, this is a long text file. Pasting into NotePad works fine.

Sub Closethis() Thisworkbook.close End sub Doesn’t work if this sub is called from another function or from an event. Only if you run it direct. Chat said to run the code on time, but also nothing. I have code to check for a value otherwise it will close the workbook. Any ideas to get this...