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

Database Update database
I will whole database all tables, procedures, triggers, functions defination in one file. i want to use that file to upgrade another database. is it possible ?

Answer Question   |  July 30, 2010  5:02 AM
Database management, Sunrise, TRIGGER

Moving Cursor Within That particular field?
Ok Sir, Forget All that thing i will ask in simple way this same question? Dsplay File Field:    Roll No:-ooooooo mark= -BBBBBBBB-   1)So In that Case When We call Prog At first Roll No field Contains Roll No And marks field will be blank. 2) When Cursor Will Come at Mark field then at [...]

Answer Question   |  July 29, 2010  5:01 AM
Cursor operation, Display File, Display File Description, DSPF

Adding column to existing table in a database
When I add column in existing table. it contains null values in older records. it is possible to assign a value when add column so older records are modified with value

Answer Question   |  August 18, 2010  4:59 AM
Data Tables, Database management, Sunrise

Gently Close a Database Application
We are using WorldShip, a program from UPS. It has a database. We have our workstations, including the one running WorldShip on an automatic shutdown schedule. In the past we have experienced errors with the database because the workstation is shutdown administratively even if the WorldShip application is running. Is there a gentle way to [...]

Answer Question   |  July 29, 2010  2:06 PM
Database applications, Windows XP SP3, WorldShip

Moving Cursor Within That particular field?
Thank you Sir its Working properly, But One more Question i want to ask u Display File Contains field Name=BBBBBBB Roll no=oooooo Marks=……… When I will Enter Name Cursor Will Go to Marks Field But Only Mark is Updated Field So Once I entered Name Cursor will go to Marks And After That It will not  Move [...]

Answer Question   |  July 28, 2010  3:56 AM
Cursor operation, Display File, Display File Description, DSPF

Change the size of a column and then reorganize the rows in SQL tables
I think this one will be tricky. What I have is a table like: CREATE TABLE PHOTO_DETAIL   (     ”PHOTO”        VARCHAR2(25 BYTE) NOT NULL ENABLE,     ”NUM_LINE”   NUMBER(20,0) NOT NULL ENABLE,     ”PHOTO_LINE”  VARCHAR2(180 BYTE)   )   what I am going to have is: CREATE TABLE PHOTO_DETAIL   (     ”PHOTO”   [...]

Answer Question   |  August 2, 2010  12:13 PM
INSERT SELECT statement, INSERT statement, SQL Database, SQL Server, SQL tables

How To get The Cursor position on particular field?
My display File Contains three Fields as like name= ……..  Roll =……..  Marks=…….  But In that Case when Program Call, First Cursor Pos On name When Name Will Enter Roll No will Automaticalyy Disply. But I have To Modify Marks Field,,, So When I will Enter Name After That I want To cursor On Mark [...]

Answer Question   |  July 28, 2010  10:28 AM
AS/400, Cursor operation, DSPF, RPG, RPGLE

How do I create a database using C language?
how to create database using c language

Answer Question   |  July 29, 2010  10:18 AM
C++, CREATE DATABASE statement, Data base design, Database, Database management

Changing Access form properties within your program.
I have a form where I want to lock a control according to the selection made in a combo box. How do I go about doing this? Thanks.

Answer Question   |  July 27, 2010  4:41 PM
Access, Access form controls, Access forms, Access Forms Database

Hotel database in Access 2007
How do i create a Hotel database in Access 2007

Answer Question   |  November 22, 2010  3:59 PM
Access, Access 2007, Access 2007 form creation, Access Database, Access Database Design

How do I create a trigger in VB 6?
HOW TO CREATE A TRIGGER IN VB6

Answer Question   |  October 1, 2010  3:57 AM
Triggers, VB, VB 6, Visual Basic, Visual Basic 6

Choosing a major
Im trying to choose a major for this coming Spring 2011. Ill be done with my GE’s and want to venture into Technology. So far, Informatics, Computer Engineering, and MIS are my top three choices. Can anyone enlighten me on career paths and best ways to prepare in various specializations?

Answer Question   |  July 26, 2010  2:02 AM
Informatics, IT career development, IT career planning, IT careers

Future in SAP
hi, i have a wrok experience in automobile industry as customer relation and BPO experience in again cs for over 9 years , i have done MBA in marketing, wanted to pursue my career in SAP . please suggest which sap course i should do and from which institute ? thanx

Answer Question   |  November 4, 2010  6:53 PM
IT career development, IT career planning, IT careers, SAP careers

Hide print page that is blank in Access 2003
I have a report that from a query displays multiple fields. In some cases a second page hold additional data. How do I suppress the second page when the main data section is blank?

Answer Question   |  July 23, 2010  6:19 PM
Access, Access 2003, Access 2003 forms, Access query

sql 2008 export to txt for backup and incremental backup
Hi i have one db that i want to back up, so thought id export to txt file/flat file then back that up and then daily increments into that file? cant find the steps to do it..have the wizard..

Answer Question   |  July 23, 2010  10:34 AM
Backup, SQL 2008, SQL database replication, SQL Server, SQL Server 2008, SQL Server database