Search results for query: *

The code below is for merging 3 separate excel files into 1 file. It works for Excel 2007 but does not work with Excel 2016. The code below is written for Visual Foxpro but you should understand it. Are there any changes in Excel 2016 VBA I should be aware of that stops the code from working...

I have this code which merges files without problems with Excel 2007, but it does not work with Excel 2016. With Excel 2016 the 2nd and 3rd tabs are not populated but remain blank. Could anyone confirm that the code below does/ does not work with Excel 2016. ERASE d:\x*.xlsb **copy 3 excel...

I am planning to get a laptop with Window 7 64 bit Pro. I would just to know whether any one here has loaded VFP 8 on Window 7 Pro 64 bit and whether they have faced any issues. Thanks in advance

Need help in constructing a SQL query to get results as shown in the example below. Table0 AO FD VL BK AC 01 BK BU XX BD AC 01 BD BX NNN Table1 US PR U1 A U2 X Table2 PR AT AO A B BK A C BD X D...

This is a variation of 'The Odd Pill' thread but much tougher to solve. You are given 12 balls identical in appearance, however one ball is heavier or lighter than the rest. In 3 weighings, using a balance scale, find out which ball has a different weight and whether it is heavier or lighter...

I have recently purchased VFP ver 9, and have been testing XFRX with VFP 9. The XFRX manual states that generating XFRX reports(using XFRX#LISTENER) with VFP would be approx twice as fast than with other versions. However, I am finding that the time it takes to generate reports VFP 9 is...

This is an essay written by a candidate for Indian Administrative Exam. I had read this in a newspaper article several years ago. I came across it again recently and still find it extremely funny. Indian Cow HE IS THE COW. "The cow is a successful animal. Also he is 4 footed, and because he...

I have a text file in which dates are stored in YYYY-MM-DD format. After setting date to ansi + century on and then importing the text file it does not import the date values into the date field. All imported date fields are empty. What am i missing out?

I am using HTML Help Workshop to create my help. However when I press F1 to call the relevant html page it opens with the help page minimised. Anyone knows how to get the html page always open maximised? thanks in advance

I am using HTML Help Workshop to generate the compiled chm help file. However when the context sensitive help is called from VFP the relevant html file appears minimised. Has anyone worked with HTML Help Workshop and faced/solved this problem. I could not find any compilation setting to have...

I am developing the treeview control as a menu,however when i click on a node and launch a form and move the form around it leaves a trail of images on the right hand side of the control. Even when I release a form part of the form remains on the screen. How can I prevent these images from...

I have been experimenting on using the treeview control mentioned refered to in one of the earlier posts (treeview2.zip). However, what I have noticed is that once I load this control all my existing settings (set deleted, set talk, set safety etc.) - appear to have changed. I have a program...

How can I convert a character field with dates in the format 'DD-MON-YY' to a valid Foxpro date.

How can I open an adobe acrobat document for viewing from within Visual FoxPro by pressing a command button. The name path and name of the file is stored in a field in a table.

One of the advantages of adding tables to a database is that they can be no longer opened using excel etc. and have to opened by other apps using odbc connectivity etc...... I do not want to use databases just yet but would like to have the tables in the new format. How can you programmitically...

In my application the table that is open along with 'Exclusive' or 'Record Unlocked' etc... is displayed in the notification area. Q 1 - How do I prevent display of this information. Q 2 - If possible, how can I utilize this band by displaying, say the value of a memory variable in this band...

In my application the table that is open along with 'Exclusive' or 'Record Unlocked' is displayed in the notification area. Q 1 - How do I prevent display of this information Q 2 - If possible, how do I display, say the value of a memory variable in this band? thanks.

How do I display the icon on a general field in a grid. When I create a grid with a general field - only 'General' is displayed and clicking on general shows the icon. thnks in advance

How to construct a SQL query. I have 2 tables Table1 Col1 col2 col3 A B 5 A B 5 Table2 Col1 col2 col3 col4 other columns... A B 5 A1 A B 6 A1 A B 5 A2 A B 5 A2 A B 7 A3 A B 5 A3 ..... ..... I want to select all rows from table 2...

My reports all have been set to an Arial font. However, the problem is that if I report to ascii file the formating/spacing in many cases gets affected - overlapping, truncating, reports fields getting misaligned - is there any font that I can use which would not cause any formatting problems...