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...
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...
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...
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'...
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:=...
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...
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...
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...
If its possible, what is the command line syntax for sending an email message from DOS? We run an Outlook 2000 server for email. What I am trying to do is setup a batch like:
IF NOT ERRORLEVEL 0 'Email dl-Administrator'
Any assistance is appreciated.
Thanks,
Richard
Where can I find or purchase an IBM DB2 ODBC Driver? I have created a Microsoft SQL Server DTS package to retrieve data from a small DB2 database table into a SQL Server table.
We have installed one copy of an IBM DB2 DBMS and when done it installs your ODBC and configurator. Rather than...
I am using a program that works with our Canon Imagerunner 3300. The program I am using is called Nettools Scangear 1.3. When I go to enter the IP address of the printer, 10.2.10.54, I get a message saying "IP address outside the subnet cannot be specified". Yet, I can ping that IP from the...
Is there an ODBC or other way to SQL into the Micros 9700 HMS? I would like to extract information or even update if possible via SQL. All the adds for Micros say its SQL compliant but have found very little info on this subject.
Thanks,
Richard
Many companies sell an HP4300 MICR printers for around $3000 plus. I am wondering if this is just an HP4300 with a MICR toner or is there more to it than that?
Please help.
Richard
I am trying to import a table from our accounting system into Access 2000. I do this everyday from the same data file in our accounting system for reporting purpose.
Today I tried it, as my daily routine, and am getting an "Invalid Arguement" while in the importing process. Any...
I have a macro in Access, say macro1, that copies data and sends it to an Excel file. I have a second macro, say macro2, that runs macro1 repeadily. What command do I use to have macro2 run macro1 every 15 minutes?
I need a good reference book on DDE to send data from an application to an MS Access 2000 database. I am working with MAS200 accounting system and it has a script tool to write a DDE script to send info to a MS Office application (ie Word, Excel, Access). Any suggestions?
Anyone know of a good reference book on DDE script? I am creating a script in Customizer to send data from a data entry form to MS Access 2000. Thanks........
Can someone tell me why I cannot run a total on the following formula:
stringvar PUNCHIN:={TC1_TimecardMastefile.TimePunchedIn};
stringvar PUNCHOUT:={TC1_TimecardMastefile.TimePunchedOut};
IF GroupName ({@SHIFT})="7AM TO 3PM" AND PUNCHOUT > "15.00" THEN VAL(PUNCHIN) -...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.