Naming files in VFP

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Exchange Fox
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - Stop user from installing more than 1 instance Hi all! What is the best way to prevent an user to start an run more than one instance of a VFP-app? Best regards Christina Tag: Naming files in VFP Tag: 200085
  - 2
    - Help w/ DOS foxbase app--won't start Help. I am trying to get a program written in DOS foxbase about 6-7 years ago to start. It seems to start, but then I get a message that says "Preparing files ... Please be patient" Then it drops to a dos prompt. No other messages. I cannot get it to do anything. The most puzzling part of this is that this program works fine on an old computer running W98. That computer boots to dos and then this legacy foxbase ap is used. When I copied all of the files from that old computer to a new one, it did not work and is doing as I described above. I'm not sure this matters, but the new computer is using VirtualPC on XPPro. The virtualPC boots to dos and only loads w98 when asked. I duplicated the config.sys and autoexec.bat settings. I cannot think of anything else. Any help would be much appreciated. PS: if you email an answer, use rob@drrws.com as the adr. Thanks Tag: Naming files in VFP Tag: 200073
  - 3
    - Fatal error 1088 :-) I think this is old news, but thought I'd share it anyhow :-) ftp://zootal.no-ip.info/fatalerror1088.jpg Tag: Naming files in VFP Tag: 200072
  - 4
    - XMLAdapter and multiple tables I try to use, within VFP8, the XMLAdapter to open an XML file containing multiple (4) tables. oXMLAdapter = NEWOBJECT('XMLAdapter') oXMLadapter.LoadXML('M:\Edipax\order.xml',.T.) oXMLAdapter.Tables(1).ToCursor() up to there it works fine. but when i try oXMLAdapter.Tables(2).ToCursor() i got an error "no existing member in the collection". Thanks in advance for help, Kind regards, Guy Tag: Naming files in VFP Tag: 200065
  - 5
    - Form Works in One App but Not Another Part II Thanks in advance for any help. I have a form that I'm trying to use in two different apps. It works in one but in the other I get this error (which I think that I incorrectly reported in an earlier post) Visual FoxPro Reference "field" phrase is not found (Error 1130) The field specified in PROMPT field was not found. a.. You are using a command with a PROMPT clause that references an unknown field. For more information, type PROMPT in the Index tab of the Help file and select the command you are using. To the best of my knowledge I am not using a PROMPT command or function. Following the instructions above to type PROMPT in the Index tab of the Help file did not help. Does anyone have any idea what this error means? It is an error which can be safely ignored (which I guess means that it can be trapped) but I don't think I should have to do that. Thanks again, Jeff Tag: Naming files in VFP Tag: 200062
  - 6
    - Join VFP Project to SourceSafe I have a VFP 8.0 project that was, at one time, hooked into SourceSafe. I have since created a new project file and recompiled everything. Everything works great, except now, I cannot check in or check out files from within the Project Manager. I have to go directly to SourceSafe to do that. I've tried Join Source Control Project... but I am not able to join it back to the SourceSafe project. Any ideas? TIA. -Paul Tag: Naming files in VFP Tag: 200057
  - 7
    - How can I run a FPD2.6 program in VFP8? Program only, not from screen generator or anything like that. I could run it in VFP6, but when I try to run it in VFP8, I get an error message that it can't create the .fxp file. I'm sure this is a stupid question, but since I don't know the answer, gotta ask! :) Thanks! Shawn Tag: Naming files in VFP Tag: 200053
  - 8
    - Crystal reports We are trying to use crystal reports from fox. The problem we have is how to pass a parameter into the report so that only records are printed depending on the parameter. ie do report1.rpt with id =1 print only records with an id of 1 Is this possible. Thanks in advance Dave Tag: Naming files in VFP Tag: 200049
  - 9
    - grid display problem Hi, In a column of a grid, the field is defined as c(1), I want to display the word 'Posted' in that column if the field content is 'P', if not then blank. I have tried the iif() in the control thisform.grid1.column1.text1.value It just display the word 'P', I though it is because the field length is c(1) please advise How can I do that whitout change the field length ? I would retrieve those records by 'SELECT ..... ' into a temp table Can I change the field length in doing 'SELECT' ? thanks Tag: Naming files in VFP Tag: 200038
  - 10
    - TEXT/ENDTEXT limits I use "TEXT to lcXX TEXTMERGE NOSHOW" to build a SQL statement. I have a SQL insert failure due to a syntax error in the insert statement. When I save "lcXX" to a file I notice that a carriage return and line feed (CHR(13)+CHR(10)) have been placed into the string. The insert command being generated is about 2000 characters long. I have used this technique in many applications and have not seen this before, although this merge may be larger than others. Can someone explain why this occurs, how to prevent it or at least predict it. In reading the documentation I do not see any limits. TIA Mark VFP7 SP1 Tag: Naming files in VFP Tag: 200033
  - 11
    - Record pointer moving on its own (it's possessed!!) I have a situation with a client's app that results in the record pointer not moving properly. On the forms I develop, I use a pageframe with a List tab at the far right. On the tab is a grid showing the form's main table and this grid is used for locating a record. You click in a column, start typing, it does an incremental search, and when you hit the record you want you just press Enter. The pageframe's main tab is activated and this is where the data entry/edit is done. This works great, but after installing VFP 8 a client noticed a problem. While on the main tab, the user may move to another record (this is basically a bill of materials form and the user can right-click on a line item and choose Inspect this part and the record pointer will be moved to that part and the form will display it). After doing this and clicking back on the List tab, instead of the grid being positioned on the record displayed in the main tab, the grid will be on some other record. It's not necessarily a record that was previously being viewed on the main tab. As I mentioned before, this has worked perfectly up until the install of VFP 8. In fact, when the client tests on a VFP 7 version of the app, it still works fine. I had noticed some similar behavior in another client's app, but attributed it to an error in my code (though I could find none) and didn't think it was VFP 8 related because it had been awhile since we moved to VFP 8, so that connection didn't jump out at me. However, that may be the same issue. If the code is traced, it works, if the code is not traced it will fail. Has anyone seen anything like this? Thanks, Russell Campbell Tag: Naming files in VFP Tag: 200030
  - 12
    - Project Manager problem Hi, I am experiencing a weird problem with the program manager. On an existing project it does not add automatically the forms, programs, icons etc used. If I create a new project and just add the main program, everything is rebuilt correctly. But, if I reopen the project and remove a form (for test reasons) and rebuild the project, the form is not added. It reports that the form is Undefined ! I found and read another relative post but those guidelines do nothing for me. I have deleted all foxuser files, Rebuild, Cleanup the project. Recompile all files. The problem does not seem to appear on other projects, on other directories. Pleeeaaase Help, before I get crazy. Demetrios, Greece Tag: Naming files in VFP Tag: 200024
  - 13
    - Create an Empty Dataset From XML... Version: Visual FoxPro 7.0 Pre-SP1 OS: WinXP SP1 I have an XML string that has an in-line schema. It just happens that there is not any data in the XML document, meaning the table has no records. When I issue the XMLTOCURSOR() command, it is placing a record in the cursor and inserting .NULL. as field values. Question: The XSD handles the field names, etc..., so no problem there. How do I create an empty recordset from and XML string and an in-line XSD? I am an XML newbie so be nice... Tag: Naming files in VFP Tag: 200022
  - 14
    - Form works in one app but not in another Thanks in advance for the help... I have a form that I need to use in two different applications. It compiles in both applications just fine and it works properly in one of them. In the other I get a message Field "phrase" not found at the thisform.refresh line (according to the debugger). The error appears twice and can be ignored after which the form works correctly. Does anyone have any ideas about this problem? Thanks Jeff Tag: Naming files in VFP Tag: 200019
  - 15
    - sys(3050) I've been having a problem with freeze-ups in FoxPro 8, where a compiled application will either freeze entirely or seem to be frozen for a long time but then eventually come back online. This seems to happen especially when a user is just stepping through a table. I'm wondering if possibly this has something to do with the sys(3050) setting. Microsoft has a KB article in which they say that FoxPro does not always work very well with large amounts of RAM. Of course, all computers these days have large amounts of RAM. The KB article says 256 megabytes or more might cause a problem, and all the computers my application is running on have at least 512 megabytes. My question is, in general, is it a good programming practice to always use SYS(3050) in a FoxPro application to reduce the amount of available RAM? If so, what is a good number at which to set the available RAM? Kevin Clark Seton Home Study School Tag: Naming files in VFP Tag: 200018
  - 16
    - Chron job on server A client has asked us to write an app that will run as a timed job on a Windows 200 Server, using Windows ability to schedule the process to run at timed intervals. Is there anything special I need to know about 1. Installing a vfp app on a Windows server 2. Rights and other considerations for the job to run Thanks in advance. Josh Rubin Tag: Naming files in VFP Tag: 200014
  - 17
    - Problem installing VFP 7.0 on XP Home Edition Service Pack 1 When trying to install VFP 7.0 on XP Home Edition Service Pack 1, once de CD insertend into CD-ROM, even before being able to choose the option "Install VisualFoxPro 7.0" an error message apear: "Windows Component Update. Setup has detected that some of the Windows components that are installed on your computer do not match the version required for Visual FoxPro. You must install a different version of these Windows component" Than I installed XP Service Pack 2. No results, the message is the same when I try to install VFP 7.0. What can I do ? -- Manuela Musat Tag: Naming files in VFP Tag: 200000
  - 18
    - How to run SQL Script through VFP? Hi, Does anyone know how to run SQL script through VFP and load it into Oracle? Regards, Anand. Tag: Naming files in VFP Tag: 199999
  - 19
    - select statement problem Hi, The following statement is placed in the init event of myform thisform.grid1.RowSource = "select pinvitem.invnum, pinvitem.partno, invoice.invdate ; from pinvitem, pinvoice into table invallo where pinvoice.invdate = date() ; and pinvoice.invnum = pinvitem.invnum and pinvitem.recstat = 'P' ; order by pinvitem.invnum, pinvitem.partno asc" thisform.grid1.RowSourceType = 4 I got an error message : 'commands contains unrecognized pharse/keyword' but I do the above 'select' statement alone , it has no error at all. please give me a hand thanks Tag: Naming files in VFP Tag: 199997
  - 20
    - read only tables We are having problems where client machines cannot update tables. We are using vfp6 and the data is on a 2000server. The client machines are 2000 pro. When trying to write to a table we occasionally get error 111 'cannot update the cursor'. According to the help this is because the table is read only. This has happened with two different tables now and there seems to be no pattern to it. The error persists until the server is restarted. Until then the table cannot be written to. How can a table suddenly become read only? Has anyone else experienced this problem. Any help would be appreciated Dave Tag: Naming files in VFP Tag: 199996
  - 21
    - Different cell color in a grid using a cursor Is it possible to store values in a cursor to format cells in a grid? For example, I've the cursor: Field1 Field2 Field3 -1 1 3 1 -1 2 and the table: Field1 Field2 Field3 aa bb cc dd ee ff I would like to display the table using a grid with blue background cells for positive values of the same field of the same record in the cursor and red for negative values, like this: The grid: Field1 Field2 Field3 aa (RED) bb (BLUE) cc (BLUE) dd (BLUE) ee (RED) ff (BLUE) Any suggestions? Thanks in advance! Lorenzo Tag: Naming files in VFP Tag: 199993
  - 22
    - HP printer conflict I'm having trouble with HP printers. I'm running foxpro 2.6a.. REPORT FORM < > TO PRINTER PROMPT REPORT FORM < > PREVIEW The problem is occuring always running under terminal services, and intermittently on a conventional windows NT domain. Other printer ok.. only HP. Can somebody help me.. Thanks! wdennys Tag: Naming files in VFP Tag: 199990
  - 23
    - How to make an application to be minimized in taskbar tray? (Further Question) I have asked this question before. Thanks Eric and other guys of you that provide the solution to achieve this. I have tried it and it really shows the icon in the systray. But I have a question: I compile my project with this systray icon tool to an execution file. But when I run it, the main Visual FoxPro is still appeared, although the systray icon has been shown. I have included a command _screen.Hide. But the result will be the application quits. I have found a DLL, systray.dll that can really hide Visual FoxPro window the systray icon is appeared. But there is something that does not meet my requirement: When I left or right click the systray icon, the Visual FoxPro screen is appeared. What my requirement is: the application should be always hidden and the systray icon appears. When I right-click the systray icon, a menu appears that can let user to choose. Does anyone have any ideas or suggestion? Tag: Naming files in VFP Tag: 199985
  - 24
    - uncommitted changes and setfldstate I'm using a view with optimistic table buffering. I go to requery() an SQL view, but get the error: "Table buffer for alias ViewDocHeader contains uncommitted changes (Error 1545)". prior to this I use: 'setfldstate("DiscPCent", 1, "ViewDocHeader")' to manually set the field status of the view, because the control source has been changed for a control using the DiscPCent field, in debug I can see that this code: getfldstate(-1, tcAlias) returns "1111111111111111111111", why does it still think there are uncommitted changes, when in fact there isn't anything different and I've used 'setfldstate' Any help greatly appreciated. Grant Tag: Naming files in VFP Tag: 199982
  - 25
    - Editing a memo field in a grid I have created a grid and one the columns in this grid is a memo field. I can't use the standard ways of adding data or editing this memo field (CTRL-PGDN or double-clicking do this in a browse window). What am I missing? There must be some way to view and edit data in a memo field in a grid, but I can't find anything about this in the help files. I'm using VFP 7 / SP1. -Everett Tag: Naming files in VFP Tag: 199977
- Next
  - 1
    - How do I get match data from one table twice? I have a two tables. One is my product description table, the other is my Orders table. I have two fields in the Order Table that match one field in the Product table. I want to get the description for the new product and I want to get the description of the old product. How do I get this using a query. Below is my current query but this only brings back a null value for the old product description and the correct description for the new product. Select Orders.Product as NewProd, Productn.Desc as New_Desc,; Orders.Old_Prod, OLD.Desc as Old_Desc, Orders.inumber as Invoice; from Orders; inner join Productn on Orders.Productn = Productn.Productn; left join Productn as OLD on Orders.Old_Prod = Productn.Productn; where !empty(Orders.Old_Prod) Tag: Naming files in VFP Tag: 199964
  - 2
    - How to disable listbox entry I have the need to disable listbox entries that start with '\\', such as a network path. Normally, you start the entry with '\', and it will be disabled. If you have a legitimate backslash, you would change it two backslashes so that it is enabled and displays a single backslash. BUT - if you have two or more backslashes, it will just display backslashes and not disable the entry. How would you get \\SomePath to appear as disabled? I can put a space between a backslash and the rest of the item, but then I have a disabled entry with a leading space. Tag: Naming files in VFP Tag: 199963
  - 3
    - Excel automation Can somebody help me with this problem .. I need to add lines to an existing Excel file. To open the file and add the lines is no problem, but I need to check if the file is already open, so I don't open it again. So if the file is open in Excel, I need to add lines to the open file ofcourse. Thanks for the help Xavier Tag: Naming files in VFP Tag: 199957
  - 4
    - Which Control? Which ActiveX Control do I use to have Calendar that looks like the Outlook Calendar for a Month at a time? I am looking for a control that I can see if anything is scheduled for a day and the ability to add and view entries from the same form too. Respectfully, j. Morningstar Tag: Naming files in VFP Tag: 199949
  - 5
    - Getfile() Q. How do you get the Getfile() command to start in a specified directory? Respectfully, Jonathan M* Tag: Naming files in VFP Tag: 199947
  - 6
    - Dynamic Shortcut Menu I have added the custom class menulib in ..\samples\class\utility.vcx to my form. I load data in the array and call the shortcut in my right click procedure in the form. It works fine in this scenerio. The problem occurs if I have a top level form which calls a second form which contains the dynamic shortcut menu. Basically when I right click on the form, the menu is not displayed as part of form. Thus... Form1 is defined as Toplevel form, Always on top, Modal and calls form2. Form2 is defined as in toplevel form, modal, always on top. Any suggestion would be appretiated. Thanks Shahriar Tag: Naming files in VFP Tag: 199943
  - 7
    - 4up printed forms Am using vfp 5.0 and need to print a 4up 4x6 inch form that requires a page length of 12 inches. Unable to find a way to do this. Is it possible or what is the next version that will allow me to do this. Avery sells a packet of 4up - 4x6 inch forms which is not available on my version under labels. Tag: Naming files in VFP Tag: 199942
  - 8
    - change sct to prg ? Hi, Is there a way to strip a scr/sct file into a prg. I have made some forms with the formdesigner and would like to get rid of them and have the code in my prg. regards christophe Tag: Naming files in VFP Tag: 199935
  - 9
    - server time Hi All, How to get time value from another machine (server or another)? Client's OS could be Win98, NT, ME, W2K, or XP May be it need WinAPI, how is the easiest way to implement ? Thanks in advanced I'm using VFP 7.0 Tag: Naming files in VFP Tag: 199929
  - 10
    - what's the command? the old foxpro 2.6a.. running a screen using this command (eg. DO customer.SPR )..what is the command for visual foxpro... i try write DO FORM customer (but i needed to included the CUSTOMER form to run the form), in foxpro 2.6.. i don't need to included the .SPR cause alredy compile and embedded in the .EXE pls help me.... thanks! Tag: Naming files in VFP Tag: 199926
  - 11
    - MapPoint Looking for info on integrating MapPoint into a VFP app. Anybody aware of any papers that might be available? thanks Tag: Naming files in VFP Tag: 199925
  - 12
    - grid row alignment I have a page with a grid based on one local view ("the list page") & a details page based on another couple of views ("the details page"). The problem I have is when you click the button to show the list page and set the record pointer on the correct record, set focus to the grid, even refresh etc it will be highlighted on the row it was before leaving the list page. How can this be set to be "showing" the correct record/row? I have a feeling I've forgotten something, I've never had this problem before?! Grant Tag: Naming files in VFP Tag: 199918
  - 13
    - Help files not displaying on some machines I have an application in foxpro 6. Help files are all "*.chm". On machines that do not display help when F1 is pressed: Help is on Help file paths are correct Issuing a "Help" command has no effect. The application is the same on all machines so it appears to be related to the machine, not the program. These machines will display a help file when the file is double clicked in an open folder. Any ideas? With thanks Tony --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.749 / Virus Database: 501 - Release Date: 1/09/2004 Tag: Naming files in VFP Tag: 199911
  - 14
    - SQL datatime Field Having upsized my data to SQL 2000, my date fields are stored as "datetime" in the sqlserver. This causes problems in my forms where users were to only enter dates. Now it shows time along with date in my data entry forms. There is no Date field in SQL 2000 without the time? Any suggestions? Thanks in advance Tag: Naming files in VFP Tag: 199909
  - 15
    - Calendar Q. What is the best way to write a "Calendar" for VFP? I want a calendar that all users can see what people have scheduled for a day. I would like it to have the apperance of Outlooks Calendar. Tag: Naming files in VFP Tag: 199901
  - 16
    - Re: COMPILE REPORT ReportFile Ok, compiling the report generated an FXP file with the same name as my report format. 1. Should I remove the Report Format from my project and add the FXP? 2. Should I still use the REPORT FORMAT command to call it? Gary Z Sietse Wijnker wrote: >Hi Gary, >Try >COMPILE REPORT ReportFile >after you've cleared out the Tag1, Tag2, and cleaned up the Expr field >Regards, >Sietse Wijnker Gary Z wrote: >> I checked the Expr, Tag1 and Tag2 fields. They're still empty. This has got me >> stumped. Where's it getting the incorrect printer from now? Tag: Naming files in VFP Tag: 199878
  - 17
    - HowTo?: re-index LINKed FoxPro files (Access 2002/2003, Windows XP Professional) Scenario: The customer is developing in Access 2003 and installing the .mdb to systems running Access 2002. The customer is running legacy third party accounting software that uses FoxPro files. He has successfully used the ODBC driver for Visual FoxPro to update the legacy FoxPro .DBF tables. There are two other FoxPro files (.CDX, .FPT). After the customer updates the FoxPro .DBF, he unfortunately must open the third party accounting software's utility menu to re-index the files. If he does not do this manual task, the transactions that he added via Access are not visible in the third party accounting software. This manual step prevents the customer from fully automating the transfer of Access data into the legacy FoxPro database. That is the first part of this problem. The second part is the accounting system data is resident on a file server, and the customer is forced to LINK to the legacy tables. He has tried to update the legacy LINKed tables but Access will not re-index LINKed tables for him. I have been searching KB and MSDN and can not find any information about this problem. QUESTION: is it possible from within Access to programmatically re-index FoxPro files? ???? If yes, what is the Access command for re-indexing? If no, I assume (hope) it could be done with a few lines of MS Foxpro or C++ code ... or maybe there are some Foxpro utility programs that could do this via a simple shell to a command line (.cmd/.bat) file. ??? Thank you ................ gerry Tag: Naming files in VFP Tag: 199868
  - 18
    - progress bar In VFP 6.0 how can a progress bar be shown ? Tag: Naming files in VFP Tag: 199862
  - 19
    - How to execute Stored Procedures in Oracle from VFP? Hi, Does anyone know how to execute stored procedures in Oracle through Visual FoxPro? I tried SQLEXEC(gn_handle, "EXEC sp_sample(parm1, parm2, parm3)") but doesn't work. I tried SQLEXEC(gn_handle, "sp_sample(parm1, parm2, parm3)") but still doesn't work. Regards, Anand. Tag: Naming files in VFP Tag: 199858
  - 20
    - Eval Fn.??? hi, i want to know how i specify that the evaluate function didn't return valid value as xx=yy ?evalutae(xx) this will rase system error but iwant to check whether it is valid return value 1st or not thx -- Ramez Ernest Tag: Naming files in VFP Tag: 199856
  - 21
    - using datatoclip ? Hi, I'm just wondering how DataToClip can be used or better : why it can be used and in what cases if there is no ClipToData function or is there ? It's because I'm looking for a way to give my users the ability to copy a set of records from one table to another table with Ctrl+C and Ctrl+V. I've managed to do it for one record and while doing this I came across the DataToClip function and was wondering if there is one the other way so I can easely move around records. Of course there are other ways but well you know, at least just for the fun of using the clipboard.... regards christophe Tag: Naming files in VFP Tag: 199848
  - 22
    - Change in SQL commands! In VFP7 this commend work: SELECT MAX(nJN2_1) as MaxTime, cJN2_2 from jn2 In this command I can see Max of nJN2_1 and cJN2_2 that have Max Value. In VFP8 and VF9 when I run this command see an error: SQL: GROUP BY Clause is missing or invalid. Why? and if this command is changed, how we can know what record have Max Value! My E-Mail: HeartRefine@Yahoo.com Tag: Naming files in VFP Tag: 199840
  - 23
    - what file (extention) should be included for distribution setup what file needed (eg. foxpro 2.6 screen - .spr, the vsual foxpro ?), pls anyone.. help me..urgent! thank's.. Tag: Naming files in VFP Tag: 199838
  - 24
    - How can I determine when a file has finished copying so I can grab I need to import and process text files as they are copied to a folder. Some files can be a few megs in size and I don't want to grab them until they are copied completely. A coworker uses LEN(FILETOSTR('filename')) in a loop with a 10 second WAIT and grabs the file when the size stays the same two times in a row. Anybody know of a better solution? Thanks, Gary Tucker Tag: Naming files in VFP Tag: 199836
  - 25
    - VFP 6: Name Substitution If a is an object and b is the name of a property or column, what is the best way of accessing the property/column? I was using a.&b but tried to use name substitution, namely a.(b) The former works, but the latter does not. What is the correct way for using name substitution here? Sincerely, Gene Wirchenko Computerese Irregular Verb Conjugation: I have preferences. You have biases. He/She has prejudices. Tag: Naming files in VFP Tag: 199833

How can I rename a PDF programmatically?

I want to use the file picker to select the PDF, and then rename it
based on the value in a character field.

Thanks for the reply...

Top

Re: Naming files in VFP by Russell

Russell
Fri Sep 17 17:44:33 CDT 2004

File picker? You mean GetFile? GetFile will return the file name, then you
can do this:

OrigFileName = getfile("PDF", "Select", "Select PDF File")
NewFileName = juststem(OrigFileName) + alltrim(<table.field>) + ".PDF"
Rename (OrigFileName) to (NewFileName)

*OR*

Copy file (OrigFileName) to (NewFileName)

There are some variations on this, of course, depending on your exact needs.

Russell Campbell

<Mattheson> wrote in message
news:7dpmk05mo9knmqr891dqhrrkjkci60a9nn@4ax.com...
> How can I rename a PDF programmatically?
>
> I want to use the file picker to select the PDF, and then rename it
> based on the value in a character field.
>
> Thanks for the reply...
>

Top