Search results for query: *

Hi Olaf and Mike, Thank you both for your guidance. I am very interested in utilizing the APPEND FROM xyz FIELDS (fieldlist) as you suggested. Mike ... If I understood correctly, since my data has column headers in row#1, I should be able to select the second table, and then append the...

Greetings, I need to import some raw data (CSV formatted) into a VFP table, but my raw data contains about 280 fields (or columns). I am able to import the first 255 fields without any problem, but I receive the error message when I try to import more than 255 fields. I still need some of...

Koen ... my apologies for the delay in responding. Her computer is currently turned off ... I will check in the morning and reply. Thank you for the follow-up. Dave

Hi Scott, The computer having the problem is an HP EliteDesk 800 G1 SFF (according to the System Info screen). It was recently rebuilt and has MS Windows 10 Pro with 8GB of memory. Thanks, Dave

Thank you all for your input! Scott ... Good question about what is different about this PC. It was recently rebuilt and had Windows 10 installed, but nothing else is unique other than that. This is a brand new installation of my program on that particular PC (therefore it never was installed...

Thank you Scott, Olaf, and Tore, Great suggestions. Based on your input, here is what I found/done: Tore: I am not sure how to check to see if the Video driver is bad. How would I do that? I would assume a bad video driver would also affect other programs. Olaf: (1) Themes is definitely set...

Hi Scott, Good suggestion, but that is not the problem. The Pageframe property "Tabs" is indeed set to .T. (please see attached link on page 2). ALL of my other installations of this particular program are displaying the Tabs properly. Just this one computer refuses to display the Tabs. I...

Greetings, Within a VFP screen form, what would cause the tabs (pages) to be hidden? I have hundreds of installations of this specific program, and until now, all are working properly. But on just one computer (which was recently wiped clean and rebuilt), the form does not show the tabs...

Thanks Skip, I'll give your code a try ... It sounds like what I'm looking at. Have a great day, Dave

I agree. I just want to use MySql to create these data points, and then use HTML (rather than Excel) to display and graph this data. Dave

I'd like to display the result as a Trend in a browser, rather than have to open Excel. And I'd like the output to look something like this: Dealership#1 ... GrossPybl_2016_03 ... GrossPybl_2016_02 ... GrossPybl_2016_01 ... GrossPybl_2015_12 ... GrossPybl_2015_11 etc Dealership#2 ...

Great idea! Never thought about handling it entirely within Excel. But if I also wanted to create the data points within the program (and not use Excel), how would I best do this? Thanks, Dave

Hi Chris, Thanks for the reply, but I do not want to calculate the MAX() of anything. I am trying to total up all the amounts within each month (for the most recent 25 separate months). I would then like to be able to display this info on a trend-line showing 25 separate data points (2 year...

Greetings, What is the best way to create a Trend report using MySql? The following code lists all the individual records, but I would like to total and group the gross payable (using field "grosspybl") amounts within each of the most recent 25 months (based on field "dealdate"). select...

Hi Zelgar, Thanks for the link. After reviewing the info, it appears that I have all the same specs as recommended: incoming port=995 no SSL / 587 encrypt=AUTO / SPA=NO / Outgoing server (SMTP) reqs auth=YES: except for: "Encryption = AUTO" After making the change, I still receive the error...

Greetings, Does anyone know why I am getting the errors below while trying to add a new email account to Outlook 2007 on my Windows 8 laptop? I need to re-add a "live.com" account which WAS previously working in Outlook on the same computer. I decided to delete and re-add this account, in an...

Hi Brigmar and Olaf, Many, many thanks! You guys are amazing to me. This now does exactly what I needed. Very clean and elegant solution. Thanks so much for your help. Dave

MK and Olaf, Thank you! Your solutions are very close to solving my problem. MK, you brought up a valid concern when you said: I can presort the data before using your code, but notice stock number "K4376A". In a larger data set, there would likely be another "non-related" stock number...

I too agree. Dave "Stone Tablet" Higgins

Olaf, I agree with you, but surely there must be a way to link together the 4 transactions in my example. If transaction #1 is linked to #2, and #2 is linked to #3, and #3 is linked to #4 ... then somehow I should be able to create a common (and automated, not manually entered) index to link...