Community discussion forum

Calling an MS Access form using VB

• • Reply

  2 years ago

  by mara011

  H phoumara

  , Cambodia

  Joined 2 years ago

  Hi guys,

   

  How does one call a form created within an Access database using VB6?

  Report abuse
• • Reply

  2 years ago

  by jefftullin

  Jeff Tullin

  , United Kingdom

  Joined 2 years ago

  What you do depends upon whether you want to see the form or use it.

  Try this:

  Dim accObj As New Access.Application
  Dim f As Access.Form
  accObj.OpenCurrentDatabase "C:\db1.mdb", False    'amend to your MDB

  'to display the form for use: 

  accObj.DoCmd.OpenForm "logon", acNormal, , , , acDialog

   

  'or perhaps if you want to make use of the controls on the form... 

  Set f = accObj.Forms("Logon")
  MsgBox f.Controls(0).Name

  Report abuse