Search results for query: *

HI, I have a Excel sheet that has pivot tables that pull data direct from sensitive company data. I have no problem with the end user drilling down to the data inside the spreadsheet, but I do not want them to be able to right click on the sheet and select "move or copy" to another sheet...

HI, I have been given a csv file to import that contains almost every type of problem you can think of. I have dealt with tabs, commas and pipes, which are all normally used as separators. But I am stuck with the quote char. An example. the following is part of a text field: "UK games firms...

HI, I am required to post via https to playtrade.com However I have never posted to a website before. I picked pieces up from various websites (and from playtrade direct) and produced the code below: Dim username As String = "[email address]" Dim password As String =...

Hi, I hope someone can help. We have a small network operating under a xxx.xxx.xxx.nnn ip range. It consists of several desktops (roughly 40 inc laptops that come and go) and several servers (some virtualised). Just recently people have been reporting having problems on the network. What...

HI, Before I start, I am still learning VB (started two months ago as a sideline in my main job) and the routine below has been cobbled together through various guesses and parts pulled from here, there and everywhere. The basis of the routine is to go through my inbox, find the unread...

HI, It's been a while since I was around (long time between jobs). Sorry about that. In my new position I have a problem with one user. On the server there is an area open to all (called public). In this area, several people have created thier own directories. This particular user has a...

HI all, The MD currently has a HP 2300 directly connected to his computer (parallel). He only prints from IE 7, as he only uses his computer to access remote e-mail. The printer is in his office to allow him to print sensitive mail. The problem is that when he asks for a print, via the ctrl-p...

I have a user where they can use iNotes to look at mail and read it without a problem. However, when they reply to a mail or even create from scratch, when they press the send button, immediately it comes up with a blank page that shows "internet explorer cannot display this web page". The...

Probably me being a bit of a noob, but when I try to run this query INSERT INTO data ( Type, Who, Collection, Item, Qty, [Date], [Time] ) SELECT MAPAMEND_ACCTRANS.F1, MAPAMEND_ACCTRANS.F2, MAPAMEND_ACCTRANS.F3, MAPAMEND_ACCTRANS.F4, MAPAMEND_ACCTRANS.F5, MAPAMEND_ACCTRANS.F6...

Not sure if this is the right place for this sort of question. We need to setup some kind of virtual printer to capture reports and send them to a PDF file. At the moment what we have is a HP printer that is sent data from an iSeries. This printer holds a series of macros in its memory and...

Hi, I have a large number of databases that rely on getting data from outside sources via ODBC. Each month several new files are created called itmb[year][month] for example, where [year] & [month] are for the period just finished. At the moment I have to go into each databse, perform a link or...

Can anybody please help!! I have just acidentaly replaced the design of the admin / server document with another - I was doing a few things at once and forgot where I was. I was in the administrator, servers view when I selected database - replace design and selected inotes. Now the server is...

After playing (A lot) trying to setup webmail on our windows 2k server, I have managed to get it to allow someone to login to their mail. But they do not see any documents in any folders except "Discussion". The inbox, sent, all documents etc are blank (in firefox - in IE they come up "Page...

Hi all, We have been running Domino for quite a few years now, but only as a mail server via Notes. Our remote users have had Note sinstalled on thier computers and connecting fine. I now need to set up some mail boxes for our far east friends, and do not want ot have to go there and install...

Sorry if this is an oldy but I can't find any reference in the forum for it. I have been passed a computer that is infested with surfsidekick 3. It is running widows XP SP1. I have removed lots of other rubbish from this machine, but this one is difficult to remove. I have tried using msconfig...

One of the directors has asked if there is a way to show which cells have been changed in an excel spreadsheet. I guess he wants to change the format of the cell to show it has been changed. I have looked at this thread: http://www.tek-tips.com/viewthread.cfm?qid=584876 Which seems to do this...

I have a small table that contains a list of upcoming sales orders and purchase orders. It also contains a "start" value (which is the current stock). I have generated a query that puts the transactions into item & date order. An example of the data is: item date qty...

Sorry about this, but it may be very basic as my knowledge of sql can fit on the back of the worlds smallest postage stamp. Anyways some background. Previously installed veritas backup exec 9 on a windows 2000 server. I beleive this installs a version of sql, as I get "sql service manager"...

Curently running Panda anti-virus over lotus domino. I am looking to install a spam filter and a spyware blocker. This is to be run over the network, so the best way is if it can be installed onto the desktop. Does anybody have any recommendations? I have mailed panda to ask if they do anything...

Is is possible for me to pick up some text in Word (same location EVERY time) and use this as the filename in a "saveas" command? [pc] Graham