Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: timfoster
  • Content: Threads
  • Order by date
  1. timfoster

    Outlook UserProperties not readable

    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...
  2. timfoster

    Login script and cloud storage mappings

    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...
  3. timfoster

    I've confused myself with some dynamic sql. HELP!!!!

    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...
  4. timfoster

    Where do the SQL create scripts come from?

    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...
  5. timfoster

    How do I find out the create date of a table?

    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...
  6. timfoster

    Change every SP with a script

    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...
  7. timfoster

    Excel Code Stops Running After a File is Opened

    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...
  8. timfoster

    Why do I get an authentication dialog?

    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...
  9. timfoster

    Why are my Command ActiveConnection Lines failing??

    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...
  10. timfoster

    Links to Excel Documents

    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...
  11. timfoster

    How Do I Count Groups in SSRS 2005?

    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...
  12. timfoster

    How do I add a hyperlink into the report hierarchy?

    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...
  13. timfoster

    Reports v Report Model

    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...
  14. timfoster

    Jumping to different reports

    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...
  15. timfoster

    Report Builder and Multiple Rows of Data per Record

    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...
  16. timfoster

    ASP, Cookies and SSL

    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?
  17. timfoster

    Can I restore a full sql mdf to a sql express server?

    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...
  18. timfoster

    CDO and Lots of Emails

    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...
  19. timfoster

    Excel Function Won't Use Formula Results

    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...
  20. timfoster

    Can I get a list of machine IP's on the network?

    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...

Part and Inventory Search

Back
Top