How to call “Insert Object” dialog from VBA

If you have data stored in OLE field, like pictures or documents, then perhaps you need a code to run “Insert Object” dialog. Here it is – you first set a focus to OLE field and then run
DoCmd.RunCommand acCmdInsertObject

 Although – better idea is to store pictures and documents as files on HDD or server, and save path to these files in database. Or store files as binaries, like described in “How To Read and Write BLOBs Using GetChunk and AppendChunk” KB article.