• 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...

    ITKE342,195 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,185 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:
  • How do I read in the comma delimited files by SAS

    How do I save an Excel File with 2 sheets into two comma delimited (.csv) files, first for the sheet tabbed "sheet 1" and second for the sheet tabbed "sheet 2"? Also, how do I then read in the comma delimited files by SAS? *note: these are excel files that I am trying to read into the SAS program

    Mimi1111115 pointsBadges:
  • 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 linked to those tables, would the...

    Sujun5 pointsBadges:
  • Calling a URL length more than 200 from CLP

    Hi Techies, I would like to call a URL by passing some input values and retrieve some values from the results. 1. The URL lenght is more than 200, with special characters like % " < / > 2.I need to retrieve values from the particular website. Can u please help me out soon, its been getting...

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

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

    TRSJ45 pointsBadges:
  • SELECT AND OMIT in RPGILE

    hI,GUYS,Actually select and omit used in lagical file to control the records,values like. But without key field how can i use these select and omit condition in logical file? And one more doubt is what is the exact uses of %SCAN,%SUBST, %SUBDT,%EOF,%CHECK,%COMMIT,%FOUND.Plese explain these

    0 pointsBadges:
  • 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 what separator...

    TRSJ45 pointsBadges:
  • Is it even possible to store calculated data in access 07

    my employer asked me to build a database to do payroll. the forms are complete, the expressions work, but the calculated fields do not store in the table like they should, such as net and gross pay. is there another way to do this? i am in serious need of help. thanx

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

    Michael Morisy8,323 pointsBadges:
  • DB2 (Oracle funtionality in)

    Hi, all I have no familiarity with DB2, but plenty in Oracle and SQL Server and other RDMS. In Oracle, I can access a flat file on disk by defining it as an External File. Similar functionality in SQL Server. My question then: Does DB@ on the mainframe have the same type of feature? Thanks in...

    Rireland5 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