Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have this piece of code that worked fine but I had the line to close the
Switchboard form and it doesnt work. App.Application.docmd.closeform "Switchboard" The Error states Object doesn't support this property or method. Any help would be appreciated! Code is has follows 'Open a form in Access Dim App As Object Set App = GetObject("\\Dtcnas-ilsp002\mandatory\Volume.mdb") App.Application.docmd.closeform "Switchboard" App.Application.docmd.openform "Form" -- ca1358 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
You might get better info in the Access group, but I think your problem is
that there is no docmd.closeform in Access; the proper form of the statment would be: App.Application.DoCmd.Close AcForm, "Switchboard" -- - K Dales "ca1358" wrote: I have this piece of code that worked fine but I had the line to close the Switchboard form and it doesnt work. App.Application.docmd.closeform "Switchboard" The Error states Object doesn't support this property or method. Any help would be appreciated! Code is has follows 'Open a form in Access Dim App As Object Set App = GetObject("\\Dtcnas-ilsp002\mandatory\Volume.mdb") App.Application.docmd.closeform "Switchboard" App.Application.docmd.openform "Form" -- ca1358 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Close User Form | Excel Discussion (Misc queries) | |||
HELP! - SWITCHBOARD NEEDED | Excel Discussion (Misc queries) | |||
Switchboard for excell | Excel Discussion (Misc queries) | |||
how to close a form in vba (not hide) | Excel Programming | |||
Close Form with VBA | Excel Programming |