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...
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...
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...
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...
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.
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...
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...
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 =...
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...
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...
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.
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.