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
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...
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...
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...
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...
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
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...
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
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...
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...
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...
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...
Hi all
I have a Database which was built on a 98 system with access 97 and when I tried to display it on a windows 2000 Pc it crashed the error message said "disc or network error, or disk hads failed this happened to 2 disks " anyone able to help,I would be grateful.
Jim
Hi Jerry
Thanks I actually copied the DB to floppy and tried it on win 95 and it was ok , it happens on every Db on my win 98 computer, I have also had some corruption in downloading files .
last time I had a problem with Access I changed the Startup file to [old] and renewed the program...
I have a problem with the date formatting control box of MS Access 97
The control box is fine as regards setting all other properties except date
When I place the cursor in the date selector grid it's fine but once I touch the Arrow button to select
 Long date
 Short date...
baconandeggs (Programmer)
Jan 6, 2001
Hello everyone
Can anyone straighten me out on a Select Case Statement for a timer
Overview:
I have a form which has a circle crossed by 4 lines and filled...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.