Open a form from another database

[GD]

How would I open a form from a different database via a macro? Can it be
done within RunApp, or is there another step?

The other database's path is S:\HQ
Common\DC_Finance\DATA_ANALYSIS\PAYBACKS\CM-DM Downloads.mdb

The form name is frmCMLabelsDataEntry.

Thanks!!!!!!

 

[Daniel Pineault]

Using some automation (Read the Access VBA Help articles on
"GetObject Method" and "CreateObject Method" for more information) you can
achieve this. Try something like

Function OpenExDdForm(sDb As String, sForm As String)
On Error GoTo Error_Handler
Dim appAccess As Access.Application
' Create new instance of Microsoft Access.
Set appAccess = CreateObject("Access.Application")
' Open database in Microsoft Access window.
appAccess.OpenCurrentDatabase sDb
appAccess.Visible = True
' Open the form.
appAccess.DoCmd.OpenForm sForm
'...do what ever you want

'When we are done clean up our variables.
Set appAccess = Nothing

If Err.Number = 0 Then Exit Function

Error_Handler:
MsgBox "MS Access has generated the following error" & vbCrLf & vbCrLf &
"Error Number: " & _
Err.Number & vbCrLf & "Error Source: OpenExDdForm" & vbCrLf & "Error
Description: " & _
Err.Description, vbCritical, "An Error has Occured!"
Exit Function
End Function

Then you'd call it:
OpenExDdForm("S:\HQ Common\DC_Finance\DATA_ANALYSIS\PAYBACKS\CM-DM
Downloads.mdb", "frmCMLabelsDataEntry")
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.

 

[GD]

Thanks, Daniel. But is code necessary? I'm not that familiar with it + my
boss wants it used as little as possible in our databases.

Right now I can open the target database with this in the RunApp command line:
"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "S:\HQ Common\DC
Finance\DATA_ANALYSIS\PAYBACKS\CM-DM Downloads.mdb"

Is there no easy way to get it to open the specific form at that point?

 

[Steve]

Open your S:\HQ Common\DC Finance\DATA_ANALYSIS\PAYBACKS\CM-DM
Downloads.mdb. Click on Tools - Startup and set frmCMLabelsDataEntry as the
startup form. Close the database. Now any time you open that database, your
form should automatically open. So when open the target database with the
RunApp command line, your form in the target database should automatically
open.

Steve
(e-mail address removed)

 

[Daniel Pineault]

Another option would be to create a macro that opens the form in question and
then uses command line switches to execute that macro.

see:
http://support.microsoft.com/kb/209207
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.

 

[GD]

Thanks for the thought, Steve, but I already have another form in that
database that needs to stay as the StartUp form. Any other thoughts?