SQLRPGLE – Result Set
I have an SQLRPGLE program [PGMA] containing the following: D ResultSet       DS                                 D                                     Qualified      D                                     Occurs( 9999 ) D  AAuUserId                   10 D  AAuValFr                      10     C/EXEC SQL                                              C+ CALL XXDLIB/PGMB (:##BegNo, :##EndNo, :##UserID)   C/END-EXEC                                              PGMB has the same DS structure defined as in PGMA and successfully populates the DS ResultSet in PGMB How do I get SQLRPGLE [...]

Answer Question   |  February 26, 2010  2:37 PM
AS400 Data Definitions, Data structures, Programming, RPGLE, SQLRPG, SQLRPGLE

The most-watched IT questions this week: Feb. 16, 2010
1. JHite ran into an Outlook 2003 display name issue for contact with multiple email, and XENOPHON22, Mrdenny and Carlosdl helped out. 2. Windows Server 2003 is giving a member some installation trouble, and MrDenny offers some advice. 3. Can you block Exchange 2007 admins from viewing other admin’s mailboxes? No, according to Technochic and [...]

Answer Question   |  February 17, 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

Auto-Populate an Access form using a table of values
I’m having a little bit of a dilema. I don’t even know if it can be done, but I thought I’d give it a shot. I’m pretty new to Access so I’ll try to be as clear as I can be, but I think this will get confusing. I have Multiple tables and a form for adding [...]

Answer Question   |  February 17, 2010  8:56 PM
Access 2003, Access forms, Microsoft Access

Database Track Payment Information
I need some expert advice.  I need an application to track payment information.  The payments are actually stored on the AS400 and the payment arrangements are stored currently on paper.  I was considering using Access and setting up an ODBC/OLEDB driver to my AS400 to collect the most update to date payment information.  Is this [...]

Answer Question   |  February 16, 2010  2:46 PM
AS/400, Database, Microsoft Access 20007

SQL Access Query
I am using the book SQL for Microsoft Access. and the below statement is from the book and for some reasone I am getting a sytex error on the  word “Udate”     Why would that be?  CREATE TABLE Manufacture ( ManufactureID INTEGER CONSTRAINT ManfID PRIMARY KEY, ToyID INTEGER NOT NULL, CompanyName CHAR (50) NOT NULL, [...]

Answer Question   |  February 16, 2010  11:00 AM
Access Datasheet, Access query, Microsoft Access, SQL, SQL Access, SQL Query

Still having trouble with IIF in Access 2007
If I type in the criteria block Is Not Null [Br _extended=”true” />then only those people who have a position assigned to them are listed and the position is listed. These are the people who get 25 points. What I need to do is to replace the position with “25″ in simple terms, if any [...]

Answer Question   |  February 15, 2010  6:15 PM
Access 2007, Data base design, IIF, IIF function, IIF statement

MS Access 2007, IIF and Null expressions
Ok what I want to do is very simple but nothing I have found is helping me. I have a field that sometimes contains a value and but most of the time it is empty. What I want to do is write an expression that says if there is something in this field, then “25”. [...]

Answer Question   |  May 9, 2013  1:25 PM
Access 2007, IIF, Microsoft Access, Null Expressions

How To Train For Help Desk Role?
Is there any software/on line training I can purchase to learn this role? My background is in IT operations ie AS400/Mainframe etc… I realise that I am back in the classic IT Catch 22 situation of no experience = no job interview.  

Answer Question   |  July 9, 2010  11:29 PM
Careers, Helpdesk training, IT careers, IT Help Desk, IT training

Trouble with IFF MS Access 2007
Ok what I want to do is very simple but nothing I have found is helping me. I have a field that sometime contains a values but most of the time it is empty. What I want to do is write an expression that says if there is something in this field, then “25” I Believe [...]

Answer Question   |  February 16, 2010  1:30 PM
Access 2007, IIF function, Microsoft Access

Career Path
What is Career Path of a Software Engineer,Working in Software House or Industry,Which Job is Better?

Answer Question   |  October 20, 2010  5:13 AM
Careers, Certifications, IT careers

MS Access Networking
Which TCP port(s) can I use to monitor access database queries over the WAN?

Answer Question   |  February 12, 2010  4:20 AM
Microsoft Access, TCP Ports, WAN

Wrkqry for join files
Hi, can you help me how to join the two files but the two fields are not the same length e.g. 1st field (left side) is 9 (ex. A005B2589 job#) and the 2nd field (right side) is 11 (ex. A005B258901… the last two digit 01 is for partial#), kindly advise if it’s possible?  Thanks and regards…

Answer Question   |  October 18, 2011  8:57 AM
JOIN statement, WRKQRY

Link between Access & Crystal
How do I link between Database and Crystal report to make a report paper?

Answer Question   |  February 10, 2010  3:42 AM
Crystal Reports, Microsoft Access

in Access 2003, adding data in a table affect queries?
Hi, I am using Access 2003. I am working on a database that already exists. I want to add a name of a location in a field in some existing tables. Basically I want to add a name of a location to a field that is a drop down list of locations. There are queries [...]

Answer Question   |  February 9, 2010  10:37 PM
Access 2003, Access Tables, Microsoft Access

.nsf file error
While i am trying to open the replica folder in notes, it gives me a message “Database is corrupt – Cannot allocate Space”. I am using Lotus notes 7. Have tried nfixup,nupdall & ncompact. Did not help. Any other resolution that can be tried.

Answer Question   |  May 1, 2012  3:36 PM
.NSF files, Database replication, Lotus 7.0.2

Getting DLookup to refer to a previous record in a filter
I am trying to use DlookUp to get field values from a previous recrod wher the records have been filtered.   I have found the code below but it refers to ID-1, rather the actual ID that may be the previous record resulting from the filter. =DLookUp(“[MyField]“,”MyTable”,”[ID]=Forms![MyForm]![ID]-1″) Any suggestions? Thank you.

Answer Question   |  February 8, 2010  9:52 AM
DLookup, Microsoft Access

Comparing yearly orders in VFP
I have two tables, client and orderhistory, with fields program_year and qty_ord. I need to find clients with orders in 2008 but not in 2009.

Answer Question   |  February 8, 2010  9:37 PM
CrossTab Query, VFP

Access VBA Code stops at Midnight
Why do all my Access VBA scipts stop at Midnight?

Answer Question   |  July 23, 2010  6:56 PM
Microsoft Access, VBA

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