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 TouchToneTommy 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. kyletreyfield

    Naming Convention of Object

    I have a script that injests data from a webhook. I don't have any control over the field names that come in. The field name contains a dash, which I think VFP is interpreting as a subtraction symbol in the object name so it complains. I'm wondering if there is a workaround. Here is...
  2. kyletreyfield

    VFP9 won't start because of "insufficient memory"

    I’ve spent at least 12 hours going trying various things and researching online, but I cannot figure it out. I've been using VFP for over 20 years and never had this problem or anything close to it. I can/t start VFP9 on my server because of 'insufficient memory'. Specific Message is...
  3. kyletreyfield

    Calculate age of person in months if under 1 Y.O.

    I've gone through dozens of threads on here on this topic, and I realize its an old, very basic one, but I cannot find an easy way to calculate a person's age in months based on their DOB if they are under 1 year old. For instance, if today is 1/8/2023, and a person was born on 9/27/2022, they...
  4. kyletreyfield

    Divide a number of records equally using whole numbers?

    I have a set of records that will vary from a count of 1 to (lets say) 10. I need to insert a percentage of the total records as equally as possible in each person's record and the total percentages must equal 100%. The numbers cannot contain decimals; 1 person will have a different number...
  5. kyletreyfield

    Converting VBA to VFP

    I am trying to use the following VBA code but don't know how to put it in the language VFP can use. With .ActiveWorkBook.ActiveSheet Dim tbl As ListObject Dim rng As Range Set rng = Range(Range("A1"), Range("A1").SpecialCells(xlLastCell)) Set tbl =...
  6. kyletreyfield

    Shut down all instances of Excel

    I've been doing a lot of VBA scripting for a project I'm working on and inevitably the program crashes and I have an instance of Excel open. I can go into the task manager and close it, but when everything gets automated, I won't be able to do this. Is there any way I can go through and shut...
  7. kyletreyfield

    Excel VBA Copy String into Single cell

    I need to copy a string of text into Excel that may contain spaces and chr(10) so I want it all in one cell. Here is the code I've tried to use STORE filetostr("c:\path\filename.txt") TO _cliptext oSheet1.Select oX.SendKeys("F2") oSheet1.Paste oX.SendKeys("Enter") _cliptext = "" Pastes into...
  8. kyletreyfield

    VBA Excel copy from another worksheet

    I know there are multiple threads on this topic but no matter what I try I cannot get it to work. I am simply trying to copy some excel cells from another worksheet into my current worksheet, go to a different spot, copy another worksheet, etc. I keep getting the error that says 'Unable to...
  9. kyletreyfield

    Inserting variables in VBA (Excel) from VFP

    I am trying to launch this VBA script from VFP but I need to change the file path in the line: xStrPath = "C:\rfportal\combine_project\files\" This path needs to change 'on the fly' from my vfp program. I am just launching the macro because of its complexity, I can't get it to run entirely in...
  10. kyletreyfield

    Is Terminal Services Separate?

    I am looking into purchasing Windows Server 2008 software but I noticed that they sell a (separate?) package called "Server 2008 Terminal Services License". Is Terminal services separate or is it included in the standard Server 2008 package? Price for Server 2008 is around $550 and this other...

Part and Inventory Search

Back
Top