Search results

Thanks thats worked :)

So i have this to shorted the postcode, which is working as long as a postcode is provided within the field, how can i get around so i dont get the #ERROR would like it just to be left blank? please? ShortPostcode: Left([PostCode],1) & IIf(Asc(Mid([PostCode],2,1))>=65,Mid([PostCode],2,1),"")

Its ok found a way Exp1: Val(NZ([ORDER_No],"0"))

Exp1: Val([ORDER_No]) How can i get the wuery to not show #ERROR when using the above for a blank entry please?

Perfect Thank You @arnelgp

Looking some some code to open a text file remove the first line and the save the txt file

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