• New Contest: Win the Nexus One Google Phone with your Knowledge Points!

    You're asking and answering questions already, so why not put those Knowledge Points to good use? Win a Nexus One, Google's new cell phone! It's unlocked, so you can sign on with the (select) carrier of your choice contract-free! Read all the details, but the short and long of it is that over the...

    Michael Morisy8,323 pointsBadges:
  • Microsoft Access 2003 Report Footer Formula

    I have a formula ( =Avg(

    Cmaggio20 pointsBadges:
  • DB2 Web Query – Active Report Show Unreadbale Data

    I have a report contains some information about customer name. When I save the output type as HTML ,the result is pretty good. The problem is, it is not good when save as Active Report AHTML. In each columns contains customer name in Thai will display as garbage or alian. How do we control this ?...

    Liverpoolfc20 pointsBadges:
  • Using SQL and Postgre on the same machine

    We have a requirement in which we need to have our Microsoft SQL Server, as a database of tomcat servers, and our Postgre SQL, as database of jboss servers, on same machine. Are there any known conflicts or issues we should be aware of?

    SQL Server Ask the Experts2,585 pointsBadges:
  • How can I run a Microsoft Access database on a computer and the report on a TV?

    I am using Task Management Database in Microsoft Access 2007 to track Items that need to be inspected. I have found a way to connect my computer to a TV. My goal is to keep the database view up on the computer screen so my Techs can walk up to it and add trouble tickets, but have a running report...

    ValerieOneZ15 pointsBadges:
  • hi all

    last day i installed one new xp theam on my xp system. recently i noticed that "RUN" option deleted from my start menu. can anybody help me in this problem ? thanks in advance

    Squibc40 pointsBadges:
  • MySQL Access Denied error

    I have installed mysqlcc-0.9.4-win32. After giving user name, password etc and add connection, connection is sucessfully added. But when trying to connect to the website the following error is displayed ERROR 1045: Access denied for user 'epfkeral_epfkera'@'117.206.11.168' (using password: YES)  ...

    Adwaith100 pointsBadges:
  • Merging of files in AS400

    What is the use of merging files in AS400? How do you do this?

    0 pointsBadges:
  • DB Triggers and JPA

    I have a physical file/table, on an iSeries, into which I drop a record containing UserID and Password. This action in turn fires a trigger that ends up calling the api QSYGETPH to verify the user's login credentials. This has been working for years under our previous architecture, wherein we...

    Rdgrimes0 pointsBadges:
  • AUTHID in DB2

    I want to define AUTHID while create stored procedure in DB2/AS400. This can be done in oracle as CREATE OR REPLACE PROCEDURE PRC AUTHID DEFINER / CURRENT_USER can this also be done in iSeries AS/400 DB2?  

    Bhadresh25 pointsBadges:
  • 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...

    ITKE351,865 pointsBadges:
  • 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 records. The master form has "Case...

    Jirges5 pointsBadges:
  • 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,...

    CompEng1,240 pointsBadges:
  • 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...

    lorit365 pointsBadges:
  • 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 that I should be using the...

    Phil12550120 pointsBadges:
  • 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 value,...

    Phil12550120 pointsBadges:
  • Querying multiple member PF with SQL

    I would need to SQL on a multiple member PF and I need to query the 2nd or nth member in the PF.  Is this possible just with an SQL query without using OVRDBF etc.?

    Rajgoaj280 pointsBadges:
  • MS Access Networking

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

    Ganzit65 pointsBadges:
  • Isolation level in iseries DB2

    How to set isolation level in iseries DB2? please reply.

    ORS5 pointsBadges:
  • Link between Access & Crystal

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

    BIFT55 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following