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 SkipVought 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: *

  1. TheRogueWolf

    GPO not taking effect

    If you run 'gpresult' from a command prompt on one of the clients does it show the default domain policy applying to that machine?
  2. TheRogueWolf

    Installing Office 2010 via GPO

    I've been struggling with this for the last few days so I'm hoping someone here can help. I'm trying to install MS Office 2010 on user's machines using Group Policy. I have read all the MS literature and so far have the following: * A network install location (\\server\share\office2010) which...
  3. TheRogueWolf

    Installing Office 2010 via GPO

    My apologies, it is InstallOffice2010.bat that is not working via the GPO, not CacheOffice2010.bat.
  4. TheRogueWolf

    Installing Office 2010 via GPO

    Update: I have also tried changing CacheOffice2010.bat to use the network install point instead of the local cache; still no joy.
  5. TheRogueWolf

    Installing Office 2010 via GPO

    I've been struggling with this for the last few days so I'm hoping someone here can help. I'm trying to install MS Office 2010 on user's machines using Group Policy. I have read all the MS literature and so far have the following: * A network install location (\\server\share\office2010) which...
  6. TheRogueWolf

    Show sum of values from 1 table with data from 2 other tables

    That's done the trick, thanks again markros :)
  7. TheRogueWolf

    Show sum of values from 1 table with data from 2 other tables

    Thanks again for your invaluable help. I'll try that in the morning and let you know the result...
  8. TheRogueWolf

    Show sum of values from 1 table with data from 2 other tables

    Thanks Markros, sorry for the delay in my reply. It's unfortunate that although I thought that SupplierNum uniquely identified the supplier, this is not the case. The same SupplierNum is used by three different companies (I should mention that these companies are our internal...
  9. TheRogueWolf

    Show sum of values from 1 table with data from 2 other tables

    Back again I'm afraid. I seem to have a bit of a problem with the code Markros kindly provided. While at first glance it appears to be working correctly, a bit more investigation shows that:WHERE supplier.company = 'SF04' doesn't seem to be working as I expected. Specifically, there is a...
  10. TheRogueWolf

    Show sum of values from 1 table with data from 2 other tables

    Thanks markros, that did the trick perfectly. Thanks again Jamfool, unfortunately I couldn't get your version to work but that's no doubt due to my beginner's SQL skills.
  11. TheRogueWolf

    Show sum of values from 1 table with data from 2 other tables

    Would you be able to give me an example of how to do this please? This is a bit beyond my current SQL abilities :-)
  12. TheRogueWolf

    Show sum of values from 1 table with data from 2 other tables

    Sorry about this, I have one more question. I now need to select only orders which have been approved. This is indicated by a field in another table (orderheader.approvalstatus) which could be linked to the orderdetail table using the .ordernum field. Could you give me a bit more help on how...
  13. TheRogueWolf

    Show sum of values from 1 table with data from 2 other tables

    My apologies. I've just discovered that there are duplicate suppliernum entries in the suppliers table because different departments use the same suppliernum but for different suppliers (I hasten to add that I didn't design these tables) :-) I've added a WHERE clause to limit the results to a...
  14. TheRogueWolf

    Show sum of values from 1 table with data from 2 other tables

    Thanks Jamfool, that's a helpful resource. I've written the following code: SELECT supplier.suppliernum, supplier.supplierid AS 'ID', supplier.name AS 'Name', sum (orderdetail.orderqty * orderdetail.unitcost) AS Total FROM supplier LEFT JOIN orderdetail ON supplier.suppliernum =...
  15. TheRogueWolf

    Show sum of values from 1 table with data from 2 other tables

    Hi, I'm new to SQL queries but I think I've got the hang of the basics. I have a problem which I'm not sure how to proceed with, however, and I'm hoping someone can help. I have two tables: Supplier - suppliernum - name OrderDetail - suppliernum - orderqty - unitcost My aim is to get a...
  16. TheRogueWolf

    Vista Black Screen w/ Cursor

    I agree with goombawaho, hard-resetting the PC isn't a permanent solution and may actually lead to more problems if it is done repeatedly as the PC isn't going through the correct shutdown procedure. My machine now appears to be experiencing other problems. A reboot yesterday resulted in an...
  17. TheRogueWolf

    Vista Black Screen w/ Cursor

    Yes, it will no doubt turn out to be something obscure. I'm assuming that it can't be driver related as I would expect a safe mode boot to work if that was the case. I'm hoping that someone here might have encountered, and come up with a solution to, the same problem.
  18. TheRogueWolf

    Vista Black Screen w/ Cursor

    Sorry Goombawaho, I've just re-read the posts and noticed that you don't have the machine any more.
  19. TheRogueWolf

    Vista Black Screen w/ Cursor

    I have exactly the same problem and, as above, initially suspected a corrupt registry user profile. In fact, this is the second time this has happened and the last time I created a new user profile to resolve the problem (System Restore does not resolve the issue). However, I have since...
  20. TheRogueWolf

    External vs Internal Hard Drive Speed

    Thanks Nelviticus, I'm going to try the MyBook via firewire as soon as I get back home next week to see if bypassing the internal HDD has any effect. From what the posters above have been saying it doesn't sound likely but at this stage anything's worth a go. I've already got a 10m S-Video...

Part and Inventory Search

Back
Top