Search results for query: *

How do you reset server data access rights?

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

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

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

That worked! Thanks, Chris. You're a champ.

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

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

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

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

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

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

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.

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 =...

It works great! Thank you so much for your help?

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

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

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

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

My apologies, Mike (and everyone else); thats one (of many) reasons why I listed myself as 'technical user' instead of 'programmer' I believe this is the code in question: oX.Workbooks.Open("c:\rfportal\combine_project\rfps\&rfpvartext\final\&final_spreadsheet")...

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