Recent content by MsAccessNL

Why did you wait 98000 years before sending your son to save us and why couldn’t you wait another 2000, so he could have used the internet to spread the word, Where all the people before the year 0, going to hell? If tthey didn’t, why did the people after the year 0 go to hell.

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

I see that the number of posts on coding forms is decreasing rapidly….

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?