Search results

Hi. Thanks for the replies. Now I changed some codes. It's better.The data file has 3 "V00" groups. I want to pick up the name of the group and the last member of the group. My modified codes only pick up one of them: Option Explicit Private Sub Main() Dim strName As String Dim strRemark As...

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

Delete Duplicates query Hi, The data in the tables look jamed. For the first situation, there 2 fields: Name and Volumn. For the 2nd situation, there are 2 fields: Filename and Remark. Chris

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, Thanks very much. Your coding works. I was so glad to see the term "acDataErrContinue ". What is acDataErrContinue ? I have been searching for its resource. I thought it was an Action constant, but I can not find it on the Action Constants list. I made a post 3 days ago. No one gives an...

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, thnaks for the prompt reply. I inserted your codes into my Double click event procedure. I don't know what's wrong. It couldn't find the form( 2nd, opened form). Can you tell me what's wrong? Private Sub cboSubsystem_DblClick(Cancel As Integer) On Error GoTo Err_cboSubSystem_DblClick...

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

Thanks for all replies. I coded several events. I gave the event was not correct (sorry!). The code was in the NotInlist event. I copied it from a sample: Private Sub cboResolve_NotInList(NewData As String, Response As Integer) MsgBox "Double-click this field to add an entry to the list."...

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

Linking cascading tables Hi, Thanks for the reply. I’ve read your SelfReferencing. It is a very special one. But I don’t know how to apply your technique to my case. I have 6 tables, non of them has a field in their parent except the FK. For these six tables I use cascading combo boxes on the...

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

Why I use only IDs in the main table .... Thanks to Wayne's reply. Actually my production data contains not just a System field. It has 6 fields with field length of 35 to 50 Chars. And other long fields (memos) too. Using names in the Business table will signficantly increase the record...

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