Get answers.  Share knowledge.  Collaborate with peers.




Microsoft Excel 2003 / Auto complete a word

Is there a way, using Microsoft Excel 2003, to have the sheet auto complete a word after typing only the first few letters. What I would like to do is simply this: I want the user to enter the first letter of someone’s last name in a cell and have the choices from an established…



Answer Question   |  March 12, 2013  11:20 AM
Microsoft Excel 2003, Microsoft Excel commands
asked by:
11,390 pts.

PRG files

“.PRG Files are instruction files”. Can they call another file in to them? If yes,how?



Answer Question   |  March 12, 2013  11:01 AM
PRG, PRG files
asked by:
11,390 pts.

Lost my SQL log

SQL statements from a session (first session) have been lost because I opened a second SQL session and saved this when exiting AFTER exiting my first session. So, when I STRSQL, I only see the statements from my second session, those from the first session are gone. Can I somehow retrieve the statements from my…



Answer Question   |  March 12, 2013  9:23 AM
SQL Sessions, SQL statement
asked by:
11,390 pts.

Communication link failure. A time-out occurred trying to connect to the iSeries Setup

I have a Linux ODBC that pushes data to the AS/400. When I am trying to connect my ODBC Linux connection, it fails and logs the following error message: [rduser@ebsdbprod ~]$ isql -v misysdb erp0101 [08S01][unixODBC][IBM][iSeries Access ODBC Driver]Communication link failure. comm rc=10060 – CWBCO1048 – A time-out occurred trying to connect to the iSeries…



Answer Question   |  March 13, 2013  8:59 AM
AS/400, Linux, ODBC
asked by:
30 pts.

IP Geolocation

Using functions that is available on number of IP information websites to determine my location on number of Public WiFi. Is it possible to get different locations on different Browsers. If so what are the factors that may cause these differences. i.e Safari and Firefox.



Answer Question   |  March 12, 2013  12:51 AM
Internet Access and Security, Internet Browser, Internet connection
asked by:
55 pts.

‘Swirl’ cursor

My cursor is usually an arrow. Sometimes, by itself, it will change to a ‘swirl’ and then it drags the screen around when I try to move cursor. Eventually it will change back to arrow by itself again and work as it should. What is going on and how do I stop this from happening?…



Answer Question   |  March 12, 2013  10:00 PM
Cursor, Windows 7
asked by:
11,390 pts.

Migrate Gmail to Outlook

How can I migrate Outlook to Gmail?



Answer Question   |  March 12, 2013  9:28 PM
Gmail, Microsoft Outlook
asked by:
11,390 pts.

Access the control panel for a remote station on the local network

Dear team, Is it possible to remove the clock completely from a station connected to the local network remotely.



Answer Question   |  March 11, 2013  6:36 PM
Networking, Windows Taskbar
asked by:
11,390 pts.

Excel 7

I have a large spreadsheet with cell that contain  similar older catalog numbers. Want to update to the latest version of catalog number. Can I delete/ remove a character from the following Example:   23LB412  take out the “B” and keep the following: 23L412



Answer Question   |  March 11, 2013  6:26 PM
Microsoft Excel, Microsoft Excel spreadsheet
asked by:
11,390 pts.

Old analog system

My partner’s computer briefly says and shows an analog icon in upper left of screen upon opening. Having never encountered this before, I assume that it explains the retarded speed of all computer operations we experience. And that there is a digital preference that can be instead utilized. Is there a free “upgrade” or any…



Answer Question   |  March 11, 2013  5:54 PM
ACPI Uniprocessor, Windows XP
asked by:
11,390 pts.

Outlook shared calendar – can’t edit/create events because of boss’s mailbox is full

I am a delegate on my boss’s calendar. He has a million (literally) emails in his mailbox. He has problems receiving invites because his mailbox is too full. Now I am having issues creating events and modifying current ones. I get a popup message telling me that I can’t modify the event and I’m having…



Answer Question   |  March 21, 2013  5:44 PM
Microsoft Outlook, Microsoft Outlook Calendar
asked by:
75 pts.

Import MS Word document to Window’s Journal .jnt file from within Word VBA

Windows Journal can import a MS Word file. It imports as an image that can then be written on top of with ink. Does anyone know if I can import the Word document into Windows Journal automatically from VBA code in the Word document? Or is there a way to create the .jnt file in…



Answer Question   |  March 11, 2013  3:19 PM
Microsoft Word, VBA
asked by:
11,390 pts.

How can I view a rule that I did not create?

When I select view rules, I get message that “rules on this computer do not match rules on Microsoft Exchange.” How do I find out what those rules are?



Answer Question   |  March 11, 2013  2:07 PM
Microsoft Exchange, Microsoft Exchange Rules
asked by:
11,390 pts.

How to copy VM’s from physical server to another

Hello,New to VM, could someone outline how to copy VM’s on an ESXi 4.1 server to a new server with ESXi 5.1 ?The VM’s are domain controllers. Thanks for any advice.  



Answer Question   |  March 11, 2013  1:44 PM
ESXi
asked by:
5 pts.

Crystal Reports XI – Finding records that need to have appointments rescheduled

Hi, I have the following fields to work with: ID #, issue #, meeting #, prior meeting dates, and status. I keep isolating the old records that have already been rescheduled along with the ones that need to be rescheduled. Any ideas would be appreciated. Thanks! Babeas



Answer Question   |  March 11, 2013  12:31 PM
Crystal Reports Record, Crystal Reports XI
asked by:
11,390 pts.

When users login in domain there is a problem of showing message of account is locked

Actually I have a problem with my server 2008, when a user logs into the system, there is give message of: account is locked please contact administrator. Please revert whats the cause of this problem and solutions Thanks and regards, rajendra sonavane



Answer Question   |  March 11, 2013  12:13 PM
Active Directory, Active Directory 2008
asked by:
108,055 pts.

CPU socket type

Q9650 E6800 Pentium D 945 17-2600 15-2500 13-2300 17-860S 17-980 13-540 Phenom II X4   980 Athlon II X4 A4-3-3400 Llano



Answer Question   |  March 11, 2013  5:20 PM
CPU, CPU usage
asked by:
11,390 pts.

WRKQRY Call LOADITMCL

When I run a WRKQRY for ITEMSQRY after I’m done query completes fine. I use Call LOADITMCL to load the WRKQRY but when I run call LOADITMCL application error. cee9901 unmonitored by LOADITMCL at statement 0000000600, instruction x’000. This does work in our production side but in test it doesn’t. I need it to be…



Answer Question   |  March 11, 2013  3:25 PM
AS/400, WRKQRY
asked by:
11,390 pts.

My Unix command

I got a problem with my Unix script as below. Error Message: cannot open: No such file or directory mv: cannot access My scripts as below. Anyone have any idea? Pls help~~ file ${epmhome}/receive/${datfile}.err set stat=${status} if (${stat} != 0) then echo “No Error File Found at Receive” else mv ${epmhome}/receive/${datfile}.err ${epmhome}/error/${getfile}.err echo “Error File…



Answer Question   |  March 11, 2013  2:49 PM
Unix, Unix administration
asked by:
25 pts.

Stop Oracle database using by other application

I have Oracle 9i database & want to stop other people from using it and use other applications like SQL Developer & Toad.



Answer Question   |  March 11, 2013  9:37 AM
Oracle 9i, Oracle 9i database
asked by:
11,390 pts.