Recent content by Joaofigu

hi there! i the code was wrong and din´t get do line of print debug. i will learn more how to print debug, it seems useful. thanks for all.

It´helps !! many many thanks!!! :):):):) i was already!!:banghead::banghead::banghead: thank you all!!

Sorry!, thanks for helping of course!! i will try your code!!

Ok, i already change date to a OK date, TEMPVARS!Val2 = 08-01-2020 16:58:30. and TEMPVARS!val1 = "ZB999" (text) DoCmd.RunSQL "INSERT INTO TableA([FIELD1],[FIELD2]) VALUES ('" & [TempVars]![val1] & "' ", " & # & [TempVars]![val2] & #)"

DoCmd.RunSQL "INSERT INTO TableA([FIELD1],[FIELD2]) VALUES (" '& [TempVars]![val1] & "'", " & #" & [TempVars]![val2] & "#)" val1 Is text not number val2 is date long

i´ve tryed with No Quotes, and put the # for date value. VALUES (" & [TempVars]![val1] & "& ", " & "# & [TempVars]![val2] &# ")"

Hi, what am i doing wrong? DoCmd.RunSQL "INSERT INTO TableA([FIELD1],[FIELD2]) VALUES ('" & [TempVars]![val1] & "'& ", " & '" & [TempVars]![val2] & "')" i want to update a table with 2 tempvars values, but get me error 2498 val1 = 10000124 val2 = 2019/09/10 10:10:11 thanks

my code is getting error in Const strPath As String , get u help me? thanks.

Sorry about my english, I´ve a rotine to import all files in folders, it could be CSV or XLSX but always with the same structer file and layout. After import it i want to move the files to another folder adding date and time. thanks.

I need button to seach in folders if there is a XLSX or CSV file and import to a table, i were trying this code for each folder. Sub Import_files2me() Const strPath As String = "C:\COCFAT\99_input\CDT" 'Directory Path 1 Dim strFile As String 'Filename Dim strFileList() As String...

Hi, Did it work for you?

Hi, I have form with filters, and a subform where is the data, and when i apply the filters i want to know for example , Distinct Field A where condition is in field B, and also sum field C. Example: i want no count 1 "Remessa", where is familia to count how much Bilhetica and and how much...