SAP advice
I did MBA in International businenss, May i also go for SAP course

Answer Question   |  September 15, 2010  10:14 AM
IT careers, SAP careers, SAP certifications

What to do after CCNP
I have done CCNA certification and got training in CCNP.. I am confused whether to do CCNP certification or To get training in CCSP and to write CCSP certification.. Can u please suggest in which way i have to proceed to find job easily whether…Presently i am working with CCNA for last 2 years.

Answer Question   |  February 10, 2011  8:30 AM
CCNA, CCNA Certification, CCNP, IT career development, IT career planning, IT careers

How to use the data from other table into the main table in Access 2003 and 2007
I’m trying to use data from other tables to make a sum and then display the result in a “Total” text. For example: I have in table1 3 qty’s, in table2 2 qty’s and in table3 5 qty’s. I want to sum all those qty’s and display them into the Main Form. I use MS [...]

Answer Question   |  August 19, 2010  4:02 AM
Access 2003, Access 2003 forms, Access 2007, Access 2007 form creation, Access Forms Database

updating, deleting in access with asp.net using Visual basic
hi, i m using  asp.net 2005 usin vb. i m having gridcontrol with the back end of msaccess.  i know to retrive the data from databse by using tis code, Dim msaccessconnect, query, databasecommunication, readdatabase         msaccessconnect = New OleDbConnection(“Provider=Microsoft.Jet.OLEDB.4.0;data source=” & Server.MapPath(“db1.mdb”))         msaccessconnect.Open()         query = “SELECT * FROM `advertiser`”         databasecommunication = [...]

Answer Question   |  December 15, 2010  5:52 PM
Access 2003, ASP.NET, Visual Basic, Visual Basic .NET

Using IBM System i Access can I replace zeros with blanks in a downloaded CSV file?
Hi, I have a simple file transfer from my iSeries(AS/400) to a CSV file.  I have a numeric field with 2 decimal places.  The file is sent to an outside agency.  They need zero values to contain blanks.  Is there a way to do this? Thanks for your help.  

Answer Question   |  August 12, 2010  3:01 PM
AS/400, CSV, CSV file format, iSeries

Help regarding my SAP career
Hello. I have just finished my B.E in Electrical & Electronics. SOmebody told me regarding the job prospects after doing SAP. Now as SAP cpurse is very expensive to pursue, I would like to know which module will be better fr my field and what is the level of hardness of the course ? And [...]

Answer Question   |  December 2, 2010  1:33 PM
IT career planning, IT careers, SAP careers

SQL Query to consolidate rows into new table
Hi again, I have another query to get my head around! I am trying to take an existing table in a database that looks like this Time Type Price Code 09:00:01 BID 99 A 09:00:01 ASK 100 A 09:00:01 BID 99.5 B 09:00:01 ASK 100 B 09:00:02 BID 99.3 A 09:00:03 BID 98.5 C 09:00:03 [...]

Answer Question   |  August 11, 2010  11:09 AM
Access, SQL, SQL Query, SQLite

SQL Query to get the difference from average for every row with grouping
Hi there, i was wondering if anyone would be kind enough to help with something i am struggling with… I have a table something like this: Region ID Cost s1 1 v1  s1 2 v2  s1 3 v3 s2 4 v4 s2 5 v5 s2 6 v6 What I am trying to achieve is to [...]

Answer Question   |  August 11, 2010  10:54 AM
Access, SQL, SQL Query, SQLite

How do I duplicate or clone a dying SATA drive?
If a sata drive is dying what is the best method to duplicate or clone it without risking the data? Is this the same for ide or scsi drives? If not please list the best methods for these as well across any platform.

Answer Question   |  August 10, 2010  2:16 PM
Backup, Clone database, IDE, IDE hard drives, SATA, SATA Drives, SCSI, SCSI Drives

Display date in Oracle Toad
how to display all the months between two dates.my fromdate format is ‘mon-yyyy’ and todate format is ‘dd-mon-yyyy’.plz sugest

Answer Question   |  August 9, 2011  3:07 AM
Oracle, Oracle Database, TOAD, Toad Data Modeler

Standby Database Server
I am using oracle 10g and I want to use a standby database for high availability of my database. I did almost everything; but I don’t know how a user can connect to the standby server when the primary has failed. This is my connection string “Data Source=(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = [...]

Answer Question   |  August 9, 2010  2:00 PM
Database servers, Oracle 10g, Oracle Database, Standby Database, Standby Server

Entry Level IT Job
What are some good entry level jobs for a college graduate in the IT field?

Answer Question   |  August 13, 2010  3:56 PM
IT career development, IT career planning, IT careers

Access 2007: Create a form for both display and data entry purposes
How can I create a form that is autofilled with data from a query (such as a client’s ID and balance), and will also be used for data entry for another field from a table not part of the query (the amount paid by the client and the current date)? I tried to use a [...]

Answer Question   |  August 4, 2010  2:23 AM
Access 2007 form creation, Access 2007 forms

How to remove Microsoft Foxpro Title bar
How to remove Microsoft Foxpro Title bar from the main screen in FPW2.6

Answer Question   |  August 3, 2010  4:54 AM
FoxPro, FoxPro 2.6, FoxPro 2.6 for WINDOWS

How to enter a field with number increments in Access 2007
How to increment a number field adding 3 with the number from the same field of the previous record. (like entering next invoice number)

Answer Question   |  August 6, 2010  10:01 PM
Access 2007, Access 2007 forms, Access 2007 functions

Combine (concatenate?) in Access~special circumstances
Hi, I need to be able to combine (concatenate?) fields in Access so that each item in Field 1 is joined to each item in Fields 2 thru 5. I have tried to illustrate this in the samples below… In the samples below, Account code is in Field 1… String(s) to be added are in [...]

Answer Question   |  August 6, 2010  12:28 PM
Access, Access Controls, Access Functions, String name

iSeries Update Values in a Table Based on Values in Two Tables.
I want to update a Client Category Code in the Client_Table where the Client has a specific Country Code AND and the Clients VAT No is Blank, Which is in The Client_Account Table in another Library. The Matched Records are [LIBRARY1]FILE1.CLLDRS and [LIBRARY2]FILE2.ADLDRS So Update [LIBRARY1]FILE1 SET CATCDE=’EXM’ where FILE1.CTRY = ‘US’ and [LIBRARY2]File2.VATNO =NULL. I know the above syntax isn’t correct. but can [...]

Answer Question   |  August 2, 2010  10:25 PM
AS/400 DB2, DB2 administration, i5/OS, iSeries, iSeries Access

Javascript code
Hi, I’m looking for an IF function code,,, My condition is IF I TYPE THE WORD “MOD” in a CHAT BOX THEN I want this MOD WORD TO APPEAR IN GREEN COLOR. I would like to know the code which I can embed for this to happen? thanks!

Answer Question   |  August 2, 2010  9:50 PM
Functional programming, IIF function, JavaScript, JavaScript functions

Error message stating that the value is too long for the field.
I entered the last name of one of my students and received an error message. What is my next step(s)?

Answer Question   |  July 30, 2010  5:28 AM
Access 2007, Access errors, Error Messages

Should I Follow Cisco or Microsoft Career
Dear everyone I am student and studying IT I am wondering and asking myself that Should i follow Cisco or Microsoft Technique to improve my IT career in the future Or if i have to learn both, that’s OK but which one first ?? Finally, which one is easy to find job. Because i want [...]

Answer Question   |  August 3, 2010  5:28 AM
IT career development, IT career planning, IT careers, IT certification