Search results

Hi, I need to run a query to get the 'OriginalName' column to return back the 'RequiredName' column. I've actually done this in Excel as I'm experienced with formulas but not quite strong in the Access query department, anyone know what to do? Thanks. And if possible, to return another separate...

Funnily enough, not sure why my error was happening. But when I use the same path in a form and do an application.hyperlink "path" it works.. I'll keep working on it thanks

When I use the UNC path I receive the error shown in post #9.. any ideas why?

Yeah even I'm not too sure why user have different drive letters. I'm kinda new to the place, but from what I understand the user login profile isn't set up this way. I'll have to get that clarified.

Awesome. This is exactly it! Thanks moke <3

Out of curiosity, is there a way to not use a mapped network drive in the strPath to complete this. Because I've realised that everyone who uses the database would have to map their network drive to the drive letter I assign (in my case "W:\"). Which is not ideal of course. So at the moment it...

Hi Moke thanks for the good wishes, Sorry to bring this thread up again. Just wondering if there was a way to control the recursive procedure to only find a specific file format in a folder. For example only ".tif" or only ".jpg" files, as opposed to simply an entire list of everything in the...

Okay I've solved the issue. So like I said it's on a network location. Reason I blacked it out because it has some sensitive info in the naming. What I did was map the network drive. Plus I was using "acSpreadsheetTypeExcel9" when '*.xlsx' should be "acSpreadsheetTypeExcel12". Once I made these...

My apologies, thankyou for the correction. I'll be a bit more careful next time.

Thank you everyone for your help! I hadn't explored the function for it, this is very useful for another issue I had with another project, so thank you for this solution. I didn't know about IIf in the query DB, thanks for that. This worked best for my current issue.

Yep that's my confusion now. So how can I only remove the ones that are reflected as so on my list?

I want to be able to remove the last occurrence of "/" from data I have in a query.. like below: Original Data Example: X/Y/A1/ X/Y/B1/ X/Y/B2/ X/Y/B4/ X/Y/B7a X/Y/B8a X/Y/B3/ X/Y/B3/ X/Y/B9a X/Y/B4/ Required Data Example: X/Y/A1 X/Y/B1 X/Y/B2 X/Y/B4 X/Y/B7a X/Y/B8a X/Y/B3 X/Y/B3 X/Y/B9a...

After adding the "\" between strPath and "*.xlsx", compiled and then clicked my button, I receive the following error: I can confirm the path and file in the error are correct, so it should import from the excel sheets. But it isn't. Just to reiterate, the excels are on a network location. If...

Hi, I'm not near a computer at the moment. But out of curiosity why would I need a slash between strPath and "*.xlsx"? Isn't it just file path with the file extension at the end..there shouldn't be a slash there right.. or have I missed something?

Sorry, I made a mistake while typing. It's supposed to be going to a network location where the spreadsheets are located. Still doesn't work after copying it directly from the address bar of file explorer.

I have the following code but it isn't importing the excel sheets into the specified table: Sub Import() Dim strPathFile As String, strFile As String, strPath As String Dim strTable As String Dim blnHasFieldNames As Boolean blnHasFieldNames = True strPath = "C://Documents" strTable =...

Thanks so much moke, appreciate your help!

Hi moke, this works exactly how I wanted it to. Thanks a lot. Also if I'm not being too picky here, is there a way to avoid picking up "thumbs.db" files from this process. Maybe something I can add in the code level as opposed to query?

Hi CJ, When I did this, the import didn't work. The table will have no entries except the error handler message in it. the error

Hi Pat, Do you mean I have to create a separate index or is the default primary key indexed I have at the moment fine for this? I'm not very clear about trapping the duplicate error. What exactly does that involve?