Recent content by JJSRich

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

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

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

Well, Head Office has copied the needed ISOs on to our first DC overnight over the WAN. Problem solved.

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.

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

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

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.

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

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.

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

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]

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

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.