Search results for query: *

Hi, On one Excel worksheet I have a list of company names and numbers. The second sheet lists records showing every date that those customers have been contacted year to date. (could be one record, could be dozens). How can I create a formula on the first sheet that would show the last date...

Hi All, On a weekly basis I receive a workbook of 15 worksheets that contain some date columns. The date formats on the worksheet columns (and my computer settings) are set to dd/mm/yyyy. However, Excel is not recognizing dates that don't fit the the US standard format of mm/dd/yyyy. Excel...

Hi, I have split my display between my laptop screen and my monitor. This makes it extremely efficient for looking from one application to the other. (ex. Outlook on the laptop, Excel on the monitor.) Some applications such as Internet Explorer, Word and Outlook allow me to have multiple...

Hi, I've been asked to create a workbook that will contain monthly summaries of 4 workbooks. My master workbook will contain 12 worksheets - one for each month of year. Each worksheet will summarize information from 4 product workbooks. Since most of the product workbooks don't exist yet...

Hi, I have a VFP 6.0 application with several command buttons that is used to launch other VFP 6.0 applications. On some of the PC's in my company, when the user launches the secondary applications, the buttons and graphics on the main application disappear. If you click where you think a...

Hi, I'm trying to create some formfields (textboxes) in MS Word 2002 from VFP 6.0. I can create the textboxes where I want them. However, when I try to set the textinput properties, I get a 'Command failed' error even though the properties are successfully changed. Needless to say, I'm trying...

Hi, I'm trying to create some formfields (textboxes) in MS Word 2002 from VFP 6.0. I can create the textboxes where I want them. However, when I try to set the textinput properties, I get a 'Command failed' error even though the properties are successfully changed. Needless to say, I'm trying...

Hi, I recently took over an application and I would like to alter the features of the controls on the forms. There are many textboxes (~50) on about 10 forms. I want to add code to the 'gotfocus' event so the textboxes highlight when they receives focus. There is other code behind these...

Hi, I am using a menu designer created menu to navigate through my forms. ie File Form1 Form2 Form3 I open the selected form using 'Do Form' and then use the following code to close any other open forms. This works fine until I put scrollbars on my forms. It seems as though VFP6 is...

Each time I try to run the Setup.exe to install, I get the initial setup window but then the system hangs. I have to use the task manager to kill it. I have tried running the setup from a cd as well as from a network drive but with no luck. I have also copied the installed fpw26 directory...

Hi, When I create several pivot tables in an Excel workbook a 50 - 500kb file increases in size to 2 - 5 mb's. Once the tables have been created, is there any way to 'compact' the workbook? Thanks

Hi, I generate several reports on a network based database with 5 tables. The reports are all based on select queries with inner joins to connect the tables. The main table has only about 20,000 records. Whichever query is run first takes several minutes to run. Any subsequent queries take...

Hi, My client uses a mix of Win95/98, NT 4 Workstation, and Windows XP. (Eventually, they'll all be XP) I've always developed Apps for a Win95/98 world. How can I tell which O/S is installed and are there any 'gotchas' that I should know about XP. Thanks for your time.

Hi, I'm currently converting Excel97 VBA to Excel Automation in VFP 6.0. I'm trying to make a copy of a worksheet in the same workbook. In VBA, the command is: Sheets("Sheet1").Copy Before:=Sheets(1) Does anyone know a working version of this in VFP? I know of some workarounds...

HI When exporting data from VFP6.0 to Excel format(XL5), I am limited to about 16,600 rows. Can someone tell me if VFP 7 can export more rows, and if so, how many? Thanks.

HI, I have a listbox containing employees. When I select an employee, I want employee data to fill the corresponding text and combo boxes in the rest of the form. If I bind the fields to 1 table and use SEEK(), it's easy to automatically populate these controls. However, the data comes from...

HI, I currently have several VFP 6.0 applications that use Excel automation to export and format data to Excel 97 spreadsheets. My company is discussing updating to Office 2000 or 2002. Would anyone know if my VFP code will work for a new version of Excel or should I get ready to perform some...