Search results for query: *

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

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

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

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

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

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

Hi All, I have a database that lists incidents. I need to create a report that allows the user to specify a date range, and a location. I would like to use a dialog box for the selections, but can't figure out how to code it to pass the date range and choice from the combo box. Any help...

I have macro buttons on a worksheet. When I print or "print-preview" these buttons move accross the page. I am using Excel 2002 in Windows XP. This problem also happens on another computer with the same configuration. This problem did not occur when I sent the worksheet to someone who uses...

Hello, I received a free copy of Office Pro 2003 plus OneNote 2003 from MS some while ago. It's completely legit. I had it on my old laptop. I got a new laptop, but I can't find the package with the original cd and key. I can't find any number to call MS that isn't a tech support line...

Hello, I need to restrict access TO the Internet for individual users. What commands do I put in the ACL to block an individual IP from getting to the net, but allow them access to local network resources? Thanks!! -Jeff

Hello, Is is possible through VB code to take a date entered in a cell in an Excel sheet, and create an entry in the Outlook calendar, with a reminder alarm? Thanks, -Jeff

Hello, We would like to set up an event in Outlook that repeats with a non-linear pattern, ie: 5,14,30,60,90 days. Is this possible and if so, how? Thanks, -Jeff

Good Morning, I wrote the (not elegant) code below to make sure the correct data was entered or not entered in cells based on other cells. I used vba because we could only go so far with data validation and the Indirect function. There are two problems. First, the code is slow, probably...

Hello, We have a spreadsheet for the daily census of our nursing home. For each category, Admission, Discharge, Death, etc. we use data validation to produce drop down lists for unit name, etc to prevent incorrect data entry. What we need is a way to prevent entry (or selection from a drop...

I have a 1721 with the T1 card. It connects out network to the Internet. Lately we seem to be getting lots of authentication requests on the W2K server from outside of our domain. What changes to the router config can I make to block these attempts? I've got 12.2(3)T with the firewall and...

Hello, I have a db tracking Notifications. Each record is created using a form, which has two buttons, Send and Print. The problem is, if I open the form in Add mode to add a new notification record, and do NOT print it, using the Print button, before clicking the Send button, the resulting...

Hello... We print employee accrued time off from a 123 sheet. It's three lines of text, plus a header and footer. Right now that prints one pager per employee, thus wasting two thirds of the sheet. Is it possible to make it print three per page? We've tried changing margins, paper size...

I have a data entry form where Employee details are entered, such as name, and Department. Department is selected from a combo box which gets its row source from a table of departments. The combo box displays the name rather than the ID number. There is also a form which displays the...