Search results for query: *

That's it exactly. No agent for the SQL server in Backup Exec. Makes sense now. Time to buy the Agent. Thanks!!

Hello, I've recently started at a new company, and have inherited a SQL server. It is a Windows Server 2003 box with SQL Server 2005 installed. The entire server is backed up to tape using Backup Exec, with full backups done daily. There are also jobs set up in SQL Server to perform...

Hi all, I've inherited an application that is used to change (sync) passwords on four different Windows servers (one 2003, others 2000). There is NO domain. The app reads the current users name, prompts for old and new password, then connects to the remote server and uses the...

Hello, I don't know much about Progress, except that its the db behind the application we use. We want to connect Crystal to generate reports. I've got the merant odbc driver, the right ports/service names, etc, but I get an error when I try to connect: Exceeding permissable number of...

darn, should have searched... worse yet, I'd used this before and forgotten it. Thanks to both for showing the error of my ways. My brain cramp continues however... Now I need to look at the two selections and determine a rate. Hmmm... search for dependent cell...

Hello, I've got a workbook that is tracking Room rates. There are 8 Wings in the building. Four have one set of Room Types, the other four have a different set. Each Room Type has a particular Room Rate. What I'd like is a dropdown with all the Wings. (I know how to do that). Then I'd like...

The icon doesn't appear under Administrative Tools. Very strange. My email name is "jeff" and my domain is @somersmanor.com. I really appreciate your emailing it. Thanks!! -Jeff

I do have the CD... I looked in the i386 folder, but there was no file named dhcpmgmt.ms_ there... Then I searched the whole CD for dhcp*.* and there were files, but nothing either ex_ or ms_. That's really strange isn't it? It's a real OEM Win2k Server CD.

I haven't needed to look at my Windows 2000 server's DHCP conosle in months, and today when I went looking for it, it's gone. It also doesn't appear in the Computer Management utility. Yet it's obviously still 'running' as addresses are being doled out. I've searched for dhcp*.* and get all...

Glenn's formula as copied gave an error. This worked: =((COUNTIF(E5:E55,">0"))-(COUNTIF(E5:E55,">0:05"))) Thanks!! -Jeff

Thank you Glenn! With a few extra ()'s that did work. Is there no way to do it with a single countif? -Jeff

I've got a spreadsheet for call bell response times. There's a column for time the bell was pulled, time answered, and a column that has the calculated difference. I used a countif to count all the calls that were responded to in more than five minutes. That was no problem...

Interesting... It takes the query, allows it to save, and will even run, though it doesn't generate the correct results. Then when I go back to design view, it's changed the ('s to [', and then won't re-save because it says incorrect bracketing. I feel we're getting closer...

Sorry for leaving out info... tblEmployees empID lastname firstname ... tblClasses classID className ClassDate ... tblClassesTaken classesTakenID empID classID tblClasses and tblEmployees have one-to-many relationships with tblClassesTaken. I tried the code, and got a...

Hello, I have a database that tracks courses taken by employees. I have tblEmployees, tblClasses, and tblClassesTaken holding who took what. I now need a report that lists who has NOT taken a given course. I already have a qry/report to show who has taken a particular course, but I can't...

oops, I thought it was shorthand... I copied as originally written, and received same results. 2 Data Type Mismatch errors, and #Name? in every field. Just FYI... Access 2002 SP3 on WinXP SP2

Okay, I put that in, replacing C, D, and T with tblClasses, tblDetails, and tblClassesTaken respectively. When I run the query, I get two Data Type Mismatch errors, then the result window opens, with one row of ?Name in every field. Getting closer! -Jeff

Here's what I get from the SQL view: SELECT tblDetails.Grade, tblDetails.LastName, tblDetails.FirstName, tblClasses.ClassDuration, tblClasses.ClassName, tblClasses.ClassDate, tblDetails.AnnivDate FROM tblDetails INNER JOIN (tblClasses INNER JOIN tblClassesTaken ON tblClasses.ClassID =...

Thanks PHV, I put that expression in the criteria, but when I run the query, it gives me an error "Data Type Mismatch in Criteria Expression" I checked and the fields are both dates, formatted as short date. Any ideas where else to look? Thanks! -Jeff

Hi All, I have a db that tracks employee education. In the Employees table, I have a HireDate field. The Classes table hold all the classes. The ClassesTaken table links the two keeping track of who took what and when. What I need is a way to figure the anniversary date in the current...