• Data Changing when closing an Access 2003 form

    I have a form in Acess2003 with a subform, the subform is linked on two fields, name and date. If I close the form when my master form is on the first name in the combox everything works fine - If I close the form not on the first name in the combo box, then whatever name it is on gets the date of...

    Nainey455 pointsBadges:
  • Query that uses input data from another form

    OK..I need to query a data form that is set to extract data from one table, but I have other fields on the same form that needs to extract data from another table. I have a query that I intend to use to reference the data I need...but my question is what is the syntax to make this happen. Here is...

    DaChosenOne5 pointsBadges:
  • Trying to run remote command to view AS/400 UNC and failing!

    I need some ideas here...I'm stuck. I'm running an RPG program that builds some CSV files for our accounting department. Because they love Excel, I had to make it so that the program breaks the data up into separate CSV files so as not to exceed 65,535 rows. Anyway, I am saving the stream files...

    Koohiisan5,020 pointsBadges:
  • Joining 3 tables in SQL Server 2005

    Here are the 3 simple SELECT queries i have but i want to merge them all into 1 singl query.

    Macha19735 pointsBadges:
  • Using IBM System i Access can I replace zeros with blanks in a downloaded CSV file?

    Hi, I have a simple file transfer from my iSeries(AS/400) to a CSV file.  I have a numeric field with 2 decimal places.  The file is sent to an outside agency.  They need zero values to contain blanks.  Is there a way to do this? Thanks for your help.  

    BCF5 pointsBadges:
  • SQL Query to consolidate rows into new table

    Hi again, I have another query to get my head around! I am trying to take an existing table in a database that looks like this Time Type Price Code 09:00:01 BID 99 A 09:00:01 ASK 100 A 09:00:01 BID 99.5 B 09:00:01 ASK 100 B 09:00:02 BID 99.3 A 09:00:03 BID 98.5 C 09:00:03 ASK 99 C and put into...

    Baatch20 pointsBadges:
  • SQL Query to get the difference from average for every row with grouping

    Hi there, i was wondering if anyone would be kind enough to help with something i am struggling with... I have a table something like this: Region ID Cost s1 1 v1  s1 2 v2  s1 3 v3 s2 4 v4 s2 5 v5 s2 6 v6 What I am trying to achieve is to get a result set that looks like this using a single query...

    Baatch20 pointsBadges:
  • Standby Database Server

    I am using oracle 10g and I want to use a standby database for high availability of my database. I did almost everything; but I don't know how a user can connect to the standby server when the primary has failed. This is my connection string "Data Source=(DESCRIPTION = (ADDRESS_LIST = (ADDRESS =...

    Girma30 pointsBadges:
  • Error using CPYFRMIMPF

    I have a .CSV file that contains a header record and then several detail records (random number as it is the EDI invoices). I use the CPYFRMIMPF to copy the first record to the header file and then I do it again for record 2 to *end. The problem is that it will copy the header fine but then it will...

    Cooking5 pointsBadges:
  • ID_NO INCREASE VBA ACCESS 2007

    PLEASE TELL ME HOW TO INCREASE ID_NO THROUGH VBA CODE IN ACCESS 2007

    AnandaDebnath280 pointsBadges:
  • How to enter a field with number increments in Access 2007

    How to increment a number field adding 3 with the number from the same field of the previous record. (like entering next invoice number)

    SatbirBlog15 pointsBadges:
  • Combine (concatenate?) in Access~special circumstances

    Hi, I need to be able to combine (concatenate?) fields in Access so that each item in Field 1 is joined to each item in Fields 2 thru 5. I have tried to illustrate this in the samples below... In the samples below, Account code is in Field 1... String(s) to be added are in Field 2. Then in Field 3...

    Matchmole5 pointsBadges:
  • odbc question

    what odbc driver you use to go from system-i to sql2005 i sue IBMDA400 but does not handle pack fields very well any suggestions?

    Colo20055 pointsBadges:
  • Access 2007: Create a form for both display and data entry purposes

    How can I create a form that is autofilled with data from a query (such as a client's ID and balance), and will also be used for data entry for another field from a table not part of the query (the amount paid by the client and the current date)? I tried to use a subform for the data entry but (a)...

    Deej185 pointsBadges:
  • Dummying a dataset with a concatenated list of datasets

    I have an input of 6 contactenated files and I wish to process with just the 4th file in the list. Will dummying the first 3 and last two still pull in the 4th dataset or by dummying the first in the list in effect dummy all of the inputs in the list? Does the dataset you wish to process need to be...

    Jaharvis15 pointsBadges:
  • How to remove Microsoft Foxpro Title bar

    How to remove Microsoft Foxpro Title bar from the main screen in FPW2.6

    Tanvirac5 pointsBadges:
  • What is wrong with this database search query?

    searchStr =|FIELD Form =Form1  & FIELD CallsBeginDate >= | &  Trim(Cdat(doc.DeleteStartDate(0))) &  |  &  FIELD CallsEndDate <= | &  Trim(Cdat(doc.DeleteEndDate(0))) & | & FIELD Team =| & Trim(doc.OnCallTeam(0))&|| I have used with NotesDocumentCollection. Thanks for any feedback  

    ALK125 pointsBadges:
  • iSeries Update Values in a Table Based on Values in Two Tables.

    I want to update a Client Category Code in the Client_Table where the Client has a specific Country Code AND and the Clients VAT No is Blank, Which is in The Client_Account Table in another Library. The Matched Records are [LIBRARY1]FILE1.CLLDRS and [LIBRARY2]FILE2.ADLDRS So Update...

    Sconna2325 pointsBadges:
  • Javascript code

    Hi, I'm looking for an IF function code,,, My condition is IF I TYPE THE WORD "MOD" in a CHAT BOX THEN I want this MOD WORD TO APPEAR IN GREEN COLOR. I would like to know the code which I can embed for this to happen? thanks!

    SaraKhan5 pointsBadges:
  • Change the size of a column and then reorganize the rows in SQL tables

    I think this one will be tricky. What I have is a table like: CREATE TABLE PHOTO_DETAIL   (     "PHOTO"        VARCHAR2(25 BYTE) NOT NULL ENABLE,     "NUM_LINE"   NUMBER(20,0) NOT NULL ENABLE,     "PHOTO_LINE"  VARCHAR2(180 BYTE)   )   what I am going to have is: CREATE TABLE...

    Hispi25 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