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!

Register Log in
  • Congratulations derfloh 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. 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

    Well, it looks like what he wants to do isn't going to work so well. Can't get clearance to purchase a Server 2008 license, and can't get clearance for another PC that could run the remote management tools or to RDP in. In addition, Windows 7 is refusing to boot from a VHD. I guess that's...
  3. 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...
  4. JJSRich

    install cd sets

    Well, Head Office has copied the needed ISOs on to our first DC overnight over the WAN. Problem solved.
  5. 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...
  6. 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.
  7. JJSRich

    sum in grouping not working as I need it to

    Not any more I don't think. It's still not working correctly, but the main question has been taken care of.
  8. JJSRich

    sum in grouping not working as I need it to

    Umm. sorry, really rusty, it's been over a year since I touched this application. I basically do this Set q = DBEngine(0)(0).QueryDefs("WeeklyReport") sqlstr = "SELECT" sqlstr = sqlstr & " q.quote_id" ... 30 rows of data, joins, limits, etc ... q.sql = sqlstr q.Close stDocName =...
  9. JJSRich

    sum in grouping not working as I need it to

    That sounds like a good idea, but I didn't think I could join in a query like that, given I am using a pass-through query. I'm exploring other avenues as well.
  10. JJSRich

    sum in grouping not working as I need it to

    Report, sorry. Just getting a bit flustered with the limitations of Access as a frontend. At least it's not where I keep the data. I am scrapping the idea of summing up anything and just running a subquery to get the data for each site, as that is what we are most concerned with. Basically...
  11. JJSRich

    sum in grouping not working as I need it to

    That's what I already have in place, and it doesn't work, as an assigned hours is generated for each house on a site. I tried breaking it out, and putting the sum in the footer, and the double counting just happens earlier on the form.
  12. 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...
  13. JJSRich

    Developing in Access 2007, deploying on 2003

    Goodie. I get to develop into Office 2000 then, as we've got a few installs of that kicking around... not that they need to use the database now. If it becomes any more of a hassle, I swear I'm going to re-write it all in C# or PHP, like I wanted to do 2 years ago. [2thumbsup]
  14. JJSRich

    Developing in Access 2007, deploying on 2003

    We don't distribute this app, it's in-house only.
  15. JJSRich

    Developing in Access 2007, deploying on 2003

    I thought there would be no easy way, Office is Microsoft's gravy train, after all. I will look in to the late binding, and see if it is applicable, and works.
  16. JJSRich

    Developing in Access 2007, deploying on 2003

    That doesn't carry the components with it. I know all about the whole Office 2007 file format debacle, and it really is a pain in the neck.
  17. 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...
  18. JJSRich

    Aggregate function frustrations

    o.. k. I found a deeper problem and a workaround. There's a flaw in the ODBC 3.51 connector I was using. Working around that, (using the 5.1 connector) and creating views has fixed the above issue. Thanks anyhow.
  19. 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...
  20. JJSRich

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

    As I said in my previous post, in more words, I have no clue what I am doing. LOL I need a good training course or book on Exchange administration... that's what I need. Deleted item retention, recovery storage group, all these things, they do not make sense to me. I was hired as an IT...

Part and Inventory Search

Back
Top