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
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
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
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
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…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
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
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
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
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
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
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
Special database object can not be located?
Answer Question | January 9, 2013 11:09 AM
Database, Database objects
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
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
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
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
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
I have to use IF logical function in MS Access.
Answer Question | December 17, 2012 8:29 AM
Microsoft Access, Microsoft Access function
USER TRYING TO DOWNLOAD QMF REPORTS GETS ERROR IKJ56712I INVALID KEYWORD
Answer Question | December 14, 2012 3:42 PM