Hi all,
I'm using access as a back end to my vb project. I'm opening reports i created in access. The only problem is that when i view a report Microsoft Access opens as well. Is there any way to hide this window. Here is what i'm doing.
Const strPassword = "123"
Dim Acc As Object, db As Object
Dim dbPathName As String
dbPathName = App.Path & "\EuroGlobaldb.mdb"
Set Acc = CreateObject("Access.Application"
Set db = Acc.Application.DBEngine.Workspaces(0).OpenDatabase(dbPathName, 0, False, ";pwd=" & strPassword)
Acc.OpenCurrentDatabase dbPathName, False
Set db = Nothing
Acc.Visible = True
Acc.DoCmd.OpenReport "clients", acPreview, , acWindowNormal
Set Acc = Nothing
I'm using access as a back end to my vb project. I'm opening reports i created in access. The only problem is that when i view a report Microsoft Access opens as well. Is there any way to hide this window. Here is what i'm doing.
Const strPassword = "123"
Dim Acc As Object, db As Object
Dim dbPathName As String
dbPathName = App.Path & "\EuroGlobaldb.mdb"
Set Acc = CreateObject("Access.Application"
Set db = Acc.Application.DBEngine.Workspaces(0).OpenDatabase(dbPathName, 0, False, ";pwd=" & strPassword)
Acc.OpenCurrentDatabase dbPathName, False
Set db = Nothing
Acc.Visible = True
Acc.DoCmd.OpenReport "clients", acPreview, , acWindowNormal
Set Acc = Nothing