Search results

dont worry i am using this medthod nw.. Option Explicit Const ForReading = 1 Const ForWriting = 2 Const ForAppending = 8 ' define csv files that will be read Dim arrCSVFiles : arrCSVFiles = Array("c:\temp\csv_file1.csv", _ "c:\temp\csv_file2.csv", _...

Ok thanks I will see what i can find online as i am totally confused by this method thanks for your time though

Thanks Thanks so i did this and getting errors.. Dim Append2TextFile Dim Readfile Append2TextFile Readfile("C:\Database\Zip\1_Header_Q.CSV"), FullPathNewFile Append2TextFile Readfile("C:\Database\Zip\2_Records_Q.CSV"), FullPathNewFile 'Append2TextFile Split(ReadFile(FullPathCSV2), vbCrLf...

Thanks do you have any sample code for this method?

was looking for a better way as the bat file leaves " " at the end of the file or is there a way to have the 3 files created at the same time its 3 queries

So i am looking for a VBA solution to combine csv files stored within a folder, i am currently doing it via a bat file.. copy *.CSV New_Combined.CSV

Thanks unfortunately i have to follow the template and yes you are correct empty columns are present

32322,TTT_EXES_CON,123,,202300220,RRTST001,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

Thanks for your help its not working getting this..

Sorry yes the other form is called "DATA_VIEW" this form has the field "Order_Number"

The main form is called "View_Orders" it has a subform called "Orders" with one of the fields being called "ORDER_ACCOUNT_NO" which form do i put the code Load Event?

Oh i see your code is also on load?

so like this? DoCmd.OpenForm FormName:="View_Orders", View:=acNormal, OpenArgs:="[Order_Number]="Me.Order.[Order_Account_Number]

Sorry yes thats correct still getting same error message DoCmd.OpenForm "View_Orders", acNormal, , "[Order_Number]=" & Me![ORDER_ACCOUNT_NO] think the issue is with the & Me![ORDER_ACCOUNT_NO] as this is not on the Order form is on the sub form called Picking

I have a form created called "View_Orders" it has a subform called "Order", I have added a button to open a new form but its not working getting error saying it cant find "ORDER_ACCOUNT_NO" referred to in your expressions. guessing its because the field is within the sub form DoCmd.OpenForm...

No need to create a new post as its related to my code that removes the password and its not excel i am looking at its access, :)

So i am now wanting to to this code the option to remove any filters that may be present - any thoughts

Using #2 works well thanks :)

Thanks this does work if the customer doesnt have more than 1 entry if they just have 1 entry it throughs up error

Look for some help i need to have a query to delete the oldest record within the table by customer_ID I have Customer_ID and then the field i want to use is the importing_Date So need to delete oldest record for the same customer, however not all customers will have more than 1 record?