Nasho23

Thank you Steve Kim for this advice - I now have the solution I was seeking.

I am using FM 11 Pro Advanced on Win 10 Pro 64bit PC. In my Database Table, Records consist of 20 Fields. I need assistance, to create an additional Field, that can Automatically capture and store, a Records Modified Field Name and the Last Date that Record Field is Modified, against that particular Record. I am a Novice in relation to this aspect of handling the Database, so please, when you reply, remember I am not an Expert.

Thank you for your assistance in this matter. I have elected to stick with the Function (DesktopPath) & "Folder" which will work on everyone's computer. For no obvious reason that I could see, I could not get the Hard Coded Path to work. I will not bother with that method. Many Thanks Nasho23

Thank you for this. For my Test run, this is great and, to a Novice, you make it look so simple. However; If and when I need to Save the File to a Folder that is located a number of Folders down on E:/My Documents/My Databases/ROTA/WEBSITE/WEB INPUTS/WEB SITE Member Reports/ - How do I change the Code for Saving to this new location??? Not really concerned about chronological order of sorting as these files change every month, with the old ones being deleted after new ones are uploaded to the Website. Thank You Nasho23

I hope I am allowed to post here for FM11 Pro Advanced on Win 7. I am struggling with the Code shown below. (mainpath = location statement for $filespec) ROT is the Destination Folder on my Desktop. After Final Testing, the Destination Folder will be elsewhere on my PC. I need to Save Records as pdf to the Location Path on my PC, to "mainpath" Location with the Filename "Service_Web_120716.pdf" I have chosen this method, so that I can easily change the Location Path to that required on other Operators machines. The remainder of Code has tested OK - It is only Destination Path Location that is causing issues. Error produced is::: Service_Web_120716.pdf could not be created on this Disk. Use a different name, make more room on the disk, unlock it, or use a different disk. There is no problem with the disk; In fact earlier when testing with the Function Get (DesktopPath), the resulting file would show on the Desktop. Now no file on Desktop and Error. $filespec Let ( [ mainpath = \C:/Users/Owen_2/Desktop/ROT/ ; prefix = "Service_Web_" ; today = GetAsDate ( Get ( CurrentHostTimeStamp ) ) ; dd = Right ( "00" & Day ( today ) ; 2 ) ; mm = Right ( "00" & Month ( today ) ; 2 ) ; yy = Right ( Year ( today ) ; 2 ) ; filename = prefix & dd & mm & yy ] ; "file:" mainpath & filename & ".pdf" ) Save Records as pdf [No dialog; “$filespec”; Records being browsed] Regards Nasho23