Search results for query: *

I have some PCs that are logged into the local PC. The PC is in the domain but users don't authenticate. These PCs are used for accessing one IP application and nothing else except to print. I can attach a printer via the print server and that works fine for a day or two. Eventually this...

I need a query that will find out how many patients were in the hospital at midnight of a given day or range of days. I have the admitDateTime and the DischargeDateTime. The format of the Admit and Discharges is '3/31/2008 12:00:00 AM'. I would like to use a parameter query and put either one...

I need to change the names of the two column headings for [Primary earning code]. There are only two possibilities: 1 and 2. I would like 1 to say FTE1 and 2 to say FTE2. This is needed to interface another DB for running reports. TRANSFORM Sum(Sheet1.TotalHours) AS SumOfTotalHours SELECT...

I am trying to add together all the hours for each job code for Two different pay types. Each employee has a job code and there can be more than one employee with the same job code. Each job code can have one or two pay types, for example 'regular hours - "Productive hours"', or 'Sick/Vacation -...

I have an ext (564), that will cover to another ext (525) if nobody picks it up. If nobody picks it up at 525, it should cover to 525's voice mail. This is not happening. If I call 525 directly, and nobody answers, it works fine. I am using a coverage path for 564 that redirects it to 525.

I am building a form that will be sent off in email. I have the CDO part figured out and I have but one field left to populate with the email names from our exchange server. I need to figure out the LDAP path to get the EMail names. Here is what I have so far that does work. I would like to be...

I need to move a bunch of home folders from one 2000 server to another. Is there an easy way to do this and keep the rights.

I have a query that will look at the PM table and see when the last PM was done, compare it with the PM recurance number, and if it is greater than the PM occurance number, the datediff will be set to yes and will then appear in the result. This is what I would like to do. If DateDiff is set...

Is there a way to fill a shape with a pattern that looks like wood grain? For example, lets say I make a square, I right click on the square, click format/fill and it would be great to have a wood grain pattern. Thanks Dale

What is the best way to handle events that are going to come up at sheduled times. For example I have a bunch of equipment that will need maintenance at different times throughout the year. An air handleing unit is going to have its filters swaped 3 times a year. When I entered this piece of...

I am haveing a problem with the below page. When I come from the first page "20AddNewME.asp" everything works fine. strQSMEID is set to the querstring value from the previous page. This value is used in the SQL to pull the correct RS and the fields are completed correctly. I am able to...

I can response.write the session variable on the first page where I declare it, but cant get it on the second page. Could somebody give me a clue as to what the problem could be? 'first page 24ProcAddEdit.asp Session("sv24MEID") = strMEID Response.Write Session("sv24MEID")...

I would like to build a query that would group all records by year/month and then average each month. For example the output of each row might look like this: "Jan 02, 55" then each row would show subsequent months.

I have a bunch of asp pages up and running. How can I create a new project that will include these pages so I can make changes on the fly. Or to state it differently: I would like to be able to work off line and when I get it right post it back to the place where the production copy is running...

When the following script runs while loging into a win 98 pc, the script hangs on the Do While loop. If I run this same script after loging in, it runs fine. This happens on the 98 pcs but not nt. It looks like 98 gets the username information after login. How do I get around this? 'Dim strUser...

I have a form that has all the information I need including EmployeeID but not the EmployeeName. How do I call information from other tables/forms/queries, using the employeeID as a key? I hope this is clear. Thanks

I need a query that will Grab the first name and middle initial, make it one field (I know how to do this part), and then check to see if there are duplicate values. For example if it found two John J entries, it would warn with a popup window. Thanks

I get this error when i try to run a query in an Access 97 database on a win 95 PC. "ODBC--Call Failed" I built the DB on a XP machine and it works fine on 98, 2000, and XP, but it fails when running the query on a win 95. It seems to only happen in queries with linked tables. Same...

I have a linked table that has dates given in data type "text" instead of data type "date". I have a query in which I need to sample the dates using the criteria "Between (Date()-8) And Date()". This works on data type date but not text. I get the error "data...

I would like to use a combo box to pick an employee name. When I select that name I would like the rest of the fields to reflect that employees information. Also I would like a subform to also show all events related to that employee. I can make this happen fine when I use a text box and use the...