Search results

files are correctly named, outwardsort_260520 & onussort_260520. not sure where i am making the mistake, thankyou for you help. since i have your testing file, i will try and replicate my project in that and try to play it tomorrow morning.

yes i have both the files in the folder. /nothing happens in the immediate window after hitting ?bothpaths

i amended the code, now i get run-time error "5" Invalid procedure call or argument on below line path1 = left(bothpaths,instr(1,bothpaths,"|")-1)

there will not be many files, will keep that in mind i tried your code, i am getting error on below line as Argument not optional path2 = replace(bothpaths,path1 & "|"

thanks pisorsisaac for the code, i will try and give my feedback.

The outwardSort and onuSort are files which will be required for sorting by UserB, which he would inform UserA to dump them on his request. So he would always mention the date as the file name. As i mentioned earlier, there will be only two files with these names, the rest of the files are with...

its random files called OutwardSort_ddmmyy & OnusSort_ddmmyy. the ddmmyy can be any date but it will be same date for both the files. UserA, dumps the files and UserB does the import. and these two files will be either deleted or moved to another location. So at any given point there will be...

The transferText through import specifcation picks these two files after i rename them. Yes, browse solution is another option but i dont want user to do this, since the user dumping the file in folder are not the same person and may take the wrong file or the hassle of always going through the...

Thanks all Dear theDBguy, no there will be other files too in that folder. Currently i rename the file name to OutwardSort and OnusSort (without the date) and import the files. However i was looking for a automation solution, where user places the file in the folder and clicks import for the...

HI all I am trying to import two text files on daily basis, the files have date in its name, however the date is not today's date and can be any other dates, for e.g. as below outwardsort_250620 onussort_250620 Below is the code which is working if the date is current date. How can i amend...

HI! arnelgp, i tried the below code and it gave me the required solution. Me.IDSRef = DLookup("IDS_Ref", "tbl_SOL", "SOL_id = " & "SOLid") thank you for your help, take care and god bless

Sorry arnelgp, unable to do as you mentioned. If you may pls look into this once you are near your PC pls

just one correction, it should display the IDS Ref from the matching SOL Id

Thanks arnelgp, for your response. How are you and hope all safe and sound around you. With the code given by you, i will have to add select code for every new SOLid, currently there are less than 10, but soon there will be approx 50+. Can i request for dynamic code which looks into the table...

Thanks Ranman for your response. probably i have not explained correctly, how can i copy the data from frm_SOL to subform when i select the required SOL_ID i have updated my db for better understanding

HI! i have Main form which has subfrmProduct_2_ and another frm_SOL attached to it. i want the user to update subfrmProduct_2 by looking into the form, " frm_SOL" for the related value. i am the below code on afterupdate on subfrmProduct_2, but i am getting error Private Sub...

oops! Sorry Isladogs, i missed that and thankyou for the solution you gave. I will close the thread as solved. Thanks Gasman for the correction, i read that somewhere, strings are always in " ". Thank you both. Have a nice day.

thanks Gasman, i have applied the code and changed the data type to Number and its working as expected. But if i have keep the data type to Text, then how would i write the code.

added my db

Let me explain with a db. user will input data in txtPQR; txtABC; txtMAN and txtXYZ. in the subform, user will select from SOLid dropdown matching in SOLref and it should pick the relevant txt.... data and populate in field "IDSref" i was not able to find suitable select statement and tried to...