Search results for query: *

I've tried all sorts of methods to export DBF files to Excel, to work with large datasets and include memo fields, and I've recently worked on another way of exporting: Using Excel 2007's own 'Import Data' functionality. So the process is : 1. Create DBF file 2. Automate Excel to Import that...

I've not done javascript in 8 years so bear with me. I'm doing an FAQ page where I toggle the visibility of answers when the user clicks on the questions. I currently use: function togvis(id) { var e = document.getElementById(id); if(e.style.display == 'block') e.style.display =...

Setting the stage: Our corporation uses FoxPro / VFP .DBF tables to store data. Each client has an assigned folder on our network. Each client has the same list of tables in their hierarchy. Our corporation also has mandated SQL Server Reporting Services for our reports. I have written reports...

Real quick question: I see code like this: SELECT 0 USE table1 SET ORDER TO id .. which I, in my thrifty ways would write as: USE table1 IN 0 ORDER id So I ask why is the first form so prevalent (version compatibility aside)? I've been told the first form is faster. Why would that be so ?

I am printing W4's for my company on behalf our clients. I have downloaded the W4 PDF from the IRS website. I truncated it to a single page, and renamed some of the form fields to be easier to read. I then found this thread: http://www.tek-tips.com/viewthread.cfm?qid=939138 It details how to...

My initial problem was to create a Multi-sheet Excel workbook from VFP sources as part of an automated procedure. This ruled out using the COPY TO and EXPORT methods, as they create new workbooks. So I went with Excel Automation, using the _VFP.DataToClip(,,3) command to copy my currently...

(Also posted this in the "Office" forum, but the error seems to be with the VBA section, so here goes...) I have Outlook 2003, and I'm trying to set up a script to deal with messages from a particular cellphone. I have set up a rule that can identify and flag those messages, which was easy...

I have Outlook 2003, and I'm trying to set up a script to deal with messages from a particular cellphone. I have set up a rule that can identify and flag those messages, which was easy enough. The next step is to run a script based off of that message, which seemed easy enough: Tools -> Macro...

I'm using "InternetExplorer.Application" to automate IE and interact an application with multiple websites. However, one site has Basic Authentication enabled, and I'm stymied as to how to present the credentials via automation. I'm wondering if it's even possible using...

Some developers in house are using VFP, and some FPW 2.6, and still one using FPDOS 2.5, all writing tables for use with a FPDOS2.5 app. So, a simple question, one which has probably been answered before: I want to create a table in VFP, and have FPDOS/FPW able to use the table (so no...

As there is no builtin command in FPW2.6 that allows additions of columns to a table programmatically, I decided to write something to do the job... (call it a training exercise) I'm doing a COPY STRUCTURE EXTENDED TO... to a SYS(3) file. I'm then appending records for the new columns into that...

I've only just been introduced to FoxPro, so I'm not sure how it optimizes.. I have to do a blanket update to some fields for all records in a table, and then a record-by-record update of some fields based upon certain logic. I see 2 ways of doing this: 1/ Use a REPLACE .. ALL command for the...