+ Reply to Thread
Results 1 to 4 of 4

Problem while creating new field in access

  1. #1
    Registered User
    Join Date
    02-08-2014
    Location
    Chennai
    MS-Off Ver
    Excel office 365
    Posts
    41

    Problem while creating new field in access

    getting below error while executing "db.TableDefs.Append tbd"


    Please Login or Register  to view this content.
    Error msg:
    "Run time error 3367: Cannot append. An Object with that name already exists in the collection"
    Capture.JPG
    Last edited by alansidman; 10-09-2014 at 07:48 PM. Reason: code tags added

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,939

    Re: Problem while creating new field in access

    I think this is in the wrong forum, I will move it to the access forum for you
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    02-08-2014
    Location
    Chennai
    MS-Off Ver
    Excel office 365
    Posts
    41

    Re: Problem while creating new field in access

    hi ford

    i am trying it in excel vba only and field name & field datatype from excel sheet.

    Regards
    Anavarat

  4. #4
    Registered User
    Join Date
    02-08-2014
    Location
    Chennai
    MS-Off Ver
    Excel office 365
    Posts
    41

    Re: Problem while creating new field in access

    any update ????
    Quote Originally Posted by FDibbins View Post
    I think this is in the wrong forum, I will move it to the access forum for you

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Access Field INDEXING Help
    By orozvik in forum Access Tables & Databases
    Replies: 2
    Last Post: 10-01-2014, 05:47 PM
  2. Access VBA to add a primary key (first field) after importing to access
    By ewong in forum Access Programming / VBA / Macros
    Replies: 5
    Last Post: 09-14-2012, 08:57 PM
  3. Replies: 9
    Last Post: 05-22-2012, 08:59 AM
  4. Dynamic Field Name when Import into Access
    By pickledmuffin in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-22-2008, 10:13 PM
  5. [SOLVED] Excel ADO-Bad Field in Access
    By Al in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-10-2005, 08:06 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1