User Profile

Collapse

Profile Sidebar

Collapse
mver22
mver22
Last Activity: Jan 17 '17, 07:33 PM
Joined: Jun 17 '10
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • mver22
    replied to Access - create table DAO - but table not found
    in Visual Basic
    create dao table - closed

    Code does work as I submitted it. vb5prgrmr is correct about where to look (main access DATABASE window, tables section).

    Problem is that new table did not show there until I reopened Access the next time. Neatly confusing!

    Thank you. Case closed.
    See more | Go to post

      Leave a comment:

    • mver22
      started a topic Access - create table DAO - but table not found
      in Visual Basic

      Access - create table DAO - but table not found

      In access .mdb I want to create a new table with 5 fields.
      Code is like:
      Dim db As DAO.Database
      Dim tdf As DAO.TableDef
      Dim fld As DAO.Field

      Set db = CurrentDb()
      Set tdf = db.CreateTableD ef("t_comps2")
      With tdf
      Debug.Print "Count of fields is: " & tdf.Fields.Coun t
      ' create the fields =========
      Set fld...
      See more | Go to post
      No activity results to display
      Show More
      Working...