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!

Register Log in
  • Congratulations derfloh 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

    Thank you Mike. As I said the "comments_upload-1_file" name comes from an outside party's API. I need to put it into an object but I can't change the name.
  2. 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...
  3. kyletreyfield

    VFP9 won't start because of "insufficient memory"

    How do you reset server data access rights?
  4. kyletreyfield

    VFP9 won't start because of "insufficient memory"

    Thanks all. I've tried all these things but to no avail. I even tried re-installing on a different drive. Usually most programs have log files that are used to diagnose problems. Where would I look to see a log file for when VFP wouldn't start because of insufficient memory? I'm...
  5. kyletreyfield

    VFP9 won't start because of "insufficient memory"

    I do have pagefile on the hard drive. Here are my settings for both c and d: As far as the directory, VFP9.exe is in a directory called "Microsoft Visual Foxpro 9", which is under program files (x86). The directory is read only, and if I try to change it, it keeps coming back. I've...
  6. 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...
  7. kyletreyfield

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

    That worked! Thanks, Chris. You're a champ.
  8. 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...
  9. kyletreyfield

    Divide a number of records equally using whole numbers?

    Chris, I believe the insurance companies require whole numbers but I'm double-checking that to make sure. Thank you for writing a response with code. I think it will work, but I am curious as to why you start out with both 'recordcount' and 'usercount'. There really is only usercount - each...
  10. kyletreyfield

    Divide a number of records equally using whole numbers?

    Yes! Mike is right in his explanation of my question, and so is Chris -in his last paragraph. These are beneficiaries to a life insurance policy. Instead of making the user enter their spouse and kids along with the percentages, I want to make it easy on them by allocating 'as equally as...
  11. 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...
  12. kyletreyfield

    Converting VBA to VFP

    It works! Thanks again. I think I'm learning how to do it now. Appreciate you.
  13. kyletreyfield

    Converting VBA to VFP

    I'm an idiot. I read through the whole article you recommended and spent about 4 hours messing around with the script and it still doesn't work. I think it's because I didn't define everything properly as you suggested but after searching on the Internet I'm still at a loss. All I'm trying...
  14. kyletreyfield

    Converting VBA to VFP

    Thanks to both of you. I've been trying to learn object-oriented programming and VBA related to VFP but always run into situations I can't figure out. I will read the article you mentioned. As usual, I REALLY appreciate your help (both Chris and Mike). Thanks again.
  15. 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 =...
  16. kyletreyfield

    Shut down all instances of Excel

    It works great! Thank you so much for your help?
  17. 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...
  18. kyletreyfield

    Excel VBA Copy String into Single cell

    Thanks, Ljupce. The paste has always worked,as it did now, but the problem is that I want the whole string to be pasted into one cell. When you do it manually, you can either double-click the cell, or press F2 (edit). I thought sendkeys would be the answer but I'm not even sure if...
  19. 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...
  20. kyletreyfield

    VBA Excel copy from another worksheet

    Mike, works like a charm! Can't thank you enough, as usual. Again, I apologize for the bad coding etiquette.

Part and Inventory Search

Back
Top