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 dencom 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: JJSRich
  • Content: Threads
  • Order by date
  1. JJSRich

    Outlook signature scripting problems in a mixed environment

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

    Genius idea backfiring - hyper-V guest install

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

    install cd sets

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

    batch setting out of office replies

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

    sum in grouping not working as I need it to

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

    Developing in Access 2007, deploying on 2003

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

    Aggregate function frustrations

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

    Exchange 2007 backups against user error (Maybe SonicWALL CDP?)

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

    Searching for categorized mail with follow up flag

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

    Migrating user from lotus Organiser to Outlook, he ait happy

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

    Express MySQL nested if's in Access

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

    Summing up too much data

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

    RDP and Windows Mobile (backwards)

    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?
  14. JJSRich

    Win32 C creating a second window in an app (right place?)

    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) {...
  15. JJSRich

    Outlook 2k3 added text in forwarded email disappears

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

    New to server 2k3, DFS confuses me

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

    Corrupted registry - missing entries

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

    creating dynamic rowsource query

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

    improperly constructed join for sum()

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

    How do I express this MySQL in Access?

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

Part and Inventory Search

Back
Top