• Open IT Forum: IT’s role in customer service

    One of ITKnowledgeExchange's bloggers is working on a series about customer service in the enterprise, and how it can be improved. From the IT side, do you have any experiences or suggestions for improving how companies do customer service? We'll take horror stories as well! Help a fellow IT...

    MelanieYarbrough6,345 pointsBadges:
  • Which config file does MySQL use?

    Hi, I'm having trouble with MySQL. My OS is IBMi V7R1. We are using MySQL 5.0.45 with zend server 5.6.0. The problem is that the MySQL server works fine in qp2term(shell) but ends immediately after start with zend server. Also, when I check the defaults config file for MySQL I get this message:...

    jailall101735 pointsBadges:
  • Form in Access 2007

    How to build a demand form which will draw grocery items from main inventory table with related data and quantity ordered will be filled up manually?

    pgd1235 pointsBadges:
  • Query

    I have a training database; one table lists employees by titles and training required; the other lists employees by name and training completed. I would like to do a query finding out which training that is required but the employee had not received, how would I create that query?

    catalina3x10 pointsBadges:
  • Assign a serial number for each group

    I want to assign a serial number for the below data using the Access query or by using SQL for Access DateItems Sold2/1/20135462/1/20138975/1/20132565/1/201310325/1/20137858/2/20136548/2/20131211 I want the output like as below: S.noDateItems...

    Tharanya5 pointsBadges:
  • How can remove Zip corruption issues?

    I have found many applications online which repair or extract corrupt Zip files from unapproachable database. But I don’t know what the best technique is for removing all Zip corruption issues.

    kavinthomash30 pointsBadges:
  • Example of Self-Join Logical File?

    Does anybody have an example of Self-Join Logical File code?

    svankipu620 pointsBadges:
  • Using IIF statement in query to return answer

    How do I write a IFF statement to return data? I am trying to write a IIF statement to let a student know if they are approved or not approved to play a sport. Here's the statement: Status: IIF([Waiver]="Yes"]) and IIF([Academic]="Yes"), "Approved", "Not Approved" When I do this and hit run, it...

    loggerhead79150 pointsBadges:
  • Database deletion

    How do I delete a database from Access 2007?

    plasma15 pointsBadges:
  • Data transfer between databases

    Hi, I need to transfer data from one database to another, whenever a table in the first database get inserted with a value from UI. Can somebody explain me way to do this (Both databases are not identical). I have an idea like selecting required row data from first table and putting it in generic...

    JOEJOSE5 pointsBadges:
  • Finding a specific record with user input

    I am very new to Access, but have used Approach in the past. When I used Approach, I could create a find in a form, user would be able to enter the find criteria in the blank field. I can not figure out how to do that in Access. Help!

    5boznme10 pointsBadges:
  • School Wi-Fi

    Hello. I am an Austrian pupil who is being educated to become a computer scientist. My current problem is that my school (about 750 people) needs WiFi. The WiFi is supposed to be usable with any Wi-Fi device (Phone, Tablet, laptop,...). However our teachers are supposed to operate without any...

    EvgymStudent15 pointsBadges:
  • How to limit exact file name for data access on AS/400 through ODBC

    How to limit exact file name...we need the restrict exact file name (not at all) when our user use data access on AS/400 through ODBC.

    ODBC35 pointsBadges:
  • AS/400 pass through query from Microsoft Access

    I am trying to build a pass through query in Microsoft Access. I am trying to retrieve data from a file that has multiple file formats. Here is the code I have so far in my pass through query: SELECT h.lhamt1 balance, h.lhnote account FROM bnkprd01.lnp007 h WHERE h.lhtc1 = 33 AND h.lhposj BETWEEN...

    lionbank5 pointsBadges:
  • How to download data from DB2/400 table

    Can someone tell me how does the unload utility work in DB2/400? I need to download data from a DB2 table to a text file.

    smlegacy15 pointsBadges:
  • Questionnaires List

    I managed to received on MDB files that contains various examination questionnaires. I believe that its possible to take and retrieve answers inside from the file itself. Can someone tell me how?

    themondcyte5 pointsBadges:
  • Linking tables in databases that change each month

    The test software that we use, creates a new database each month. So you have to relink the tables you use to the newly named database each month to get the new information. Is there some code that I can put into my database that will go out and relink these tables?

    cyberGirl19665 pointsBadges:
  • Getting data from two sources into one table

    I have a form that will add data to say mainTable. In the form, I want to get some data like last name, first name and client_number from a linked master table (using a combo box) and have that data added into mainTable . I would also like to enter data (last name, first name and client_number)...

    handlewhat5 pointsBadges:
  • Update query doesn’t update table

    This is a really basic question, but I can't seem to make it work. I have a simple table with 3 fields. StartTime EndTime ElapsedTime Each field is defined as a date/time datatype. StartTime and EndTime are manually entered. I'm trying to use the DateDiff() function in an update query to populate...

    bonesie15 pointsBadges:
  • TIME String using Variable H (0 to 23) & M (0 to 59)

    Working on project to convert a Microsoft Access database application to DB2 10.1. This my first with DB2. 1st I tried SQL Script SQL Script: INSERT INTO "IBNserv"."ChkMe"("Clt")>>> [Column Clt Data Type TIME NOT NULL DEFALUT 00:00:00] VALUES CAST('12:14:00' AS TIME) STATUS INSERT INTO...

    Apcalogic50 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