Search results

Dim count As Integer StrFile = Dir("C:\Testing\TEST*.csv") Debug.Print "File name is :" & StrFile Debug.Print Len(StrFile) Path = "C:\Testing\" Debug.Print Dir(Path) count = 0 Do While StrFile <> "" count = count + 1 StrFile =...

Dim strFound As String Dim strSearch As String strSearch = "C:\Users\SRS\test\STest*.csv" strFound = Dir(strSearch) DoCmd.TransferText acImportDelim, "TableSpecs", "Current Day File", strFound, True Beep MsgBox "Files Imported", vbOKOnly, "" what is wrong with this code, first time it...

Dim outputFileName As String outputFileName = CurrentProject.Path & "\Constituents " & Format(Date - 1, "ddMM") & ".xls" DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "Test", outputFileName, True Above code give me 2101, how can I change this code to get 1901 which Businessdays-1

I saved several export steps which is visible under New Tab, now I come to Macro and use RunSavedImportExport and only some of they show up under the drop down and not not all, do you know how to fix this issue ?

HI Is there a solution in Access for the below data Name Oliver Markus Required Result in the next Column = Oliver;Markus

Hi All, Access looks for confirmation to delete existing data before a query is run. This is a Maketable Query. the Action Queries under Client Setting is unchecked. But still why do we get this message ? Is there a way were can get this away ?

I have been exporting data from Access onto Excel. Now have six separate "Saved Exports" Trying to create a single macro that executes all these data tasks with one button/click. DO not see an option in the macro building lists. Help? Advice? Examples? Thanks. Namaste.

example : 1234568595455 ED060 15122017 1A4S856DJKJ if the above data is under Field 1 , I would like to see the result as ED060 15122017. Can you help me how to achieve this result.