Search results

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 :)

Sorry - How do I see 'Show All Actions' ? Iam not much familiar with this. Sorry If am troubling you :-)

How would I do this ? can you help me

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.

perfect !! That worked

eus81375wal11a1ax442117112115211211"ed111 4"ed114a cc"ed115 14"ed116 91"ed117 25182117"ed118a 111111111215135611"ed311 1121513561"ed312a 1183769688"ed132 %"ed111 dl "ed113a 1111311111111"ed115a 1111311111111"ed121 25182117"ed123 a"ed124a 25172117"ed125a 24182117"ed060 25182117"ed311 1131"ed135...