Search results

  1. C

    Who can help me to pick up the last record ...

    Who can help me to pick up the last record in each partially duplicated group? I have an sample input file with two fields, like this: "PRCP","*ALIAS" "PRCP.ACCT.BILLING.SUMMARY.DOWNLOAD","MIGRAT2" "PRCP.ACCT.MUNCIPAL.BILL.DOWNLOAD","MIGRAT2" "PRCP.ACCT.SUMMARY.DOWNLOAD","MIGRAT2"...
  2. C

    Delete Duplicatea query

    Hi, I have a file, which contains many Duplicates in one field. There are 2 situations: (1) full data duplicates in one field. Example : Name Volumn --------------------------- classicbook 2 claasicbook 3 classicbook 1 poembook 1 poembook...
  3. C

    Convert Access 2000 MDB to Access 97 ?

    Hi, Is there any way to convert Access 2000 Database to Access 97 Database? Thanks. Chris
  4. C

    Cross checking on the controls

    Hi, On my form I have a Current status field and a Resolution date field. If the Current status contains a value “Closed”, then the Resolution date field should not be empty. I want to use the following coding: If (Me![cboCurrent].text= “Closed”) And IsNull(Me![txtRdate) Then MsgBox "You must...
  5. C

    How to suppress (or hide)Access Message?

    Hi, Good Evening! For some event, such as On not in list, Access displays 2 messages, which conflict to my message. Is there any way to suppress Access message , or replace its content with mine? Any help will be appreciated. Thanks. Chris
  6. C

    How to copy the current data value in a combo box on one form to a text box on anothe

    Hi, I have a form with 2 combo boxes. Each of them bound 2 columns: ID and Name. They are based on 2 cascading tables. ( I don't want to use the automatic Subform technique). When I double click the second combo, it pops up a form with 3 text boxes on it. One is the box for number field. This...
  7. C

    Where is acDataErrContinue?

    Hi, When I sent a message, I used the following coding in a control's Getfocus event: MsgBox "Double-click this field to add an entry to the list." Response = acDataErrContinue The Access reponded with "Veriable not found" . I check the Action Constant listing. I coundn't find it either...
  8. C

    How to update 6 tables with Parent- Child relationship?

    Hi, I have 6 tables, Table1 to Table6. Table1 is Grand-Grand father and Table6 is Grand-Grand son. Table1 has the fields: ID (PK), Name, Desp. All other tables have the fields: ID (PK), Name, Desp, No (FK). What kind of technique can make this work easily? Can I create a main form for Table1...
  9. C

    Can the Report width be enlargrd?

    I have a report which includes 2 long memo fields. It seems the width of the report is fixed. When I tried to extend the length of the memo field box, the horrontal scroll bar reached its end. I previewed the report; it occupies two and half pages (Landscape orientation). I'd like it to take 3...
  10. C

    Report Generation problem solved -- Thanks to Jack Cowley

    Jack, Received your reply. You’ve solved my problem. I was trying to bring all data into a table and create a report based on that table. Therefore, I must update the table with “ to be displayed” data. You remind me that I can pull all information into a query and then create the report from...
  11. C

    Create a control which contains text on a report?

    I have 2 tables: Business and System. System contains System ID and System_Name Business contains Business ID and System_No They have 1 to many relationship joined by System ID and System _No Now I want to create a Report; this report should display all System_Names from the Business table...
  12. C

    Correct to My last post--BoundColumn Property

    Sorry for my misspelling -- It is BoundColumn Property. Chris
  13. C

    Who knows how to use BondColumn Property ?

    Who knows how to use BoundColumn Property ? Hi, I have 3 cascading Combos. I got them work and stored their IDs -- Column(0) in a table. But I really want to store the text data -- Column(1) to the table. Access Help says, "The BoundColumn Property determines which column's value in the text...
  14. C

    How to store data from Comboboxes to a table?

    Hi, The Problem I stated in my reply post ( 03-02-2003 12:57 PM by croby) has been solved. I found my mis-operation. Now I can store the data values from cboSystem, cboSudsytem and cboMajor to the table called IC. The stored values are ID numbers -- column(0). Can I store the Names --...
  15. C

    How to set a list of values for a Combo box based on a selected value in another Co

    Hi, I’m designing a form by using ACCESS 97. My database includes 3 tables: System, Subsystem and Major. They are linked by their IDs. Suppose the System table has 3 data values: Sys_A, Sys_B, Sys_C. The Subsystem has 10 data values: Sub_1, Sub_2, Sub_3, ……Sub_10. The Major table has 20 data...
Back
Top Bottom