Search results for query: *

I have a custom Outlook task form that allows me to manage work for a client. I use my own notes field as a UserProperty. When I set the form up and create a new task the form displays correctly and I can add comments to my GPCNotes column. However, as soon as I close the form, I can no longer...

Folks, I'm looking for a solution to mapping cloud storage for users in their login script. The cloud accounts are all created using the domain username, the email address, or a global login. What I want to be able to do is connect a number of different cloud solutions as mapped drives via a...

I seem to have gotten myself into a bit of a tangle with this bit of dynamic sql. Can anyone look at it with fresh eyes and clear it up for me? The statement is stored in a table as a string. It's actaully a string that runs against a Postgres database using OPENQUERY. The table is read and...

I think I may be missing something really obvious here. I want to create a copy of a table without the data. The tables are dynamic and so I can't look at a given column and do WHERE ID = -1 or something similar. Some of the tables may be very large. What I'd like to do is effectively run a...

I'm from a SQL Server background, and this is the easiest thing in the world to do in SQL Server. In Postgres it seems to be much more difficult. I want to find the date a table was created and/or last updated. This is in the schema in SQL Server, but I can't find anything remotely close in the...

Hi Folks, I need to add some auditing to a clients database. The sp's to actually do the audit are no problem. However, I need to insert the calls to the audit procs into every stored proc in their database and there are over 300!!! In addition, I'll need to be able to remove the audit calls...

Here's a weird one. I've got an Excel workbook with macros. The macros seem to have stopped working. Not only that, but it appears to prevent them working in other workbooks once the problematic one has been opened too. The dodgy book opens and runs a macro to show the correct sheet. The user...

I know absolutely nothing about DNS. I have a VPS on which I host my website. I want to put a couple more sites up on the same box, but as my VPS can't use Plesk (issues with PDF creation components) I have to set it up manually. Now, I can do the website stuff, adn I was very helpfully helped...

I realise that the most common answer to this question is that I am using a constant without incluing the definition, but that isn't the case here. I also understand that it is likely to be a simple error that I can't see because I'm looking for something more complex, but here goes: Every page...

I have a client that uses Outlook and Lotus Notes 6.5.5. They have an application that generates emails with a link to a spreadsheet on a network drive. The guy that developed it, coding the email generation to work with an rtf document as the body of the email for the Notes users and an html...

OK. This has been bugging me for the best part of a day now. I have a report in SSRS 2005 that is grouped. So, referrals for an individual with events within the referrals. So my top level is my individual. Each can have multiple referrals and each referral can have multiple events. How the...

I have a series of reports and report models. I want my users to have access to the model specific to their department only. If they click the report builder button they have to select the model. By using a hyperlink to the report builder...

Does anyone know why a report created against a report model interprets data differently to a report created and published in BIDS? I have a report that's based on an sp. Although the tables are relational, the relational data isn't very big. For example I have a service provider and a related...

I have a report that has a hyperlink jump to another report. This works fine, but I want to jump to a different depending on the value of a field. The link is a referrals report. If there is a single referral then I want to jump to that specific referral, if there are more than one I want to...

I have a series of report models that I have built for my users. They work fine and allow the users to query the model happily. My question is about multiple rows. In BIDS I can write a report that runs across multiple rows. So when I need to add a notes column I can add it on a new row and...

Anyone know how to maintain my cookies after redirecting to an ssl page? I set my cookies, then when the customer goes to the payment page the cookies are removed. When the customer comes back they are no longer logged in. How do I get around it?

I have just moved my web hosting from a shared server to a vps. The database on the shared host was full sql. On my vps it's sql express. Should I be able to attach the mdf file in sql express as normal or are there some full sql specifics in the file? I didn't think there were, but I get a...

Hi Folks, We've developed a website that needs to be able to send regular mailings. Our complete mailing list is 1.4 million unique users and even though we're using a VPS the hosting company (understandably) don't want us to send mailings out to 1.4 million email addresses. The addresses are...

Hi Folks, I have a custom function that calculates based on a number of other columns. Some of the data is static (extracted from a database) others are the results of Excel functions. My function will not read the values from the cells that are the results of functions. It will return 0 (or...

I need to get a list of the IP addresses, and ideally the names, of all the machines on my network from asp. What I'm ultimately trying to do is play media on any machine, or group of machines, on the network. The media files will be stored centrally, but I want to be able to create 'zones' and...