Access 2007 IIF statement in query criteria
This is a query design looking at a checkbox on a form, if its checked, I would like to return only the database fields (ConfigData) that contain text. If it isn’t checked, return all the fields whether they have text or not…Pretty basic filter I thought Seems like I’m getting close but can’t seem to [...]

Answer Question   |  November 14, 2009  5:04 AM
Access 2007, IIF statement, Microsoft Access

Access Form Printing Problem
I have designed a set of forms in Access.  One of the forms prints the form in total.  However tow of the forms will only print the header and footer and does not print the data input portion of the form.  What am I missiong in regards to why I can’t get these two forms [...]

Answer Question   |  November 11, 2009  11:03 PM
Access forms, Microsoft Access

How do I fetch synonym names with the SQLTables function in ODBC API?
Can somebody please explain how to fetch synonym names with the SQLTables function in ODBC API. I currently use the DSN created with SQL Native Client 10 and SQL Server 2005. My code is as follows:</p><p>ret = SQLTables(stmt, NULL, 0, NULL, 0, NULL, 0, <br>SQLCHAR*)”‘TABLE’,'VIEW’,'ALIAS’,'SYNONYM’”, SQL_NTS);</p><p>I am getting back a table and views in a result set — [...]

Answer Question   |  November 10, 2009  9:40 PM
ODBC, SQL tables

Database Splitting
What other alternative do I have to split a lotus note database beside writing a code to copy  document to newly created database?

Answer Question   |  November 9, 2009  4:58 PM
Access Database, Database optimization, Lotus Domino

How to combine 2 linked Excel tables in access 2003 with same field names, using query?
I have 3 employees working who have no access on their PC. they are performing their data entry in excel and I ahve linked all three tables to one access file as I have Access on my PC. I need to combine all 3 tables using query or some other method in access to create [...]

Answer Question   |  June 22, 2012  6:37 PM
Access 2003, Data management, Microsoft Access query

The IT Blog Top 10: Nov. 5, 2009
10. Using VRDP to view VirtualBox virtual machines remotely Rick Vanover has put together a useful tutorial for Sun’s xVM VirtualBox. 9. How to reset the Cisco Catalyst Switch to Factory Defaults Yasir Irfan offers some advice for those needing a fresh late on Catalyst switches. 8. Independent clauses and semicolons Margaret Rouse offers up [...]

Answer Question   |  November 5, 2009  4:01 PM
Channel, CIO, CRM, Database, DataCenter, DataManagement, Development, Exchange, ITKE, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP

lamp or sap
HI all , i ve complted my engneering in electronics and Commnctn; Now i have two options to take up as my career, sap or lamp; which has more opening and scope ; what are the categories in sap/

Answer Question   |  November 26, 2009  1:01 PM
Careers, Certifications, IT careers, LAMP, SAP, SAP careers

RPGLE Flat File
how can i keyed a flat file in RPGLE

Answer Question   |  November 28, 2009  10:58 AM
Flat files, RPGLE

Mysql syntax
Hi Have a table: budget When I try this: MySql: insert into budget values (’Department A’,1,2,200) Department A represents:A Department called A 1 represents: a courseno from table course 2 also represents: a courseno from table course It doesnt work … Any suggestions…. ?

Answer Question   |  November 4, 2009  9:59 PM
Data Tables, MySQL, tables

Constraints (MySql,tables,null,PK,FK etc)
Hi all(waves) noob here ( ) ( yes you might look down upon me) ( ) never the less….:)  Quick question: Tables made so far: department values (depno,dname) course values values (courseno) How would I create a table eg “Table budgets”…with values of two budgets (£100 and £200) for courses. 1.Courses are managed by departments. [...]

Answer Question   |  January 23, 2010  7:52 PM
constraints, foreign key, MySQL, NOT NULL, NULL, primary key, tables

The most-watched IT questions this week: Nov. 3, 2009
Here are the 10 most watched questions on ITKE: There’s some great discussions going on. Go answer a question now and take your shot at winning a TV: 1. Problem installing Exchange 2007 Management Tools was posed by Labnuke99 and answered by Mshen. 2. What Event ID was asked by Newbiepeon and answered by Jerry [...]

Answer Question   |  November 4, 2009  2:33 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

PHP Datagrid
Hi! I m new to php and MySQL database. I want to know how whether php provides any class for datagrid

Answer Question   |  February 14, 2011  4:57 PM
DataGrid, MySQL Database, PHP/MySQL

Migration from Paradox to MS Access or VB.Net/MS SQL
We have a department that has several applications running on Paradox 11.  They need assistance migrating their tables and application UI/code to another platform.  Any feedback or guidance would be appreciated.

Answer Question   |  January 23, 2010  9:11 PM
Access 2003, Microsoft Access, Paradox 11, SQL, VB.NET, VB.NET 2008, Windows Server 2007, Windows XP

How to convert LONG to CLOB or to VARCHAR type in select statement
Hi, I need to convert LONG to CLOB or to VARCHAR type, to be able to apply either dbms_lob.substr() or just SUBSTR() function to this conversion result. Unfortunately Oracle function to_lob() converts LONG value in the column long_column to LOB values in the select list of a subquery in an INSERT or UPDATE statement O_N_L_Y. [...]

Answer Question   |  April 19, 2011  8:00 PM
CLOB, Conversion, DataType, Long, Oracle, PL/SQL, SQL

How to prepare for IT interview?
How to prepare for IT interview?

Answer Question   |  October 30, 2009  7:05 AM
Careers, Interviews, IT careers

The IT Blog Top 10: Oct. 29, 2009
10. Choosing a block size when creating VMFS datastores Eric Siebert has written a guide on how to choose the right size for VMFS datastores. 9. How to use command line arguments in VBScript via the Wscript.Arguments Object Jerry Lees explains a helpful VBScript trick. 8. Using VRDP to view VirtualBox virtual machines remotely Rick [...]

Answer Question   |  November 28, 2009  7:08 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, DataManagement, Development, Exchange, IT Blogs, ITKE, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP

COMBO BOX (IN VB) HOW BEHAVE LIKE MS ACCESS
HI VB EXPERTS, PLEASE SOLVE HOW CAN BEHAVE THE VB COMBO JUST LIKE MS ACCESS COMBO (OFFICE 2003/2007) EG. IN MS ACCESS COMBO :- A) WHEN START TYPING THEN NEAREST MATCHED SELECTED/DISPLAYED B) ON GOT FOCUS COMBO DROPDOWN ABOVE FACILITIES I WISH TO AVAIL IN VB COMBO BOX PLEASE PLEASE PLEASE SOLVE IT NB : THIS [...]

Answer Question   |  January 23, 2010  7:24 AM
Microsoft Access, VB, Visual Basic

IT infrastruture
Dear Sir, I Gaurav Nijhawan 21years old working in a mnc company in gurgaon(India). I have two years of experience in IT for supporting a site. I did MCP( Microsoft Certified Professional). earlier i was working as a desktop support engineer and completely work on Desktop and Outlook troubleshotting. I had a little bit of knowledge of [...]

Answer Question   |  November 5, 2009  5:05 AM
Careers, CCNA, Certifications, IT careers, IT infrastruture

UDS and DS
I know well Data Strucutre (DS) and its usage, how an UDS (Data Area Data Structure) is different from and ordinary DS, I just find to know by myself but I was unable to find it. Can any one help me in expalainigt this?

Answer Question   |  October 27, 2009  2:23 PM
AS/400, AS/400 database, Data structures

What are the points to be taken care of when designing a database on Linux?
What are the points to be taken care of when designing a database on Linux? What are the different replication methods available?

Answer Question   |  October 27, 2009  2:39 PM
Database design, Database replication, Linux databases