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 bkrike 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 baconandeggs

  1. baconandeggs

    Invoice product code gone awry

    Dreamboat Is there a program that will assign a sequential number to an invoice form Best regards Jim
  2. baconandeggs

    Invoice product code gone awry

    Thanks for your help Dreamboat, I had difficulty E-mailing you twice, but I donT want to bother you too much, I can get by with what you hacve shown me, I really want to make the product codes numerical so with the long weekend upon us I will have a go best regards jim
  3. baconandeggs

    Invoice product code gone awry

    Dreamboat Thanks for your fast response, will this code only work in alphabetic order, as opposed to numeric or alpha numeric Bestregards jim
  4. baconandeggs

    Invoice product code gone awry

    Hello all Especially Dreamboat I have a .xls file wih an invoice which accepts the product codes (from the underlying worksheet), and fills in the next line on the invioce with the whole product name, but for some reason, it now only seems to pick up the first similar product Any help is...
  5. baconandeggs

    Beware the XP experience

    Thanks for your input lads Since my post I have found out that their is an isue with the xp system and Office 97 Professional, this is caused by a font, Microsoft had me find a file called hatten.tff, the rename it as hatten.old (press enter) restart my PC and reinstall Offfice after 2-3 trys...
  6. baconandeggs

    Beware the XP experience

    All Buying a new XP computer could be much more expensive than you might have realized, Office 97 professional is rejected with the message [ No licence on this machine ] if you have to have it to work you can upgrade to Office XP for £250 without VAT, the drawback is that this software will...
  7. baconandeggs

    formulas not working in excel

    Hello excel fans I have a problem with percentage returns in excel, A1 = 1.28 B1 = 2.2 C1= 67% Should return 4.70 Returning 3.70 I had a HLOOKUP table and found it didn;t work out right, the table based on a named range is the same as the above but Ihave used different cells...
  8. baconandeggs

    excel and word fault

    Yes Dreamboat when I press 1 etc nothing happens, but 4 to 8 works excel and word . Jim
  9. baconandeggs

    excel and word fault

    Hi all Can anyone tell me how to overcome this problem, I cant enter 1,2,3or 9,0 in word or excel, I have reinstalled Office 97, windows 98 and the sr1 and sr2 patches Heeee l p Jim
  10. baconandeggs

    Locked out of my bios?

    Hiya all my computer is a windows 95 75 pentium. 1995 - When I removed the RAM an error mesage came up about getting an upgrade, this is probably the bios upgrade from iCL Fujitzu ergopro x which is the PC's spec, as I am not familiar with BIOSes I left the bios and set it to reload on exit...
  11. baconandeggs

    Vlookup code ?

    Dreamboat You can have my email jim@baconaneggs.demon.co.uk That is exactly the sort of thing but I am not familiar with the 2 page connection I need to get my head around that. Best regards Jim
  12. baconandeggs

    Vlookup code ?

    Hey dreamboat Your saucy.. apologies to all I have tried to get back but have had to wipe my pc and start anew . Heres what I wanted to do #10 numbers which are constant and ascending they could be fixed prices, and it would be easier to enter numbers 1 to 10 which represented these ten...
  13. baconandeggs

    Vlookup code ?

    bkpchs237 Yes thank you very much for your time and trouble. I have had a little study and must admit i was under the impression that i could put a whole range of data say =HLOOKUP(A1:G1,RANGE,2) And be able to copy down .. that doesn't work =HLOOKUP(A1,RANGE,2) copied over cell to cell will...
  14. baconandeggs

    Vlookup code ?

    Hello all I need to code a VLOOKUP and have named a range. The problem is using the wizard, that is confusing , my range has two lines the top is numbers i want to put into a range headed TOTAL at the right hand of the form. the second line is the values they represent. 1 2 3 4 5 6 7 $2 $5...
  15. baconandeggs

    Is my database ruined?

    Gord I had this troble before , when they brought out windows 98 my 95 work would not update to 98 but 98 work would in 95 . I got over this problem though by deleting the cog icon in my floppy which says that the actual database your running is open, if you know what I mean , the icon that is...

Part and Inventory Search

Back
Top