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 Chriss Miller 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: tilltek
  • Content: Threads
  • Order by date
  1. tilltek

    Foxpro dbf to SQLITE

    Is there a way to easily convert DBF files to SQLITE files and back? From within Foxpro if possible. Note that I need SQLITE files , not SQL. Ken
  2. tilltek

    Populate a simple HTML table from a list.

    Is there a simple way to populate a HTML table from a list so that updates can be made easier? Kenny
  3. tilltek

    A SUMIF() I think

    I have been given the task of adding to an existing spreadsheet. The problem I have is I think quite simple but I can't get my head around it. 1 | A | B | C 2 | 100 | 201 | =SUM(A2:A5) 3 | 235 | 203 | 4 | 1,232| 309 | 5 | 1,125| 201a | At the moment the sheet has the above...
  4. tilltek

    A conditional problem?

    Well I think perhaps it's an if() problem. I have 3 columns, A, B and C labeled “IN”, “OUT” and “BALANCE” in row 1. So in row 2 I feed last months carry over balance into “2A” and set “2C = 2A” Then row 3 onwards I set “3C = 2C + 3A – 3B” (new balance = previous balance plus IN minus OUT) But...
  5. tilltek

    Conditional format not working

    In Excel 2003 I am trying to do a simple alternate line color with "FORMULA IS" and "=MOD(ROW(),2)" This throws a error and highlights the ",2" I have tried typing the data in manually and also tried cut and paste from various help sites. What am I doing wrong? Ken
  6. tilltek

    XP keeps finding hardware

    Every time I boot XP sp3 I get the "Found new hardware" wizard. Seems XP thinks I have a PCI device. If I do what it asks it eventually says "can not install." So I put a tick in "don't prompt....." and then it all starts again. Found new hardware, found new hardware, found new hardware until I...
  7. tilltek

    Path to CLASS BROWSER

    When I fire up VFP9, SP2 I go to [Tools] and [Class Browser] is greyed out. I go to [Tools] [Options] and put in the path to BROWSER.APP. I hit [Set As Default] OK, all is well, until next time I load VFP when I have to do it all over again. What am I missing? How do I make the path to...
  8. tilltek

    AMEMBERS()

    I'm sure this will turn out to “dumb question of 2010” but I just can't get AMEMBERS() to work for me. I've searched high and low and found literally hundreds of sites and books that give the same sample. goForm1 = CREATEOBJECT("Form") && Creates a Form = AMEMBERS(gaPropArray, goForm1, 1) &&...
  9. tilltek

    Change caption on Command Buttons

    I have a dozen or so Command Buttons on a form which allow the user to input information easily. Button "Command1" may have the caption "FROGS" and when clicked return "XF001" which is a code in a product datafile for frogs. My question.. How can I allow these captions and what they return be...
  10. tilltek

    Windows Installer starts on clicking a folder

    I've read and re read several posts that have had the same or a similar problem but I can't find an answer. Out of the blue, a few days ago, each time I double click a folder, in either Windows Explorer or Opus Explorer or even on the desk top, I get a window headed "Windows Installer" and a...
  11. tilltek

    Conditional format a worksheet via VFP

    Regarding conditional formats . Normally, in Excel, I manually create "striped" sheets to resemble fan fold paper by highlighting the whole spreadsheet and then going into conditional formatting and selecting "formula is" and "=MOD(ROW(),2)=1" and "light yellow", which produces sheets that are...
  12. tilltek

    How to split a sheet.

    I can format an Excel sheet OK with statements like .... oExcel.ActiveSheet.Columns[6].NumberFormat = "##,###.00;;" And oExcel.ActiveSheet.Columns[2].ColumnWidth = 8 And so on, but I can't for the life of me figure out how to programmatically split the sheet so that the column headings in row...
  13. tilltek

    Overcome the record limit of copy to XL5

    When exporting to EXCEL 5 there is a limit of 16,384 records. I have well over 60,000 records. Is there some way to get around this 16,384 limit? Is there a way to concatenate sheets or some such work around? I think Excel can IMPORT an unlimited number of records. Could an Excel macro be run...
  14. tilltek

    FoxPro for Unix

    A simple question. Has anyone ever run FoxPro for Unix? Will it run on a Linux box? Aussie Ken "Far,Far Away" CAMIGUIN
  15. tilltek

    Is a dll registered?

    How can I programmatically check that a .dll is present on a users machine? I want to add speech to a VFP program but I will first need to check that xxxxx is registered and then do a if...else...endif. Aussie Ken "Far, Far Away" CAMIGUIN ISLAND
  16. tilltek

    WAIT position

    This has been asked several times in the past but never answered so here it is again... How do I position a WAIT message relevant to the VFP window as opposed to relevant to the Windows Desktop. Aussie Ken "Far, Far Away" CAMIGUIN ISLAND
  17. tilltek

    Date manipulation

    I’m beginning to think the following is not possible but perhaps someone can figure this out. I have to work with an bean counter (accountant) who breaks months down into periods that run from the 1st of the month up to and including the first Sunday for period one, then from Monday to Sunday as...
  18. tilltek

    Is OS XP or 98

    How can I tell, in a dos batch file, if the OS is 95, 98 2000 or XP? Are there unique files in each system that I could use? Thanks in advance. Ken
  19. tilltek

    Auto selecting dates for weekly figures.

    I have a bit of code that adds figures from sales sheets for given periods. These periods (week 1, week 2 week 3 etc) are.... Week 1: from the 1st of the month to the first Sunday. Week 2: from the following Saturday to the following Sunday and so on, NOTE that the first and last weeks may well...
  20. tilltek

    Two rows of caption on a command button

    On the caption of a command button, is there any way to have two lines of text so that instead of.... HELP I can have... HELP FILE Ken

Part and Inventory Search

Back
Top