Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2003
    Posts
    280

    Unanswered: How do you filter out the field that has a space in it?

    For example:

    TABLE: Case Records
    Field: Name, Case Number, InsuranceCarrier

    mwcas.Filter = "Case Number", conndb, adOpenKeyset, adLockBatchOptimistic, adCmdTable

    The error: Object required.

    I have put brackets and parathesises around the field name but it didn't works. What else I can do?

  2. #2
    Join Date
    Jun 2004
    Posts
    92
    Quote Originally Posted by lansing
    For example:

    TABLE: Case Records
    Field: Name, Case Number, InsuranceCarrier

    mwcas.Filter = "Case Number", conndb, adOpenKeyset, adLockBatchOptimistic, adCmdTable

    The error: Object required.

    I have put brackets and parathesises around the field name but it didn't works. What else I can do?
    Example of why it is a bad practice to use names for objects that contain spaces. You should use as an alternative, casenumber. If your die hard on it having a space then use [Case Number].
    Last edited by sionus; 08-25-04 at 18:22.

  3. #3
    Join Date
    Apr 2003
    Posts
    280
    I didn't create the tables, someelse did before I came here to work. But I have tried it with a brackets, it doesn't works.

  4. #4
    Join Date
    Oct 2003
    Posts
    706
    Syntax may be "[Case Number]"
    ChimneySweep(R): fast, automatic
    table repair at a click of the
    mouse! http://www.sundialservices.com

  5. #5
    Join Date
    Jul 2004
    Posts
    56
    Try Case_Number

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •