• What’s your biggest data problem? (Answer to win a free book)

    Data management is of growing concern now, and there are lots of ways to tame the beast. What issues has your organization had with managing or analyzing data? Have you come up with any solutions yet?We'll give a free copy of Making Sense of NoSQL (read an excerpt here) to the member who offers up...

    Ben Rubenstein5,250 pointsBadges:
  • DBMS query

    I have a two table. first is income table column name is - icode,point(outlet),incomedate,interest second is - ocode, point(outlet), outcomedate, interest 2 query 1). income of interest & out of the money at each outlet are return not more than the once a day. 2) income & out of the money...

    database215 pointsBadges:
  • Adding from two tables in VBA

    Does anyone know how I can use VBA to take one value from one table and add to it a value from another table and then put that total into one field of the original table. I've been fighting with this for a couple of days so now i am looking for some help.

    Silverhawk10 pointsBadges:
  • Creating a form in Access 2007

    i have a customer table with the following fields : name code : this should be generated automatically domestic export I want to create a form to add, edit, delete and view the records. when a new record is added, the user has to choose between domestic and export (option group), and based on the...

    agarwal12310 pointsBadges:
  • Looking for a db2/400 class in canada

    Hi, I am looking for a db2/400 training class in canada. i am not able to find any training class on the web. i am an oracle dba ane my boss wants me to get trained for db2/400 because we bought a company that is using it. Thanks.

    surname45 pointsBadges:
  • editing in grid forms

    How do I add,edit,delete in gridforms with Microsoft Access?

    vidyam5 pointsBadges:
  • AS400 DB2 Server User Access Audit

    Is there any way to track "User Account" information on a DB2 server specifically when a users account is locked?

    bsatl10 pointsBadges:
  • Read the data from PF between dates

    I want to read the all the record from the pf which are between some dates Eg: A PF has one year data let say 2011 year data, I want to read all the records from that pf which are from 01/03/2011 to 05/06/2011 dates. the PF fields are DATE,NAME,ADDRESS,P_no. Can anyone help me how to do this in...

    vzvzxvcx160 pointsBadges:
  • Powershell, loop through two different arrays?

    Helllo, What I am trying to accomplish is reading in two separate text files and going through them 1 by 1. Say text file 1 is computer names and text file 2 is ABCDEFG (the alphabet) In the script i'm trying to access a remote computer(s) (According to the text file 1) and access a text file on...

    bradob160 pointsBadges:
  • Title changing

    Hi Group, As per the new assignment i need to change the title from "MQM Application Business" to "ABC". I have identified the list of Programs and files where I need to change. The list includes RPG, CLP, CBL, CBLLE, CLLE, RPGLE, PRTF, DSPF & DDS files. I have question: 1. What are the factors...

    mvrkrishna530 pointsBadges:
  • Report design Access 2010 / 2007

    I do not know how to design a report that will display the data the way I need. It is hard to describe here, but I will try with a simple example. Each record is based on a date. On each date there are entries to 0-200 accounts for various $$ amounts. IE: on 1/1/12. acct 120100 for $5, acct 120202...

    gc4evr5 pointsBadges:
  • Character delimited csv with double byte data

    I have a physical file on the iSeries (V7R1) that I am trying to send to the IFS using CPYTOIMPF. When I open the file on the IFS using Excel I expected to be able to parse the data using "Text to Columns" but the delimiter characters are missing and the text is garbled. Several of the fields...

    loztech15 pointsBadges:
  • Determining data from a certain date range

    I have an Access 2003 database that has weekly dates and weights enter for a weight loss program. Ech program session is 8 weeks and people sign up for anywhere from 1 to many more sessions at a time. I want to find out the average weight lost in the first 8 weeks that a patient belongs, then in 16...

    HSwartzPartners65 pointsBadges:
  • VBA Array Loop

    Hello, Can anyone help me with VBA code that creates an array from a range of cells (A1:E1), loops through the array and performs a function. I already have the function now I need to create the array and loop. Thank you...

    ClaireJosie40 pointsBadges:
  • Importing a .dbf file into IBM DB2 table

    I have a .dbf database file I want to upload to our IBM i5 and into a DB2 table. Is there an easy way to do this or am I going to need to convert the .dbf file into a .csv file? I\'ve tried using the CPYFRMIMPF command, but have had no such luck. Any help would be greatly appreciated.

    msoucy25 pointsBadges:
  • VB6 Search Function

    How can I search in vb6 that when I clicked on the search bar, the information will be inserted to the text boxes.

    fleurdelis19935 pointsBadges:
  • Filter SQL Replication Deletes by user

    I am in the process of setting up replication from sql 2008r2 to Oracle 11. I have one requirement that is giving me some issues. My sql db is the publisher and currently maintains data from year 1. The Oracle subscriber will maintain 7 years data. After the initial snapshot the sql db will only...

    john26025 pointsBadges:
  • Find a string in text file using MS Access

    I would like to read a multi-row text file, from inside MS Access, search for a string and returns all its occurences. Sample file: ------------ Patch 123456 : applied on Wed Jun 27 15:42:09 CEST 2009 Created on 23 Mar 2009, 00:48:16 hrs PST8PDT ... Patch 654321 : applied on Wed Jun 25 15:41:56...

    masrawi20105 pointsBadges:
  • ACCESS 2010 query in CRYSTAL XI

    In Access 2010, suppose query having a validation rule [90 bal %] = '0', when calling this query in CRYSTAL REPORT that '0' considered as a parameter and waiting for user to input value for [0]. Though '0' is a validation rule and also working fine when running in ACCESS 2010 whereas in CRYSTAL...

    SQLlions35 pointsBadges:
  • Image capture and store into Sql Server 2005 code in vb 6

    how to store image in Sql Server 2005 by using visual basic 6

    nishantganapa0 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