Search results

correct. My level is not that high. (I'm glad everything keeps working). At first I even had a problem with using the hyperlinks, but that is because it was more than 20 years ago I finished my program - (and since then only changed some reports). So sometimes I see problems where there...

Sorry I'm a bit late with my thanking, but anyway, thanks for the hint. UNC is new to me. I had to look for the Microsoft Scripting Runtime because I'm still programming in the 97 access (It runs in access 2017 but cannot program in it and I'm afraid to ruin the relations in my dbase). It...

thanks Mark, didn't think so far, but that seems an easy solution

The file is not in access, it's just a map on my computer I want to open. I assume you mean reports in the access dbase itself. (sorry If I dit not understand your remark correctly)

I have the following problem: In ms access I have a button to open a file or folder on my computer. If I want another user to be able to open the same folder from his computer, if using the same button of course he gets an error. He needs to take another path. So I created a second button...

Sorry, I just learned how to use the 'codetags'. So this should be corrrect This thread can be closed ------------------------------------------------------------------------ Private Sub Command299_Click() 'Creates or opens a text file in existing Folder 'If folder does not exist...

I adjusted the code so it creates .LOG in the first line. This is results in opening a file with time and date everytime it gets opened: ------------------------------------------------------------------------- Private Sub Command299_Click() 'Creates or opens a text file in existing...

Life can be simple In the mean time, I got another code from Edmoor on a dutch site (thanks Ed) and it also works perfectly: -------------------------------------------- Private Sub Command278_Click() 'Creates or opens a text file in existing Folder 'If folder does not exist first...

Hi Mark, I must admit I don't understand the TCO code. (I did not get it to work, and I didn't find much when googling, so I tried to adapt it myself, but no luck. Sorry, probably my lack of programming). In the mean time I found another solution with a TaskKill- command which finally works...

Thanks all for the help. Mark, I tried your code, but I get the following fault (probably because I did not comprehend the remark of Pat to create the 'subs'. - I hope you understand that I'm learning...) I have the following result: ------------- Compile error: Sub or Function not defined...

Collin, true. I've never done that, and I sometimes have to go back to the form to see why and how I created the command button. I'll try to think about it. As for the 323 button: I sometimes only want to open the folder to look what's in it. The .txt file is only necessary if I had a...

I have the following question: I have created two working buttons: button 278 and button 282 in my access form -------------------------------------------- button 278 = to open an existing .txt document and if not exists, create one Private Sub Command278_Click() On Error GoTo...

sorry Colin, I know it's good advice, but I'm not familiar with it, looked a bit on the internet to know where to put the code -before or after... (would be great if you give me the example in a code where I have to put it). In the mean time, I think I found the solution (it works)...

Thank you for the suggestions, but I tried it with the \ after 'documents', but it still doesn't find the path. It's the line: Foldername = "\\server\c:\users\eigenaar\Documents" & stnaamfile & "" that doesn't work. (it only opens the 'documents' folder) So my expression " & stnaamfile & seems...

I tought this would be easy, but I'm bumping on a wall: I can now open a specific file on my computer, based on fields firstname and lastname (thanks to the forum's help) . Now I'm trying to open the map (which holds all client's related files, so in my case the one that stands above the .txt...

LCase did the Job. I first took it a try with the solution of ridders and decided to change Ucase in LCase. Only afterwards I saw Moke123 allready mentioned it. Time to upgrade my glasses :banghead: Thank you all!!!! Great Forum! (ridders: all the folders are outside the dbase so just files in...

This should be the final code: Private Sub Command278_Click() On Error GoTo Err_Knop278_Click Dim shlApp As String Dim stDocName As String Dim stnaamfile As String stDocName = "bezoekrapport" stnaamfile = Me.VOORNAAM & "" & Me.ACHTERNAAM shlApp = "notepad.exe c:\Users\eigenaar\Documents" &...

Life can be simple ... thanks Moke! This works. For the .LOG command, I think I have to type it in the new created .txt file only the first time at the first line. Afterwards the date is automatically put in. That's a thing I'll have to live with. I'll try to do the link to the related...

thanks to everybody for the advice. But I think I have the thing that I wanted (however still not working properly) -------------------------------------------------- Private Sub Command278_Click() On Error GoTo Err_Knop278_Click Dim shlApp As String Dim stDocName As String stDocName =...

thanks Lightwave! I have to admit that I'm not familiar with any code anymore, but trial and error solves a lot in access. I'll test it out this weekend