Query
I have a training database; one table lists employees by titles and training required; the other lists employees by name and training completed. I would like to do a query finding out which training that is required but the employee had not received, how would I create that query?

Answer Question   |  February 26, 2013  1:44 PM
Database, Query

How can remove Zip corruption issues?
I have found many applications online which repair or extract corrupt Zip files from unapproachable database. But I don’t know what the best technique is for removing all Zip corruption issues.

Answer Question   |  February 18, 2013  12:53 PM
Database, Zip Files

About an OPCODE EVAL-CORR
I would like to have sample code on the OPCODE LIKEREC with all its parameters like with *All and *KEY and *INPUT and *OUTPUT. Also, I want to know whether OPCODE EVAL-CORR in iSeries or not  because when I want to transfer data from one DS (Data Structure) to another DS using EVAL-CORR, I’m getting [...]

Answer Question   |  February 8, 2013  4:27 AM
Data structures, iSeries

Finding a specific record with user input
I am very new to Access, but have used Approach in the past. When I used Approach, I could create a find in a form, user would be able to enter the find criteria in the blank field. I can not figure out how to do that in Access. Help!

Answer Question   |  February 4, 2013  12:55 PM
Microsoft Access, Microsoft Access forms

Data transfer between databases
Hi, I need to transfer data from one database to another, whenever a table in the first database get inserted with a value from UI. Can somebody explain me way to do this (Both databases are not identical). I have an idea like selecting required row data from first table and putting it in generic [...]

Answer Question   |  February 4, 2013  8:29 AM
Data transfer, Databases

How to limit exact file name for data access on AS/400 through ODBC
How to limit exact file name…we need the restrict exact file name (not at all) when our user use data access on AS/400 through ODBC.

Answer Question   |  January 28, 2013  7:17 AM
AS/400, ODBC

AS/400 pass through query from Microsoft Access
I am trying to build a pass through query in Microsoft Access. I am trying to retrieve data from a file that has multiple file formats. Here is the code I have so far in my pass through query: SELECT h.lhamt1 balance, h.lhnote account FROM bnkprd01.lnp007 h WHERE h.lhtc1 = 33 AND h.lhposj BETWEEN 2012336 [...]

Answer Question   |  January 24, 2013  2:45 PM
AS/400, Microsoft Access

Questionnaires List
I managed to received on MDB files that contains various examination questionnaires. I believe that its possible to take and retrieve answers inside from the file itself. Can someone tell me how?

Answer Question   |  January 21, 2013  4:49 PM
MDB, Microsoft Access

Getting data from two sources into one table
I have a form that will add data to say mainTable. In the form, I want to get some data like last name, first name and client_number from a linked master table (using a combo box) and have that data added into mainTable . I would also like to enter data (last name, first name [...]

Answer Question   |  January 14, 2013  5:48 PM
Microsoft Access 2010, Microsoft Access tables

TIME String using Variable H (0 to 23) & M (0 to 59)
Working on project to convert a Microsoft Access database application to DB2 10.1. This my first with DB2. 1st I tried SQL Script SQL Script: INSERT INTO “IBNserv”.”ChkMe”(“Clt”)>>> [Column Clt Data Type TIME NOT NULL DEFALUT 00:00:00] VALUES CAST(’12:14:00′ AS TIME) STATUS INSERT INTO “IBNserv”.”ChkMe”(“Clt”) VALUES CAST(’12.14.00′ AS TIME) Updated 1 rows. Query execution time [...]

Answer Question   |  January 14, 2013  10:37 AM
DB2 10.1, Microsoft Access, Microsoft Access database

Update query doesn’t update table
This is a really basic question, but I can’t seem to make it work. I have a simple table with 3 fields. StartTime EndTime ElapsedTime Each field is defined as a date/time datatype. StartTime and EndTime are manually entered. I’m trying to use the DateDiff() function in an update query to populate the ElapsedTime field [...]

Answer Question   |  January 14, 2013  3:12 AM
Microsoft Access 2010, Microsoft Access tables

How to know whether the CSV extraction to PF happened today
I have a requirement like this. I have 2 separate program which is called as part of daily job. I need to extract a CSV data onto an AS/400 physical file and this file is being used in both the programs. I need to put the call to extract the CSV in any of the [...]

Answer Question   |  January 10, 2013  6:31 AM
AS/400, CSV, Physical File

Database
Special database object can not be located?

Answer Question   |  January 9, 2013  11:09 AM
Database, Database objects

About database connection
How to connect Visual Basic 6.0 project to the MS Access ACCDB file for save the data?

Answer Question   |  January 9, 2013  10:25 AM
ACCDB file, Microsoft Access, Visual Basic 6.0

and IIf statement in a query
How do I write an IIF statement in a query, that does the following: if date1 – date2 is less than or = to 0 then Y else if greater than 0 then N

Answer Question   |  January 2, 2013  3:12 PM
IIF statement

How to implement a database on the users computer?
Suppose I want to develop a database for a client/firm/user or any person. I develop the DB using SQL, now I want to display the end result or the outcome on the clients computer without displaying the coded part, i.e., he/she doesn’t need to know about the codes and commands, he just manages db via [...]

Answer Question   |  December 26, 2012  3:16 PM
Database, Database Development

AS400 Subfile session or device error
DOW *in12 = ’0′ Seton 2526 Write blank Write foot1 WRITE MSGSFC Exfmt sfc01 call ‘L1000C’ These codes are from my program when i’m executing these pgm im getting seesion or device error. I checked with debugging , when the execution comes to the EXFMT line its showing the error.. Pls giv me some suggestion.. [...]

Answer Question   |  December 20, 2012  7:33 AM
AS400 Subfile, error

IBMDA400 Date Issues
The IBMDA400 provider seems to convert dates to character values even when using keyword “Convert Date Time To Char=FALSE”. This does not happen with the ODBC driver or IBMDASQL provider. I’d be okay with IBMDASQL except IBM states it only works the SQL statements. I’d be okay with ODBC driver except records can be doubled [...]

Answer Question   |  December 18, 2012  4:33 PM
AS/400, iSeries, ODBC

If logical function in MS Access
I have to use IF logical function in MS Access.

Answer Question   |  December 17, 2012  8:29 AM
Microsoft Access, Microsoft Access function

QMF
USER TRYING TO DOWNLOAD QMF REPORTS GETS ERROR IKJ56712I INVALID KEYWORD

Answer Question   |  December 14, 2012  3:42 PM
QMF