Search results

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"...

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...

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

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...

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

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...

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...

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...

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...

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...

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...

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

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...

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 --...

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...