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 Rhinorhino 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: *

  • Users: mm0000
  • Content: Threads
  • Order by date
  1. mm0000

    Merge 3 Excel files - works with Excel 2007 but not with Excel 2016

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

    Merge Excel files - working using Excel 2007 but not with Excel 2016

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

    VFP 8 on Window 7 64 bit

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

    SQL statement construction

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

    Find the odd ball

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

    XFRX reporting speeds..

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

    Queens English

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

    Appending dates form text file into a date field

    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?
  9. mm0000

    Html help window minimised

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

    HTML help minimised

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

    Treeview and form images

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

    treeview control and settings

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

    Date Conversion from character field

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

    Opeing PDF with VFP

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

    VFP table format

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

    Managing the VFP Notification Bar

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

    Windows Status Bar

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

    General field in Grid

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

    SQL query construction

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

    Report fonts for both normal and ascii reports

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

Part and Inventory Search

Back
Top