Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2002

    Unanswered: Connecting using VBA...

    Hey you'll I was wondering if there is a way to open and download data from a serial port using VBA in Access, or am I a lost sheep? Also does any body know how to make code display the names of tables in a database on a fomr?

  2. #2
    Join Date
    Jul 2003

    Re: Connecting using VBA...

    Can't help on the serial port bit, but the code below will list tables in the current database. Replace debug.print with the name of your control on your form.

    Sub ListTableNames()
    Dim accObject As Access.AccessObject

    For Each accObject In CurrentData.AllTables
    Debug.Print accObject.Name
    End Sub

Posting Permissions

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