Recent content by MsAccessNL

Mooi kleurtje!

Nice work! Would be great for a bom inventory system.

with text files you can set the folder (without the file name) as database, all the text files are tables in the db.

Unfortunately it didn’t work. Thnx for the effort!

Thnx, I will try it out.

Sharp, I checked the module and this mistake was already corrected. i get no debug errors. The code works when you call it from the immediate window, it can’t set the public folder when the function is called on opening of outlook.

I made this code to import a csv file with contacts into a Public Outlook Contacts folder. On opening of Outlook the code checks if a new csv file is present and it will import the new contacts. The code was working fine, but now it's giving an unknown error, with the line: Set olFolder =...

I don’t know much, but if you load the 20 fields into a dao recordset with a SELECT ., statement, wouldn’t it work? You can use dao sql on a $Sheetname. But may be it doesn’t work because the amount of fields? , but you can write vba to select the 20 fields/Columns before you load them into a...

Public Sub OpenOtherDbForm(sFormName As String) 'sFormName = "Form_frmMain" 'de name as shown in vba code Explorer 'Database6 is the name of database shown in vba code explorer 'need te set a reference to the other database, Database6 in this case 'need reference to Microsoft...

Did the table import work?

I work with an older version of access. I think it's Microsoft Listview 6.0 ,you can also use a commandbutton to start the import of the selected email. Did you try to copy/paste the listview control?

You can try; Form_FormName.ShortcutMenu = ....

You can drag en drop your email into the form. You need to use outlook for this. The email I received only contained the table, other text can "confuse" the code.

Interesting challenge, do you have an example of the email or html text? Otherwise you can send the email to info@msaccess.nl

Use .Send instead of .Display remove the sendkeys.