Statement separator for multiple DLast statements – Access 2003
MS Access I am trying to set defaults for selected fields in a form based on the previous (last) record. I can do this for a single field using the code below in Form Properties/BeforeInsert but I need to add three more fields. Is this possible and, if so, how should I phrase it and [...]

Answer Question   |  February 5, 2010  9:21 AM
Access 2003, Microsoft Access

The IT Blog Top 10: Feb. 4, 2010
Here are the most popular blog posts on the ITKnowledgeExchange network this week. Read the rest of the top 10 on the Community Blog, or apply for your own blog by e-mailing me at Michael@ITKnowledgeExchange.com. 1. How to allow the root user to log in to VMware ESX Server with SSH David Davis’ how-to on [...]

Answer Question   |  February 4, 2010  4:49 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, DataManagement, Development, Exchange, ITKE, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP

The most-watched IT questions this week: Feb. 2, 2010
Tick tock, tick tock. What’s that sound?  The countdown for the Nexus One Challenge. What? You’ve moved on? Well

Answer Question   |  February 2, 2010  3:36 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, DataManagement, Development, Exchange, ITKE, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP

SQL for MS Access Syntex issue
I have started to read the book by Cecelia L. Allison and Neal A Berkowitz on SQL for Microsoft Access.  and there is a syntex listed below that has been giving me a problem.   I get an error with the word UNIQUE.  So I removed it from the statement and then I get an error with the [...]

Answer Question   |  February 3, 2010  1:56 PM
Microsoft Access, SQL

DB2 (Oracle funtionality in)
Hi, all I have no familiarity with DB2, but plenty in Oracle and SQL Server and other RDMS. In Oracle, I can access a flat file on disk by defining it as an External File. Similar functionality in SQL Server. My question then: Does DB@ on the mainframe have the same type of feature? Thanks [...]

Answer Question   |  February 3, 2010  6:04 PM
DB2, DB2 file system, File systems, Flat files

Coding career question
how i improve my logic in coding that will help me to build my carrier in IT INDUSTRY?  

Answer Question   |  February 1, 2010  7:43 AM
Careers, Coding, IT careers, Programming, Programming Careers

Hardware and Networking
Hello again, My brother is an engineering graduate in Electronics and communication stream and as he has less interest in electronics he plans to take up hardware and networking.  Is there growth seen in hardware and networking? What are the goals to keep in mind?

Answer Question   |  July 12, 2010  3:18 PM
Careers, IT careers, Networking careers, Routing and switching

Different results for embedded SQL
I have embedded SQL in my RPG code and some of the results are different to what I get when I check using STRSQL

Answer Question   |  February 1, 2010  7:08 PM
Embedded SQL, RPG, SQL, STRSQL

Access 2007 form creation
[strong]KVS: [/strong] [strong]Q: [/strong]Hi There, I have created a transport database for my organisation where employees can req for transport when needed. But i’m not good at Access 2007. I need help on below list of queries: 1. I have created button for employees to submit their request, now when they click on that button [...]

Answer Question   |  January 28, 2010  9:19 PM
Access 2007, Access 2007 form creation, Access Forms Database

How do I transfer 300 gigs of information?? Please Help!!
I am using roadkil unstoppable copier and my transfer always stops halfway, am I doing it wrong or what!!! I’m transferring 13 300gig drives to a 4T hub. The hub is Western Digital 4T Sharespace and I have to connect to it via network, it doesn’t work with usb to usb. I thought that unstoppable [...]

Answer Question   |  February 3, 2010  6:24 PM
File transfers, unstoppable copier, Very Large Databases, western digital

connectivy between C++ and MS Access
hi, i have problem releted with ms acess and c++ programming languge sir cant get any information about connection between ms acess and c++ programming languge give me steps to connect ms acess and c++

Answer Question   |  January 27, 2010  9:11 AM
C++, Microsoft Access, Turbo C++

Is it even possible to store calculated data in access 07
my employer asked me to build a database to do payroll. the forms are complete, the expressions work, but the calculated fields do not store in the table like they should, such as net and gross pay. is there another way to do this? i am in serious need of help. thanx

Answer Question   |  February 4, 2010  3:32 PM
Access 2007, Access 2007 forms, Microsoft Access 2007 Reports

Access 2007 form creation
Hi There, I have created a transport database for my organisation where employees can req for transport when needed. But i’m not good at Access 2007. I need help on below list of queries: 1. I have created button for employees to submit their request, now when they click on that button a message should [...]

Answer Question   |  January 29, 2010  12:10 PM
Access 2007, Access forms, Microsoft Access

From KPO Background, How about future ?
Team, I was a consultant in a Financial instution, my background ( I have done my B.Com and M.A. in Public Administration ) after doing this, I have done computer courses ( MS Office, JAVA etc.,). Now I want to work on Finance so I want a answer from you which course would be beneficial for [...]

Answer Question   |  July 12, 2010  7:45 AM
Careers, IT careers, SAP careers, SAP Finance

PICTURE STORE IN ACCESS 2007 DATABASE THROUGH VB
KINDLY TELL ME HOW I STORE PICTURE/IMAGE IN ACCESS 2007 DATABASE THROUGH VB CODE     ANANDA DEBNATH INDIA, DELHI  

Answer Question   |  January 24, 2010  7:33 AM
Access 2007, Access Data Store, Microsoft Access, VB

Telecommunication certifications
I want to know what are Telecommunication certifications and which one would be best for a diploma Holder?

Answer Question   |  July 12, 2010  10:23 PM
Careers, Certifications, IT careers, Telecom, Telecom Careers, Telecom certifications, Telecommunication certifications

Oracle Financials
what is market for oracle financial, because i plan to study the orcale financial already studied the sap. can i study or improve the knowledge in sap. please help

Answer Question   |  July 12, 2010  3:40 AM
Careers, IT careers, Oracle Careers, Oracle certifications, Oracle Financials, SAP careers, SAP certifications

How do I place duplicate directly below the copied record?
I have code (below) which works perfectly today attached to a button to copy a record in a form. But, it inserts the new record at the bottom of the form, I would like to make it past the new record immediately below the copied record. Is there a way to do this? Private Sub [...]

Answer Question   |  January 21, 2010  3:20 PM
Microsoft Access, Microsoft Access forms

Software Testing as a career option.
Hi..am an electronics engineer with no work experience.  But over a couple of months..I’ve slowly figured out that i like to work in a team,have communication with people as an essential ingredient of my work, like management as an element of work, and experiment the work i am doing. With these criteria in mind..would i enjoy software testing [...]

Answer Question   |  April 12, 2011  8:20 AM
Careers, IT careers, QA, Quality assurance, Quality Assurance Careers, Software testers, Software testing, Software Testing Certification

On the as/400 i series can one use SQL querys to update file
Cobol uses some kind od IKJ module user exit to allow DB2 SQL calls. I want to make a keyed read update one field and go on to the next record and do the same until end of file. Can do the same using RPG and if so could give me an idea what the [...]

Answer Question   |  January 20, 2010  9:55 PM
AS/400, RPGLE, SQL, SQL queries