Search results

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

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, 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...