I am using the tutorial from
http://technet.microsoft.com/en-gb/magazine/2006.10.heyscriptingguy.aspx
I know it's from 2006, but it seems to hold the relevant information, and works for my people on Office 2007 and 2010, XP, Vista, and 7. However, it does not work for people on Office 2003. I...
A developer here suggested that I set up his machine with the freely available hyperV, and then allow him to use a virtualised Windows7 for development, spinning up a VM of any other OS he needs to test.
So, we get his new PC, top of the line, install Hyper-V on it, command line only stuff...
We've built our infrastructure off of Server 2003 R1. Yeah yeah, time for an upgrade. My office had just recieved a new server to put in place as another DC, as we only have one on-site.
Shortly after arriving, one of the drives started giving off predictive failure warnings, got a...
With Christmas coming up, and us being given a generous 2 weeks off (Saving money). Is it possible to set everyone's out of office in one operation, or will I have to manually go through each one to do it? Users are less than cooperative, and it's just easier this way, if possible.
I have a report, that comes from a SQL query, one of those monsters that is about 30 fields wide. I have 5 levels of grouping,
Company Rep
Company
Subcontractor
Site
House
Designer
The house has a number of hours that it should take, and how long it actually did take. Typically there is only...
I've been recently upgraded to a PC with Office 2k7 on it, and am still responsible for maintaining the Access database. We've had some bother with my latest update. Basically I've needed to remove the references to the Excel 12.0 Object Library, and add in the reference to the 11.0 library on...
I have used this line elsewhere, made a change to how we track the value
IIf([q].[value]=0,Sum([h].[built]*[h].[value]),[q].[value])
I have a query that grabbs address details, orders, values, etc, grouping by the address. When trying to use the above expression, instead of just value...
We've got a backup system in place that can restore the Exchange server as it existed the night before to bare iron. What we don't have, and what the General Manager is asking for, is basically, he deletes a bunch of his email and calendar items by mistake, I go back into the backup and through...
We are modifying the workflow here, so that when an email with an attached design comes in to a global account, it gets categorized with an assigned designer and flagged for follow-up. The follow up flag gets cleared when the design is complete and sent back.
What I want to do is to create a...
Our division is slowly moving to an Exchange server, sort-of centrally managed by Group IT sort of under my own recognisance. So far, the transition is going smooth, except for the General Manager of our Division. He's been using Lotus Organiser in various versions since 1994.
Within it's...
Here's a query, written ion MySQL that I need to use in a subreport. Because it's a pass-through, I can't use it as a subreport, so I need to re-write it in Access's language. I am dynamically generating the query, so I am posting the VBA I use. I have highlighted the section giving me the...
I've got a complex query (54 lines of pass-through to MySQL, Access died on this query) that among a bunch of other information returns:
contract #, employee, job #, hours assigned to job#, hours worked on job #
note: a contract consists of multiple job #'s
It works fine most of the time...
Now, I know it's possible to RDP in to a 2k/xp/vista computer from Windows Mobile. I want to go the other direction, remotely connect and administer a Windows Mobile 6 device. Would save me trapsing around. Is this even possible? If so, how?
This may be the wrong forum for this, if it is, point me in the right direction.
Here is a section of code that is giving me hassle.
extern HINSTANCE hInst; // This instance
extern HWND hWndMain; // Handle to Drawing window
BOOL MyFunc(void)
{...
I've got a user here, Office 2k3, email via POP, who hs a complaint. When he forwards an email, and adds text to it, the text does not always appear in the preview pane when viewing his Sent Items. When he attempts to re-forward the email, his added text is intact.
I have tried standard...
I am trying to set up Roaming Profiles, and some of our users have absolutely huge profiles, so I was looking to DFS as recommended here : http://www.windowsnetworking.com/articles_tutorials/Profile-Folder-Redirection-Windows-Server-2003.html to store redirected folders and user profiles. I...
We have a machine here that is very slow to start up, slow to run, basically a poor performer for the spec. I've left it alone for the past 6 months, but had to make changes to the system to move it from our old domain to our new one. When making some Registry changes it was found to be...
I am trying to build up filter to grab one piece of information (quote_id) and use that to populate a combobox. There are a few fields that can be used, Distributor, Builder, First line of address (haven't got to yet). I use a tickbox next to each field to selectively enable/disable portions...
I have written the following to tell me how much a particular quote_id is worth, given a set of circumstances. I don't know if my nested ifs would be better written as a case, but that may or may not solve the problems I am facing. The hoursworked table tracks when, and how long people worked...
I am using the following query to get a list of items to bill, put into a multiselect listbox where each item can be selected and billed.
SELECT
q.quote_id AS [SE Ref]
, q.date_rtn_final AS [Date Returned]
, q.add1 AS [Address Line 1]
, IIf(IsNull(c2.company),q.distributor,c2.company) AS...
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.