Search results

Attached is the screen shot of how the documents saved

I search about Bulk Rename Utility as arnelgp mention, unfortunately my company will not get the license just for that. so I was wondering how I can use Access to do that?

Hello, I'm not sure my question should post in the Form section or Module/VBA section but I would like to know if this is even possible to do it. Currently I'm working on a paperless project. We saved documents to a pdf format and the documents saved in a individual date folder. For example...

@moke123 & @arnelgp Thanks both!

@moke123 , Thanks! that works! @arnelgp , Thanks! I did try your code as well. the only thing is I got an error on strFolder = builtpath & "\" & strFolder(i), the error message was "Complie error, expected array on the stFolder(i)

The code below is create a main folder, What I should changed or added to the code so it can create 3 sub folders named "Orders" and "Billings" and "Appointments" Private Sub cmdCreateFolder_Click() Dim fs As Object Dim builtpath As String Set fs = CreateObject("Scripting.FileSystemObject")...

@Issacc, do you have any example if possible?

Hello, Is possible to program a button in a form to create folder and subfolders. I want to have the Button on the Main form that has the Parties's name and the case#. what I would like to do is create a folder named C1234567_Doe, John vs. Doe, Jane also create few subfolders (named Order...

@arnelgp, I added the code as your replied, I got an error "Compile error: Array already dimensioned" on the ReDim Preserve arrFiles(1 To ControlCount - 1) line. also where I place the "Application.FollowHyperlink arrFiles(Val(Screen.ActiveControl.Name))" Thanks

Hello, Would like to use Shell "Explorer.exe " to replace HyperlinkAddress in order to open the document in File Explorer, but don't know how to use it in my coding because the HyperlinkAddress would pop up a security warning box and the Shell "Explorer.exe " will just open the document...

@Minty, Can you explain to me why I need to add the vbDirectory if you don't mind? Thank you

@Paul, I did debug it, but it shows no an error except it doesn't know how to check on the "IF" statement. @Minty, that it is! after I added the vbDirectory inside the Dir(MyPath), it works like it suppose to. Thank you both for your time. Do I just click solved or is there point for...

Select Case True Case NameLetter >="A" And NameLetter <="F" Folder = "A-F" Case NameLetter >="G" And NameLetter <="L" Folder = "G-L" Case NameLetter >="M" And NameLetter <="R" Folder = "M-R" Case NameLetter >="S" And NameLetter <="X"...

@Paul, Sorry, I did not post the one that I changed. Yes, I did like your but it's still the same result

@Paul, I just added the Case Else also moved the space inside quote but the result still the same as I mention before

Hi, I have a button named View Orders in a form, the cmdViewOrders will open the SharePoint folder which is associate with the case#. The Path is C:\Users\" & Environ("UserName") & "\SharePoint\CasesDoc\" & Folder\& "\" & SPCaseName for example...

I added this to a module from a website that you provide, it still doesn't working Option Explicit Function killHyperlinkWarning() Dim oShell As Object Dim strReg As String strReg = "Software\Microsoft\Office\11.0\Common\Security\Dis ableHyperlinkWarning" Set oShell =...

Good point. but what shall I use to replace the HyperLink since it's cause the warning message?

That's what I don't understand, like I said, I use the same code which was working perfectly with the the network drive but once I changed the location from the network drive to the OneDrive then the warning message pop up. It's annoying that users have to click "Yes" every time to open the pdf...

The problem is when I was using the Network Drive, it was fine. once I move to OneDrive, that's when the security warning pop up. I'm using the same code as it was for the Network drive just change the location from Z drive to oneDrive