Recent content by MsAccessNL

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

I saw a post that ms project is also vba compatible. I am surpised, I never heard anything about project and vba. Does anybody have experience and is this not a great combination with ms access?

Private Sub cmdCopyCode_Click() Me.txtCodeDetails.SetFocus Me.txtCodeDetails.SelStart = 0 Me.txtCodeDetails.SelLength = Len(Me.txtCodeDetails) DoCmd.RunCommand acCmdCopy 'now you can use ctrl-v to paste End Sub

I am working on a similiar project, importing bankstatements from different banks. I have choosen to use dao to import the csv files and use copyfromrecordset into the body of an already formatted Excel table, the format, like the dates, are respected thisway. (No idea how if this will work...

Would be the first time that i get the haircut really want! 🤩