Search results for query: *

Hello all I have a weird issue with Excel - when I click on a link to a web address Excel pauses for about 30 seconds before opening the browser. The cell contents: http://maps.google.com/maps?q=NN3+6LF+United+Kingdom I've also tried the '=hyperlink' function with the same result. If I use...

Hiya Just moved to Outlook 2010 from 2003. I regularly schedule appointments and need to invite contact groups of people (which include me). On Outlook 2003, all was well. On Outlook 2010 it adds everyone EXCEPT ME to the appointment. I then have to add myself manually! Any bright ideas on...

Hi all, Is there a way of creating an outlook rule, but only applying it to a specific folder? I want to be able to drag & drop specific messages from my inbox into a sub-folder which will then forward those messages to a distribution list. I can create the correct rule, but it operates on...

Hi all I'm new to sharepoint and trying to find a way of having tasks with sub-tasks. For example, each time our company exhibits we have to do things like book the space, book internet access, book hotels etc etc. I would like to be able to say create a 'New Exhibition' & a whole load of...

That's a really good thought - thanks for that. For some of what I want to achieve it may help. I think for other stuff when I want to add text the answer appears to be to create a WIKI for the topic & add links to files using the insert hyperlink button. Many thanks Phil

Hi all & thanks for looking at the question. I'm trying to create an information portal using Microsoft Sharepoint Office Server 2007. I want to upload lots of documents to a library and then have dedicated pages for each topic that include links to documents, for example a page which has...

I am creating a large number of stored procedures from vb code which are done dynamically because they need to be amended depending on the server names/IPs of the servers in each installation. The stored procedures copy data between a local server and a linked server. When I have an empty...

Thanks for all your suggestions. I can understand the logic of only having one router, but there are a couple of reasons why I have installed two! I already had the first router in place for my local network at home, and I didn't particularly want the vpn to be able to access that subnet. The...

Hello all. I have a slightly bizarre network set-up at home to allow me to be permanently connected to a vpn router at work, while having a domain at home. My internet IP address is dynamic and traffic comes in via a firewall router on the subnet 192.168.123.x (router .254) The 192.168.123...

OK....getting somewhere, but still stuck!! Although it says that TCP/IP and Named Pipes are the protocols in use, on a computer that SQL doesn't properly work on there is a log line (in SQL errorlog) that shows that named pipes has opened, but not TCP. In contrast, on a computer that does work...

Thanks for your continuing assistance. I can register the server with the client network utility and it is showing that TCP/IP and named pipes are the protocols in use.

The error returned is 'server does not exist or access denied' and I am connecting with integrated security (and the users are all administrators of their own machines). Excuse my ignorance on the other two points - what do you mean by 'net-library' and what is the 'Client Network Utility?'. Phil

Dear All, I'm really puzzled by this one... I've written an installshield package that installs a VB program and MSDE. It works perfectly on my test machine (blank install Windows XP). At the client's offices it fails on two machines but works on a third. On ALL machines it seems to install...

A small point, but I hate to see redundancy in code! In posts above there is some code like - If boolSomeThing=True Then DoSomething Are you aware that If boolSomeThing Then DoSomething has the same effect (and If NOT(boolSomeThing) has the opposite effect? Tends to make code more...

Many thanks - very useful!

I and several of my colleagues have encountered an irritating bug with VB 6 (sp5). Periodically you load a project & suddenly get a load of 'errors in formwhatever, see the .log file'. VB has lost a reference to either a date picker, or a perhaps a status bar & has changed them all to picture...

Off the top of my head I wouldn't expect ACCESS to expose it's internal controls' references when an instance of it was created. Anything you wanted to get at from vb would need to be exposed as an interface. EXCEL exposes items like the contents of individual cells through automation, but I...

I need to copy chunks of information from one SQL server to another. One is on a SQL 2000 server, the other is MSDE 2000 sitting on a local machine. I need to be able to copy whole rows at a time, but not whole tables. At the moment I have a rather messy solution where I create two recordsets...

Hi I'm trying to use an excel spreadsheet (with the first row containing column names and the rest containing data) as a datasource. I have built a connection string that works, but when I try to bring back a recordset based on some SQL I fail because I don't know what the 'table name' is for...

For a variety of reasons because of the way I need to access some data it would make my life much easier to create a new table for each 'job' on a database. The job will stay live for about 3yrs and then summary information will be archived, and the job table destroyed. I anticipate about 50...