Search results

sorry, I was wrong. I took it back what I mention before. I just realized that the code was not working in another form either. Is any other way to save reports with modified report name? Thanks

the name of the report is rptOrder not -rptOrder, I the report save as 1234567-rptOrder. It works if I remove the ordernumber but we need to have the ordernumber to identify the report. I did try Me.OrderNumber & "- rptOrder" and it has the same error message

I tried debug, it shows the OrderNumber but for some reason it keeps give me this error message

Hello, I'm trying to export a form to PDF and got an error message "Can bot find the object '|1'. What does that mean? The report I tried to export is get data from 10 tables, is because that? I used this code in another forms and it works but don't know why is not working in this form. here...

@arnelgp , Thank you for reply. I'm sorry to keep bothering you. I did try Application.FollowHyperlink "" & Me.Lst_Files.Column(1) & "", it doesn't open the docs. I just don't understand if the invisible list the shows the correct path, why it doesn't open to the correct path when click on it...

in the invisible list box shows the correct path on each OrderNo, but when tried to click to each to view then it will pick up the first OrderNo in the query and for every docs. here is the screen shot and the Database

@arnelgp , I think I figure it out now. I changed the lst.AddIten varItem in the module of the ListFiles to lst.AddItem "'" & varItem & "'" that fixed the issue. But trying to figure when click on open the pdfs, only the first Order# in the case will opens the second order# in the case will...

@neuroman9999, Thanks. @arnelgp , I know what my problem, it's the SPCaseName folder cause the issue. . the path is sPath = Environ("UserProfile") & "\OneDrive\CaseDocs\" & SPCaseName & "\" & Correspondence" because I have the SPCaseName as C1234567_Doe, John vs. Doe, Jane , it cut off up to...

@arnelgp , I'm so sorry to bother you again. one more question. Your new DB is working great, but I have a small issue if you can help me for this too, I will be great appreciate as I'm trying to figure it out how to fix. Here is the path our docs store look like...

@arnelgp , sorry, not sure where to change in the module.

@arnelgp , I will link to the caseNo to that folder and subfolders, that's why I only need to show the file name. do I need to modify in the module for that?

@arnelgp , Thanks for your reply. How do I just list the name of the docs inside the folders/subfolders not with the location name also is any way I can sort them? @neuroman9999 , Where I can place the code your suggest? in a new module or inside the listbox On Load? Thanks both!

Hello, I have a question, I want to able to show all the documents in a sharepoint folder to a list box in a form. These documents are in different subfolders, I'm having trouble to figure it out how to list all the documents in those subfolders inside the main folder. Attached is the DB, it's...

@moke123 , one more question if you don't mind. How do I show the only record(s) that are relate to the Case in the list Box so that when rename and move to the new location, it won't move all the doc to the folder that associate Order folder. for example, I have OrderCaseNumber C1234567 and...

@arnelgp , Yes, I need to move it without the subfolder because the new location already has the subfolder that the files need to move to. Thank you,

@moke123 , I'm not sure if i'm in the right track. Here is the code that I modified. I tested it, it seems work but the file(s) not appear in the New List box. Sub RecursiveRename(fld As String) Dim fold As Folder Dim fil As File Dim fldr As Folder Dim Newfld As String...

@moke123 , so sorry to bother you, I'm trying to figure out the MT that you mention but unsuccessful. I know you used Set fldr = fso.GetFolder(fld) for the current path that I selected, but not sure how I can tell the system my new path. Thank you for your time

@moke123 & @arnelgp , Both of the DB your provide were working great but I forgot to mention that the last thing after I rename the doc is I need to move them to the new location to the folder that is associate with their subfolder inside their own case#. I'm so sorry to realized this now and...

Thanks everyone for help.

Attached is my test DB and what I have done but I have couple of questions. 1). I would like to enter the Year, begin date to end date (which is the whole year from 01/01/10 to 12/31/10 for each year), I'm stuck on the Begin date and End date in the code. 2). I tested mine, it seems it keep...