Search results

I am sorry I have got another folder called REVIEWED and a listbox3 will represent that folder but the name of the pdf file will remain as it is without adding the ’-R’ with the movement of the file from WORK IN PROCESS folder how can redefine the code on click event of the button? I tried a...

I am sorry I have got another folder called REVIEWED and a listbox3 will represent that folder but the name of the pdf file will remain as it is without adding the ’-R’ with the movement of the file from WORK IN PROCESS folder how can redefine the code on click event of the button? I tried a...

Waw, thank you so much I do not know how to thank you. Amazing it's more than my expectation. [emoji122][emoji122][emoji122] Sent from my HUAWEI NXT-L29 using Tapatalk

Thank you so much arnelgp The code works as I need but only one thing in the list WORK IN PROGRESS Listbox it shows the record without -R like this: 02JAN19-OPS-DM-001 it suppose to be like this: 02JAN19-OPS-DM-001-R In the folder, it does add it but in the listbox it didn't. Thanks in advance!

Thanks for your response, sorry may I did not mention the record should move from [ListBox1] represents the FOR REVIEW LIST to [ListBox2] represents WORK IN PROGRESS LIST I got a Syntax error in the below line: If Dir("D:\WORK IN PROGRESS" & Replace(Me.List0.ItemData(var),".pdf","-R.pdf") <> ""...

Thanks the DBGuy for your response, you're always available. it's unbound list box it returns the correct value of our shared folder's pdf files as a text with the below Syntax: Private Sub Form_Current() On Error Resume Next Dim Filename As String Filename = Dir("D:\FOR REVIEW" &...

Still the issue does not solve. [emoji51] Sent from my HUAWEI NXT-L29 using Tapatalk

Thanks for your response. I got a syntax error

Hi All, How can I move folder contents usually are pdf files to another folder depends on a listbox selection? The listbox populates the folder contents as a text. When I type my code manually working fine as the below: Name "D:\FOR REVIEW\02-JAN-19-AAA-001.pdf" As "D:\WORK IN...

Thank you so much it's working [emoji817] Sent from my HUAWEI NXT-L29 using Tapatalk

Private Sub Form_Current() Dim Filename As String Filename = Dir("C:\Users\Basel\Desktop\Target" & "\*.pdf", vbNormal) Do While Len(Filename) > 0 Me.ListBox3.AddItem Filename Filename = Dir() Loop End Sub It's working now :) One more thing now how can I open the file when I double click on it?

Thanks for your earliest response. I have changed the folder path to: but it still not working.:banghead: Actually, I got the code from Youtube it's VBA MS Excel I want to have it in MS Access form I do not know how to achieve this, please see the link...

How can I get the file names of a folder on my desktop called 'Target': "C:\Users\Basel\Desktop\Target" in a ListBox1 on MS Access form called Form1? I succeed to get the pdf files in a web browser control, but I prefer to have them as a text in my list box1 and can open them from the Listbox...

Please find my response Sent from my HUAWEI NXT-L29 using Tapatalk

Please find below my response Sent from my HUAWEI NXT-L29 using Tapatalk

Ok I checked the scanner it has an option to create it with searchable file but there is no option to reduce it. So moving further, how can I automate this process by building a VBScript syntax? I know how to create the Tasks Scheduler to run the VBScript file but I do not know how to build the...

Thanks for your prompt response [emoji106][emoji4] Because I want to handle the continuity and the sycle of the pdf documents (SOURCE Folder is the output of the scanned documents from scanner) may you can correct me if it's possible that this process can be achieved without duplicates because...

How can make a VBScript that when a pdf file exist in a folder called 'SOURCE' then three steps have to be done. Step one: make pdf as a searchable file if possible then reduce the file size. Step two: copy the file to a folder called 'BACKUP'. Step three: CUT the file from 'SOURCE' and PAST it...

I mean listbox will show me exactly the contents of the source folder and in the other listbox will show me the contents of the Target folder when select one file or more from Source then press a button between them will move the file to the Target listbox (Target folder). Sent from my HUAWEI...

I would like to select the file from a list box (ListSource) within the form, the file could be with a variable date then move it to another list box (ListTarget) and rename the file let say to add Done to it in the same form but the action will take place in the folder as I stated earlier in my...