Recent content by Kronosds

Now error is in this line: 'CurrentDb.Execute Debug.Print _ "Insert Into & MyTable & (C1, C2, C3, C4, C5, C6, C7, C8, C9, C10) " & _ "Select '" & Left(tbl(fld, 0), 8) & "', '" & Right(tbl(fld, 1), 2) & "', F1, F2, F3, F9, F11, F7, F8, F10 From [Text;Database=strPathcsv...

Hello there, best regards to all, I have a new problem with an array at the moment of insert records in my table, display me of error "3078, The database engine can not find the table or query of input false" But my table if exist in my database, what can be the mistake? this is the code...

Thank you, then I will stay with this method. I have a question more, how do I close the thread? Kronosds

Hello ridders, I implemented this code and it works for me, is there any advantage or disadvantage in doing the schema.ini with this code? Private Sub CmdUpDate_Click() Dim Path As String Path = CurrentProject.Path & "\Schema.ini" 'Open "C:\SharePlant\Schema.ini" For Output As #1 Open Path...

Hi there, I have a new question. Is there any way to dynamically create a Schema.ini file? Problem is that I have a function that requires a Schema.ini file, and this file always has to be in the same directory where the current database is. But the user can accidentally delete this file, so...

Great, yes it's correct what you say. I'll take it into account. Thank you. How I close the thread?

Great, Your proposed code has solved my problem....! Thank you for you help Kronosds :D

Hello, here is the screen: The page do not let me upload images The Back color should take it from the table "MasterColor", that's the idea but I'm doing it with many If Else.

Hi there, My name is Daniel Solis live in the Paso Texas, I'm new in the forum , and I have some experience in Access. I hope to contribute something in this forum and learn even more things. This the problem I have, in my table "Master Color" I have four columns "Color, R, G, B" with the color...