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!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by tilltek

  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

    Thanks for all your help but before I could get stuck into it the guy decided he didn't need it after all. Kenny
  4. 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...
  5. tilltek

    A conditional problem?

    Thanks guys and gals, solved it. I used =IF(A3+B3<>0;C2+A3-B3;0) In other words, if column A + B are zero then so is column C Otherwise do the sum and put it in C. Thanks all.
  6. tilltek

    A conditional problem?

    This might explain better what I'm trying to do. 1: A B C ------------------------------ 2: IN | OUT | BALANCE ------------------------------ 3: 1,000 | | 1,000 < C3=A3 (this is a carry over balance) 4: | 200 | 800 < C4=C3+A4-B4 (new...
  7. 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...
  8. tilltek

    Conditional format not working

    That's it SkipVought. Would you believe it. Solved. Thanks Kenny
  9. tilltek

    Conditional format not working

    I type or paste in =MOD(ROW(),2) and windows returns The formula you typed contains an error When I click ok my formula has the ,2 highlighted. Ken
  10. 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
  11. tilltek

    XP keeps finding hardware

    <<< So one of BadBigBen's final suggestions fixed it. Not so. What I wanted was to solve the problem but after trying all the members suggestions I just gave up and deleted the sound card in the BIOS, which was always an option. But thanks Ben and others, all good advice,
  12. tilltek

    XP keeps finding hardware

    Sorted. I gave up trying to repair the problem so after much searching in the BIOS to find VIA HDA (it's under AZALIA HDA)I disabled it and fitted a cheap PCI audio card and all is OK. Thanks to all members. Kenny in Angeles city,
  13. tilltek

    XP keeps finding hardware

    Driver Max says I have all up to date drivers INCLUDING the Via Hi Def Audio one. Ive only had the problem recently but I can't remember when exactly it started. There is a Audio chip built into the mother board but it no longer appears on the hardware list in the BIOS. How can I stop XP...
  14. tilltek

    XP keeps finding hardware

    Sorry to take so long getting back but I have just moved from Camiguin island in Mindanao to Angeles city in Luzon and setting up house has been a number one priority. Thanks for all the suggestions. I have tried all the above to no avail. Unknown Device Identifier finds a VIA Chip Technology Hi...
  15. 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...
See more

Part and Inventory Search

Back
Top