Search results for query: *

Agreed. I have proceeded with disposal. Thanks.

I have an old Best Fortress UPS. When I plug the unit into the electical outlet, the digital display and sensor lights blink repeatedly for roughly 30 seconds then it shuts off. There is nothing legible on the display. It starts with all 0's then every pixel illuminates. I left it plugged in...

Thanks bborissov, yours looks more strait forward than mine.

My appologies..after I posted this message it came to me: SELECT A.* FROM PS_JOB A WHERE A.EMPLID = '123' AND A.EFFDT = (SELECT MAX(B.EFFDT) FROM PS_JOB B WHERE B.EMPLID = A.EMPLID AND B.EFFDT <> (SELECT MAX(C.EFFDT) FROM PS_JOB C WHERE C.EMPLID = A.EMPLID))

Heres the scenario...I have a table with effective dated records. This means employee 123 can have multiple records all identified by a date. Example: employee 123 gets a pay raise on 01-29-2006. Employee 123 then gets another raise 08-30-2006. Later employee 123 gets yet another raise...

Thanks, I will try using that.

Unfortuneately in this situation, moving or resizing itsn't an option due to users' requirements.

I have detail data that I have drawn a box around. I have set my watermark on Page Header B with "Underlay Following Sections" checked in Page Header B. I made sure the graphics are set to background not forground. When I run my report the watermark functions correctly except for the lines...

Thanks lbass. Both sound like good ideas. I did not think of it before. That has given me some ideas. Thanks again. Richard

Sorry that is about as descriptive as I can get it.

Ok, I have a record. Each record has 8 attributes that are either true or false. A record can have multiple attributes that are true. So, how do I group by the true attributes and have a record print multiple times...once under each attribute grouping? This is what I have so far: SELECT 'Y'...

Got it figured out: numbervar firstday:= 01; numbervar firstmonth:= 01; numbervar currentyear:= year(CurrentDate); datevar begofyear:= CDate(currentyear,firstmonth,firstday); numbervar Age:= DateDiff("YYYY",{PS_PERSON.BIRTHDATE} , begofyear);

I am trying to figure out how to do a datediff calculation using a persons birthdate and first day of the year. I do not want to hardcode 01/01/2006. If I hardcoded I would have to update the report formula every year. This is what I have so far: numbervar Age:=...

Thanks Tom, that did it. Richard

I am creating a document in MS Word 2000. I would like the page numbering to begin with 1 on the 4th page. The pages prior to the 4th page are just front matter. I would like the front matter to be numbered using Roman numerals. So the 1st thru 3rd pages would be I, II, III and the 4th page...

Thanks. I check but no triggers. I decided to try inserting a batch at a time and that worked so far. Still confused. Its making me look bad. I cannot see any duplicates. Could it be the number of records I am inserting? I will continue inserting in batches. Thank you for your time. Richard

I am inserting records from a temp table (PS_PROJ_RES_TMP) to a main table (PS_PROJ_RESOURCE) in MS SQL Server 2000. I am consistantly getting the message: The insert failed: Server: Msg 2601, Level 14, State 3, Line 1 Cannot insert duplicate key row in object 'PS_PROJ_RESOURCE' with unique...

I have an existing table with records. A new field was added through a table alter. This field is a new id field to uniquely identify records. Someone previously had created this table but used a couple of text fields for keys. I added a numberic field where all the values in it currently...

Thanks Pampers for the response. In your instructions are you refering to the Employee ID or the Employee Name at the beginning of your first paragraph or a completely new box? Thanks, Richard

I have a Microsoft Access 2000 database and form. The form writes to a Transaction table. The form has a drop down list that pulls an employee number from an Employee table. I have a field for employee name I would like to populate based on the employee number. Here is what I am trying to...