Recent content by memarkiam

I have the same problem. But it's after 64 records. My import file has 42k rows. But it doesn't keep going. It just stops and returns me to the command line prompt. Any ideas? Thanks! Mark

No, sorry. I finnaly gave up, I'm afraid to say. Best of luck! Mark

Thanks very muchn for the quick repsonses! Unfortunatly, This seems to generate new errors. Is it maybe becouse I'm writing a query (view) rather than a procedure. If I can show you my SLQ (rather long, sorry), this may explain. I've wrapped my SWL in the first sugestion, but then I just get...

I'm getting the above error in a query. How can I 'trap' this error, and basically ignore it? Many thanks, Mark

Thanks! That's great - it hits the spot perfectly! Don't know how I missed that in the help file... If I can be cheeky and ask a follow on question: In the Macro I'm writing to go along with this sheet, I need to access data in several workbooks. I planned to do this by using: Dim R1 As Range...

Hi - I need to be able to change the name of the Worksheet, ideally by reference to the content of another cell. EG: =SUMIF([atvwk15.xls]storerep!$B$2:$B$201,$A$2,[atvwk15.xls]storerep!$D$2:$D$201)/SUMIF([atvwk15.xls]storerep!$B$2:$B$201,$A$2,[atvwk15.xls]storerep!$C$2:$C$201) In the above...

Thanks for this. It's interesting. But I don't think it solves my problem. I did try it, but one of my required settings is "Obtain IP/DNS Automatically", and selecting this just deleted all the IP entries I set up through the 'add IP address' interface. Thanks anyway. Cheers, Mark

I have to plug my laptop into various different client offices. Each one requires a different set of IP/Router/DNS settings. At the moment I manually change them each time. What a bore! Can I store muptiple IP settings, and switch between them on the fly? Many thanks for any help. Mark Lewis...

I have a problem. My web developer insists that their Websphere v3.5 can only produce referer logs seperate to the main web logs. In my (limited!) experiance, a web log is typically: User IP| Date/time| GET statement| refering page/key words The seperate referer logs I am getting from...

I need to access a Windows system via Terminal services from an office of Mac's It seems you can get software to do this for OS-X, but these Mac's are all on OS-9. I can't find any TS software for OS-9. Does anyone know how this can be done? Many thanks, Mark

I'm having trouble with DIV/0 errors. I can't filter this out in the HAVING clause as the whole role row will go, and there is data in other columns I need. Someone suggested using DECODE, which seemed a good idea, but I can't get the syntax right for this query. The particular statement that...

I thought I could use 'as' to name a column, and then use the column name in calculations. This would be particualry useful for aggregated functions. But I can't get it to work - I get 'invalid column name' error (on Oracle 8i). If anyone has any suggestions, that would be great! Thanks, Mark...

I thought I could use 'as' to name a column, and then use the column name in calculations. This would be particualry useful for aggregated functions. But I can't get it to work - I get 'invalid column name' error (on Oracle 8i). If anyone has any suggestions, that would be great! Thanks, Mark...

I managed to sort out most of my porblems in the end. Initially, I tried every admin apssword I thought might be relevent - but to no avail. Finnaly, I tried Administrator with the password from my personal user account - it worked! I have no explanation for this. This has given me full admin...

Thanks for this. I'm away for 2 weeks now. I'll try on my return. Cheers! Mark