Recent content by ganj

@danfreeman: copying to a dbf is not really a good solution because this truncates field names to 8 chars. I really need the full names. Yes, the SQL Server columns are all varchar type, but the Excel worksheet contains all field types: datetime, logical and numeric.

Rick, The cursor is based on a remote view (I'm using SQL Server). There are no memo fields in the cursor; the number of records typically is between 2 and 20. Regardless of nr of records, I consistently run into this problem. Thanks, Ganj

I have a cursor with 128+ columns that needs to go into an Excel worksheet. This works fine but when the number of columns is 100+, I get an Excel file that is bad, i.e. data not placed in the column where it belongs but in an adjacent column. I am running into the same problem, regardless of...

@Mike: The line causing the problem is: .PrintTitleRows = "$1:$1" What do you mean, "it's not the regular way to refer to a Row/column in automation."? This could be the solution! tia,

Mike, this code is preceeded by other code, basically creating the excel object, pasting data from the cursor, etc. The final step is apply some formatting, and this is where the bug strikes. tia, JoGa

I am getting the following error in a form method that creates an Excel worksheet from an underlying VFP cursor: Error #1429 in Outputexcel .... OLE IDispatch exception code 0 from Microsoft Excel: Unable to set the PrinTitleRows property of the PageSetup class .. ... The piece of code in...

I have a need to access a webcam using Visual FoxPro to capture images that will be stored in a database. I can't find any resources for this, which is surprising. I am using the Logitech QuickCam, which has an SDK for C++ and Visual Basic. I need to work in FoxPro. If anyone has experience with...

I have a remote view. The user performs some edits, changes are sent to the backend which is SQL Server 2000. The remote view is bound to a VFP grid. Now the surprise: the data on the SQL server shows all character columns padded with space char (asc 32) to the column size. How can I prevent...

I am doing a POS application. To acquire data, I am using a barcode scanner. I wanted to add a checksum to the code read by the scanner. The checksum should be 1 digit. What I have in mind is something like the ISBN number for books, where the last digit is also a checksum value. Any ideas on...

I want to display an html page (with gif/jpg images) and links in the main VFP window. Is it possible? I want to build something like a menu (instead of sidebar or toolbar), with nice picture buttons. I'm using VFP6 (not VFP7) TIA, ganj

I am creating an Excel sheet from a VFP cursor - simple and straighforward. But when it comes to entering formulas in columns, I'm stuck. How can I enter any kind of formula, including Excel functions in a range of cells? the kind of formula I need to enter is something like: =sum(a2..z2)/$a$1 TIA

@wgcs: your solution using the _screen array is the solution I was looking for. I can't use DO FORM FORM1 NAME oForm1 LINKED AND DO FORM FORM2 NAME oForm2 LINKED because my app is Codemine based, and this framework has another method of calling forms. thanks to all who posted, most appreciate...

my combobox width displays two values: small / large. the combobox has a width of 100 so it fits nicely on the screen. I want the drop-down part of the combobox in the same width. So I set columncounts 1 and columnwidth 100. When running the form, my open combobox igores this value. Instead, it...

I'm afraid but this does not solve my problem yet. How can I reference an object on form 1 from form 2? All I nned to to is change a property. I can't use linked forms nor public variable? Why on earth is a form totally isolated from another form and how can I break this? pls help!!!!!!!!!!!

I have 2 forms (no formset, no parent-child forms). In form 2, I have a button. In the button click event, I want to change a property of an object on form 1. How do I do this? How do I reference form 1 from form 2?