ni.com is currently undergoing scheduled maintenance.

Some services may be unavailable at this time. Please contact us for help or try again later.

LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Opening forms in MS Access

I have created a LabVIEW program that launches MS Access. I would
like to be able to automatically open different MS Access forms in the
same database depending on conditions in the program. How do I tell
MS Access to open a form from within LabVIEW?

Any help is greatly appreciated.

SK
0 Kudos
Message 1 of 3
(2,990 Views)
I haven't personally done this but I would suspect that there is an ActiveX property somewhere that would allow you to do this. I would poke around MS Access' help and MS' website for any info you can find on ActiveX stuff in Access.
0 Kudos
Message 2 of 3
(2,990 Views)
If you call Access by command line:
create 2 macros to display 2 forms in Access, then use "c:\prog... ...\msaccess.exe" /x macro1|macro2 in Shortcut or bath file
Other way is /cmd as last parameter in command line and form as startup in Access project

As ActiveX Object in LabView:
Open(Access._Application).Forms.Item(Form1).Visible = true ...
Ofcource OpenDB is also required!
0 Kudos
Message 3 of 3
(2,990 Views)