Search results for query: *

Thanks all I have created my main application menu to the similar look and feel of the office ribbon menu using a pageframe. I wanted to let the user know which section is active currently on screen, hence I changed the backcolor of the relevant activepage to a different color. Works like a...

Thanks Everyone I set the pageframe.themes to .f. and it gave me the desired results. Now the user will be aware which page is currently active as I have set a different backcolor when tab is clicked Thanks again

Hi all can someone please guide me how to change look - back color, font size etc. of individual pages of a pageframe. tried changing properties but nothing is changing e.g. I have a pageframe containing 4 pages, if I click on a tab caption that caption font should change and that particular...

Thanks all I figured out what I was doing wrong. I changed the code to oExcel.Activeworkbook.ExportAsFixedFormat() as tom suggested and it works Now I came across another issue i.e. when my excel workbook has multiple sheets generated, the output does not follow the same layout as the first...

Hi all I am using Excel automation for reporting in my vfp application. there are certain reports I need to generate an excel as well as a PDF output. the output is properly formatted as per requirement in Excel I tried out the excel export feature for which the code is as below oExcel =...

Hi all Recently came across the activeVFP library as I understand it can enable Web applications using the VFP language Was trying to find some documentation for this but was unable to find working sites. Can anyone help or has any knowledge of any useful documentation for this? Also Are...

Thanks Chris for the Advice and suggestions I upgraded to mysql connector 8.0.33 and it is working with existing code and data. Was using 3.51 earlier and been wanting to Upgrade. Regards Ravi

Hi all I am using Mysql as backend database for my applications the Mysql ODBC Connector version 3.51 (32 bit) is installed on my system and I give the connection string as below connection_string="DRIVER={MySQL ODBC 3.51 Driver};SERVER=" + m_server + ";port=3306;UID=" + m_uid + ";PWD=" +...

Hi Chris and Tom Thanks for all the advice. I downloaded all the latest service packs and hotfixes for VFP , installed them one by one The foxcharts library is now working. I can now provide my applications with graphical analysis features Hope this helps all the VFP community also Thanks...

Hi Chris Thanks I have done exactly that as given in the pdf but no success. the class just displays a blank box without the chart showing I have written to doug hennig about this. hoping for a reply Ravi

Hi all I recently came across the FoxCharts library which I thought could add value to my apps for providing various types of analysis I was trying out some test data for this. I created a form with a cursor like below CREATE CURSOR chartdata (reject_name c(20),mth1q n(3),mth2q n(3),mth3q...

Thanks Mike & Chris I did the above steps and it worked. The classes are showing up when I select view classes on the form controls toolbar thanks again Ravi

Hi all need some some help in using 3rd party classes in my form. How do I make the class available on any toolbar in the visual foxpro main window when a form is open? e.g I have a library which has a vcx file. how to use this vcx file in the form to set its properties and call its methods...

thanks chris Ill do some experimenting with that[bigsmile]

Hi all I am using excel automation extensively in my project for reporting My query is: I have a sheet with data on it -different types of data in different columns I want to generate different charts based on particular sets of data for which I need to select any 2 or more non-adjacent...

hi all I am using the grid control extensively to display data on screen Just wanted to know if there is any way to merge some columns (like excel) based on a condition e.g. my grid has say 5 column based on table data. if a record has a particular condition like field1 = 'TOTAL', i want the...

Hi all I have Requirement for displaying graphs in an excel worksheet based on the data that is written into the sheet using excel automation Could anyone point me in the right direction to do this ..? My excel report shoul contain formatted data as well as the related graphs on another sheet...

Great .. Thanks Mike. That worked !! I wrote the code as below oSheet = oActiveWorkbook.Worksheets(cmmyy) oActiveWorkbook.Worksheets.Add(null,oSheet) cmmyy is the name of the current sheet Thanks again Ravi

Hi all I am using excel automation in most of my applications. My query is : how to add a worksheet after existing worksheets in an active workbook using the worksheet.add method adds a worksheet before existing worksheets not after e.g. for a report based on monthly values, if I want to add...

Hi all I have a login form containing USERID (input type text), Username (span) and password. I want the Username span to be populated with the User Name retrieved from a database based on the entered User ID. Could someone point me in the right direction as to how to run an ajax script and do...