• Access 2007: VB Code for making a Select all Option

    Currently running an Access 2007 database for tracking forms used in multiple States trying to add a Select all button instead of having to go through and select each individual state (the States are populated from a different table and in a drop down multiple selection window)

    RustyAMcM15 pointsBadges:
  • Query for a Mail Merge

    When I access my Auction Query in Access I can pull it up and everyone is there. When I try to do a mail merge and pull up my auction query all the other queries are there except the auction query.

    4hcandles5 pointsBadges:
  • DB2/400 count physical file record

    how to count the physical file records using RPGLE program....

    pdsathishkumar3,790 pointsBadges:
  • IL3

    Looking for a template / checklist to assist in IL3 implementation

    Oggy5 pointsBadges:
  • DB2/400 delete record

    how to delete record using UPDDTA command...

    pdsathishkumar3,790 pointsBadges:
  • Missing Record

    why would a record not appear in a report when it has the correct criteria

    Nationalgrid15 pointsBadges:
  • DB2 Recursive UDF

    I am looking to create a SQL table UDF on my AS400(v5r2) that will return a listing of suboridinates for a given manager. Is it possible to use recursion? Since we are on v5r2 recursive SQL is not an option

    jen19815 pointsBadges:
  • how to perform a distinct count on a record over 2 sub reports

    hi all, i have a report returning list where it is grouped by city. it contains fields: ID (each record has unique id), serial(each client will have a serial to idenfy a person)group1 (A<B<C<D) and group2(A<B<C<D)and group date each client can have multiple entries based on how...

    N7865 pointsBadges:
  • Multiple Selection in Combo Box in MS ACCESS

    Hi EveryOne, I am trying to change the Combo Box for multiple section as YES in MS ACCESS.In my Form there are 64 Combo Boxes .I would like to apply same requirement for all Combo Boxes. Combo Box data Resource is getting by a query from a table which have one Id(Primary Key Column) and Name...

    Maheswarreddy45 pointsBadges:
  • Pull up a list of the last time the person took each course set-up in the system

    I have a training database and I can easily pull up a report of all dates a person took courses but I would like to just get a report of the last time a person took each course. I do not want multiple listing of a course.

    Grainna5 pointsBadges:
  • Double Byte Data from Db2 to a flatfile

    Hi, I have a DB2 table which consists of the double byte data like japanese or chinese , if i write a cobol program to get a extract from the DB2 Table will the flat file show chinese data as chinese or some junk values ... If its showing some junk values how can it be shown in original shape are...

    MFDB25 pointsBadges:
  • Access 2007 IIf function in a query

    Please excuse my noobness but I am new to Access and rarely work with it. How do I replace the data in 1 field with the data of another field, if any data exists in the 2nd field? I suspect IIf would be the best way but I get 'NewID: IIf([OffenderID]="0000000000000",[ForeignID],"0000000000000")' is...

    Riaane65 pointsBadges:
  • Access 2003 Chart creation, scatter plot

    I am looking to create a scatter plot in Microsoft Access with independent x and y values. For example: x       y 0.3035 0.3300 0.3023 0.3249 0.3032 0.3283 I can't seem to find a good way to do this within Access... Any help is greatly appreciated.

    Apog5 pointsBadges:
  • getting ORA-01422: exact fetch returns more than requested number of rows. while setting up UK bank branch

    Hi All iam getting ORA-01422: exact fetch returns more than requested number of rows. while setting up UK bank branch. Please,let me know if someone faced the similar issue. Thanks Priya

    Pdweep15 pointsBadges:
  • Tie Access Query results to Form Entry

    I am attempting to run a calculation based on the numerical values entered into the form. The end result would be to include the numerical value entered into the form as an item in a query equation calculation. Any help you can provide is greatly appreciated.

    LostinAccess5 pointsBadges:
  • Exporting a (.csv) file from SQL 2005

    Hi, I'm trying to export date to a (.csv) file from SQL 2005 and I keep getting a carriage return and line feed after each record. I have been told that this may be because it is getting exported in Unicode rather than ASCII. I do not have reporting services on my box. I have heard that there is a...

    Jeager6640 pointsBadges:
  • Access 2007 DB Project

    Hello, I am setting up a database for a small airline. I have an 'Aircraft_Table' with the fields:

    PhilipG5 pointsBadges:
  • Replace data in a text file using Access 2007

    I need to replace data in a fixed length text file where the line number and position is always the same. Can anyone offer advice on this? Thanks in advance!

    rikkos12310 pointsBadges:
  • personal storage disabled?

    I get this message,"Pst (Personal storage) usage is disabled on this computer" when I try to import my personal files from Office 2003. Previously an Exchange program had been installed - I'm trying to disable it.

    Bolchad5 pointsBadges:
  • oracle

    how to find the difference between structure of the table?

    GOBIKKANNAN5 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