Search results for query: *

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

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

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

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

Greetings, What is the best way to analyze profitability of related, but separate transactions? Specifically, I am trying to analyze the profitability of vehicle sales transactions, but I would like to include the subsequent trade-in transactions. It is very common for a car dealership to sell...

Why is my report only filling up the top 2.5 inches of each page in the browser? I would like to attach an example, but the attachment option is not working. I've estimated that the output should fill approximately 7 (not 2.5) inches if printing to a landscape formatted report. I have tried...

Greetings, Is there a way to use "SELECT * FROM table", but EXCLUDE certain fields from the list? Frequently, when working with tables having a very large number of fields, I need to EXCLUDE from the output (SELECT *) just a few of the fields. As an example, let's say my table has 100 fields...

Greetings, What is the best way to join multiple tables together? I have 3 tables that I need to join into 1 table (or cursor). The 3 tables will be joined by a field which is present within all 3 tables called "index_ddd". I know how to join 2 tables, and I know I can then join the combined...

Greetings, I can't delete certain emails within my iPhone. I receive the message: "Unable to move message" "The message could not be moved to the mailbox Trash" I have no problem deleting other emails however. The only way that I can delete this particular message is to open Outlook on...

Greetings, Why does Excel 2013 take so long to open up a CSV file and save it as an Excel file? I recently upgraded to Office 2013 and encountered an issue involving CSV files: When I open up a CSV file, there is no problem. But when I save the CSV file as either ".XLSX" or ".XLS", it can...

Greetings, Using Excel, what is the best way to pull the last record in a series from one row into another row? We recently went through a big account number conversion and our CPAs have asked for a cross-reference of old account numbers with new account numbers. When I run the Chart of...

Greetings, Can anyone tell me why I can't use an Excel macro to hide or unhide certain columns within my Excel spreadsheet? I can manually hide or unhide these columns, but when I try to record the keystrokes using an Excel macro, it ends up hiding almost ALL of the columns (it only shows...

Greetings, What is the best way to suppress a single space character within a given field (if it is the ONLY character within that field)? I am exporting a file into CSV format, but can't seem to figure out how to suppress the single space character within the "MidName" field if there is NO...

Greetings, How do I get my PageFrame tabs to automatically expand with my text? I have tried changing the property "TabStyle" (there are only 2 options, Justified and NonJustified). The tabs DO expand if I also have "TabStretch" set to "1" (for multiple rows), but I do not want multiple rows...

Greetings, I have an Excel macro that calls certain files in order to extract data. Since I will be distributing this to different departments, there is a good chance that from time to time, some of these files will not exist (since these data files are created through input by people within...

Greetings, Has anyone seen the following error message (and it only appears on one computer): C:\Program Files\Common Files\Microsoft Shared\VFP\vfp9r.dll Unable to register the DLL/OCX: RegSvr32 failed with exit code 0x5 Thanks in advance, Dave Higgins

Greetings, What is the best way to round to the nearest half unit (ex: 47.0 or 47.5)? I know how to use the ROUND() function, but that rounds to the nearest whole number. Any suggestions? Thanks, Dave Higgins

Greetings, I have a master spreadsheet that links data from another spreadsheet. It works great, but it has a limitation. My problem is that the source of the data (the file location, the workbook, the worksheet, and the cell) is "hard-coded" into the master spreadsheet. I need the source of...

Greetings, What options do I have to bypass using Report Designer to load variables into a Report? I am building a very large report that will need about 500 variables and I am not looking forward to manually entering these variables one at a time in the Report Designer. Since a VFP report is...

Greetings, What is the best way to reference a cell in a worksheet from within an Excel Macro? Specifically, I need my Excel Macro to pull the value from cell "B9" from within the "Admin" worksheet. I have tried using the following, but this generates an error: lcFileNameDataGL = Admin!B9...