Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. keepingbusy

    Download single file fro ftp folder

    Hello I found the FAQ faq184-3234 I have tried the coding for "*... FTPGet.PRG ...*" Part of that is: DO ftpget WITH 'ftp.host', 'name', 'password', 'source.file', 'target.file'[, 1 | 2] I have tried using: DO ftpget WITH 'ftp://ftp.xxxxx.xxx/our_report', 'ourusername', 'ourpassword'...
  2. keepingbusy

    Straight forward FTP process

    Hello I have been looking at various scripts from a Google search but cannot for the like of me get this thing working. I am simply trying to open an FTP site and download a file from it. Here is an example I found: FTP -v -i -s:ftpscript.txt In the text file: open example.com username...
  3. keepingbusy

    Encase / Line up text from memo field in word document

    Hello I am using the code below (some of which has been edited / removed) to create a WORD document and add some records to it from a table. #DEFINE vfpCR CHR(13) #DEFINE vfpTAB CHR(9) #DEFINE wdSeparateByTabs 1 #DEFINE wdTableFormatColorful2 9 #DEFINE wdAlignParagraphLeft 0 LOCAL loWord...
  4. keepingbusy

    IIF( ) Function in grid column if condition applies

    Hi I have a table (MYTABLE) with multiple columns one of which I want to show a certain field if a condition applies or another field if it doesn't. A field within the table (MYFIELD1) is a numeric field which either contains the number 1 or higher. Two other fields (MYFIELD2) and (MYFIELD3)...
  5. keepingbusy

    Report Form: How to show a complete page as the last page

    Hi I have a question about the creation of a report form: A report form has been created (myreport.frx) In the TITLE band are label and fields which only appear on page 1 of the report - Thats ok and what I need The PAGE HEADER band also contains label and fields which appear on subsequent...
  6. keepingbusy

    The best application?

    Hello Guys Can someone please suggest a web based software application we can use to develop a program for an online inventory over our Intranet. I've done a Google search but getting lots of hits and not sure when to start. We don't mind paying for an application but if there is an open...
  7. keepingbusy

    Permissions on folders

    Hello guys I have recently let's say, "Inherited" the role of administrator on our system and still learning the trade so to speak. I have a couple of questions about file permission and viewing the path from a shortcut to an actual file I have been asked to set up a folder that contains...
  8. keepingbusy

    Report Form: Setting the order of Child records

    Hello guys I have created a report with two tables (e.g. MYMAINTABLE, MYCHILDTABLE) Both table have a common link of MASTLINK which is a numeric field The report itself prints fine with no problem but I am stumped to find out how you can order the Child records on the report so they show in a...
  9. keepingbusy

    ActiveX message using help file

    Hi For some reason each time I try to access the VFP 9 help file the following messagebox appears: An ActiveX control on this page might be unsafe to interact with other parts of the page. Do you wish to allow this interaction? If you select Yes, the help file does appear but when you try to...
  10. keepingbusy

    Variables not being sent to email

    Hi Can someone give me any idea why variables from an enquiry form that match those in the below code are not being received in an email: <?php $to='ouremail@someemailaddress.com'; $subject='Online Enquiry Received'; $name=$_POST['Name']; $email=$_POST['Email']; $phone=$_POST['Phone']...
  11. keepingbusy

    Formula for five columns on a spreadsheet

    Hi Guys I am fairly good at the basics using Excel 2007 but not a clue with what I'm trying to achieve. I want to create a spreadsheet with 6 columns: Date (that's easy!) In CASH In CHEQUE Out CASH Out CHEQUE Total I understand how to format the columns (e.g. date / numeric etc) Straight...
  12. keepingbusy

    Customer rating add on / code

    I am new to Coldfusion but have set up a website and want to add a customer rating/reviews for each property we have listed on the site. I am finding coding for php, wordpress etc but nothing for Coldfusion. Any pointers / suggestions please guys for a good reviews layout? Thank you
  13. keepingbusy

    Leading zeros dissapearing / Removal of character

    I have written a piece of code (Using Visual Foxpro) that exports data to a TAB file which automatically opens in Excel. I am using Excel 2007 with Windows 7 Column B in the spread sheet is a list of 12 digit numbers for example: \123456789012 Some of the numbers (which by the way are...
  14. keepingbusy

    Not clear on exporting to XLSX format frm VFP9

    With reference to thread184-1605291 I have tried out some of the code posted without success: COPY TO (THIS.cWorkFile) XLS loExcel= CREATEOBJECT("EXCEL.APPLICATION") loExcel.Workbooks.OPEN(THIS.cWorkFile) First off, I get an error: so I'm guessing this is used within a form. Having removed...
  15. keepingbusy

    SEEK v LOCATE and why does this happen?

    I use the following to search for an item in a table: SET EXACT OFF SET ORDER TO PRODNUMB SEEK(mprodnumb) IF FOUND() =MESSAGEBOX("etc etc.... THISFORM.GRID1.SetFocus RETURN 0 ENDI If I use the above, the item IS found in the table but does NOT highlight in a grid on a form but goes to the...
  16. keepingbusy

    Change SQL statement?

    Hi The following SQL statement produces members records linked to a project: Select * From MEMBERS WHERE MEMBERID In ; (Select MEMBERID From LKPJTYP Where PROJECTURN=m.mprojnumb) ; And ADD05 Like m.mcounty INTO TABLE tempinsert+'dbf' I am trying to link a "Supervisor" to the members who are...
  17. keepingbusy

    File folder permissions on creation

    Hi When we create a new folder on a shared drive, the security permissions automatically add "Everyone" to those permissions. Where do I look to change these settings or permissions please?
  18. keepingbusy

    Stop utitlity manager from opening

    For some unknown reason, everytime one of our users types in the letters SO the utility manager opens. I have no idea why this is happpening. Any suggestions guys and how do I stop it? Windows Server 2003 Thank you
  19. keepingbusy

    Line space in report

    Hi, Hope I can explain this suitably and to simplify it I've changed the field names: I have a straight forward report with Page header, Detail and Footer bands. In the Detail band are several fields from a dbf, one of which is called "NAME". On the Print when tab the setting Print Repeated...
  20. keepingbusy

    Outlook 2003 and attachments

    We are using Outlook 2003 on a network. When some users have an attachment on their email to send, it appears in an attachment line (similar to that of a subject line) but others have the attachment in the body of the email. Is there is a setting somewhere that can change the way email...

Part and Inventory Search

Back
Top