Recent content by sathsaj

I discarded my code and copy pasted the one from the solution

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

Solved - Why do I get Run-time error 3011? | Access World Forums (access-programmers.co.uk) I copied one of the code from this

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

? Format(Date - IIf(Weekday(Date)=2,3,IIf(Weekday(Date)=1,2,1)), "ddMM") & ".xls" - this one worked now, I had some wrong code

nothing worked, it still gives me 2101

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 ?

am not from IT background, so unable to get the results :-(

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

that works :):):):):)

I have a macro which is provided by access

unfortunately Iam not familiar with VBA

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 ?

Cool, I have used Macro before, but I never noticed this Show All Actions button. It worked and am Glad I could close this out. Thanks Gasman for the Help :)