Excel Macro Help – .ThemeColor = xlThemeColorDark1
Instead of a Macro you can perform in these steps in Excel 2007. 1) Click on cell A1 2) While holding Shift & Control down, click on End button. (The idea is to select the entire worksheet). 3) Now on Home Tab Click Conditional Formatting 4) On Highlight Cell Rules … .select Equal To 5) [...]

View Answer   |  March 13, 2009  7:09 AM
Excel 2007, Excel macros, Microsoft Excel

Connection failure using dotnet 1.0 and Oracle client 10g with Oracle 10g server
Has this worked before ? did you make any changes ? Could you please post the exact error message ? Also, could you please post the code you are using to connect to the database ? Hi, Is working with only one machine. We have installed vs2003, Oracle.net, mdac 2.6 and oracle client 10g on [...]

View Answer   |  March 13, 2009  5:37 AM
.NET 1.0, .NET 2003, ODBC, Oracle 10g, Windows XP

Subject: Limiting information in combobox
You need to use the Forms collection to reference the filter value. Your RowSource where clause will look something like this: where CLientName = [Forms]![OrderEntryForm]![Customer]

View Answer   |  March 12, 2009  8:44 PM
Access 2007, ComboBox, Microsoft Access, Microsoft Access ComboBox

Comparing data in Visual Basic .NET
So, what are you asking? Do you want someone to write the code for you?

View Answer   |  March 12, 2009  5:38 PM
ListBox, VB.NET, Visual Basic, Visual Basic .NET

How to take Incremental Backup programmatically using C#
I’m new with C# so am facing the same problem you are. I’m starting here so I figured I’d let you know where ‘here’ is. Goodluck. http://msdn.microsoft.com/en-us/library/cc148994.aspx

View Answer   |  March 12, 2009  4:37 PM
.NET, .NET development, C, Code example, Incremental backup

Proper log out in ASP.NET
Your question was not specific, but if you check <a href=”http://social.msdn.microsoft.com/Search/en-US/?query=signout.aspx&ac=3″>here</a> you might find something useful. Good Luck! -Flame

View Answer   |  March 12, 2009  3:49 PM
ASP.NET, ASP.NET authentication, ASP.NET membership

Need advice on a career in IT?
Certifications such as the <a href=”http://www.comptia.org/”>Comptia</a> will both help you get in the door at many places, and by virtue of the material you need to learn to get the cert, give you a nice skill set for an entry level job. The Non-IT courses (Such as your history and composition classes) will help with [...]

View Answer   |  March 12, 2009  2:24 PM
a, CCNA, Cisco Certified Network Associate, IT careers, IT education, Java, MCSE, Network, Security

Excel 2003 docs now won’t open in Excel 2007
Is this the error you are getting? This file is not in a recognizable format. If you know the file is from another program which is incompatible with Microsoft Office EXCEL, click Cancel, then open this file in its original application. If you want to open the file later in Microsoft Office Excel, save it [...]

View Answer   |  March 12, 2009  1:27 PM
Excel 2003, Excel 2007, Legacy applications, Microsoft Excel import/export

Code complexity?
Code Complexity is a measure that provides a single ordinal number which can be compared to the complexity of other programs. It is one of the most widely accepted static software metrics and is intended to be independent of language and language format.

View Answer   |  March 12, 2009  1:24 PM
Code Complexity, Coding, Development, Open source software

How to combine variables
Hi, Can you give us some more information please. What software/database/programming language are you using for this? Regards, Martin Gilbert. My apologies…I am working with SPSS 17.0 and the GSS data set. I am trying to figure out how to merge the info from the variables mostimp1, mostimp2, mostimp3, and mostimp4 to use as one [...]

View Answer   |  March 12, 2009  10:56 AM
Data analysis, Datasets, Variables

Get the following error when logging into SQLPlus – ORA-01034: Oracle not available ORA-27101: shared memory realm does not exist
I guess you are using ‘Express Edition’. Please provide a little more information. Are you trying to connect from a remote client, or locally ? Were you able to connect from SQL*Plus before, or you have never been able to connect ? Have you made changes to some database parameter (such as SGA size) ? [...]

View Answer   |  March 12, 2009  6:10 AM
Error Message ORA 01034, Error Message ORA 27101, Error ORA-12514, ORA-01034, ORA-27101, Oracle 10g, Oracle error messages, SQLPlus, Visual Studio 2005

Create XML with RPG IV
Look at http://www.scottklement.com/expat/ or if you are open to a commercial application, you can check out http://www.rpg-xml.com/?WR=RSKTINC_mowyourlawn.com

View Answer   |  March 11, 2009  6:27 PM
Create XML with RPG IV, RPG IV, XML

Custom alert messages with SQL
More information is needed here. What programming language are you using ? what database ?

View Answer   |  March 11, 2009  2:12 PM
SQL custom message, SQL development

Need Help With Multiple Conditions and Constraints for Access 2007 VBA Event
From a design point of view, i would do it like this: Students requests are held in a table with student_id, choice_no, choice_value, assigned Workshops are held in table with workshop, section, capacity workshop_assignees are held in table workshop, section, student_id then have your procedure sub process_requests for each student not assigned fetch student_id, choice_no, [...]

View Answer   |  March 11, 2009  2:09 PM
Access 2007, Microsoft Access, VBA, Visual Basic, Visual Basic for Applications

How to store Form values in Oracle 10g with VB.NET
Have a look at the following Oracle article for the basics on connecting to the database from .NET It shows how to connect to the database and retrieve records using SELECT statements. To perform inserts and updates you just need to change de command text with the appropriate SQL command, and execute it as non [...]

View Answer   |  March 11, 2009  2:00 PM
Database programming, Oracle 10g, VB.NET 2005, Visual Basic .NET

Can you find out the name of the job calling a REXX program?
That’s difficult to do. You can use the REXX <i>userid </i>function if you’re running under an interactive TSO/E session, but falls down if you call your REXX in batch. The only way I can think of is to use the REXX STORAGE function to hop through z/OS Control Blocks. Here’s some code that will do [...]

View Answer   |  March 11, 2009  12:51 PM
IKJEFT01, MVSVAR, REXX, TSO

ASP
Hi, You can probably start by saving and deleting journal receivers. Deleting old spooled files – you can also try a RCLSPLSTG to reclaim spool storage. Save and clear the QRPLOBJ library. Save and delete QSYS/QHST* files. This should help you get started. Regards, Martin Gilbert. ///////////////////////// Look for 1. database files in developer libraries [...]

View Answer   |  March 10, 2009  6:26 PM
AS/400 ASP, AS/400 performance, ASP

IFS Save/Restore date
Check out the Qp0lGetAttr API at: http://publib.boulder.ibm.com/infocenter/iseries/v5r4/topic/apis/qgetattr.htm Here is the link to some example code: http://www.think400.dk/apier_7.htm#eks0006

View Answer   |  March 10, 2009  3:41 PM
API, IFS, IFS Commands

what is code of c/c++/java for search a file on local pc .program run on WINDOWSplateform
I can’t give you a complete solution, but hopefully this could point you in the right direction. We did something similar once, but our app did not search in the complete file system, but only in the current directory. The functions we needed to use were: _chdir _findfirst _findnext _findclose Here’s some example code (from [...]

View Answer   |  March 9, 2009  11:58 PM
C, Development, Java

What is the maximum size of an Integer Array?
Size of an integer array is depand upon how much memory is free in main memory on run or compile time.

View Answer   |  March 9, 2009  8:24 PM
Arrays, Integer Array, Software development