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!

  • Congratulations TouchToneTommy 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: ganj
  • Content: Threads
  • Order by date
  1. ganj

    COPY to XLS creates bad Excel worksheet

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

    Excel Automation: What's wrong with my code?

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

    webcam image capture

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

    trimming fields in remote views with SQL Server backend

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

    1 digit checksum algorithm

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

    Display HTML page in VFP main window: Can it be done?

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

    Excel Automation: Adding formulas into cells

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

    combobox width

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

    Changing property of form 2 from form 1

    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?
  10. ganj

    cannot save changes to classes (vcx file)

    I had to dig out an old project which I last touched in 1999. The project is based on Codebook 6.1 and written VFP 6. Surprisingly, I am confronted with a rather situation I don’t understand: I open a class (modify class acurrency.vcx), make some changes (add code, reposition controls, etc.)...
  11. ganj

    Inno Setup script for VFP6

    Does anybody use Inno Setup to install VFP6 applications? I'm looking for a ready-made script to install VFP6 runtime along with application files etc. TIA, JoGa
  12. ganj

    How to extract a file from a compiled exe at runtime?

    I want to include a zip file into my project. Is there a way to copy (extract) a file embedded in the compiled exe to a folder? I want to avoid distribuiting the zip file as a separate file, rahter it should be embedded in the application. TIA, JoGa

Part and Inventory Search

Back
Top