Hello everyone.
I am trying to write the code that will open an Access Form when I click a button in a message box through Excel. Right now I am able to open the entire database, but then I have to manualy open the form. Is there a way to open the form from automaticaly? I do not want to use the autoexec macro. because in that database I also have other forms and data that I use on a regular basis, and I do not want to have to close that form everytime I open the main database.
The code I have now is the following:
============================================================
If RunDate = Date Then
Call MakeTotals
Else
Response = MsgBox(Msg, Style, Title)
If Response = vbYes Then
Call Shell("N:\Office97\Office\Msaccess.exe \\SIMVDS02\21000086\JERICO~1\ACCESS\MAINTA~1.MDB", 1)
Else
Sheets("dailytracking"
.Select
Range("a1"
.Select
End If
============================================================
Any help would be appreciated.
Thanks
Shcuck
I am trying to write the code that will open an Access Form when I click a button in a message box through Excel. Right now I am able to open the entire database, but then I have to manualy open the form. Is there a way to open the form from automaticaly? I do not want to use the autoexec macro. because in that database I also have other forms and data that I use on a regular basis, and I do not want to have to close that form everytime I open the main database.
The code I have now is the following:
============================================================
If RunDate = Date Then
Call MakeTotals
Else
Response = MsgBox(Msg, Style, Title)
If Response = vbYes Then
Call Shell("N:\Office97\Office\Msaccess.exe \\SIMVDS02\21000086\JERICO~1\ACCESS\MAINTA~1.MDB", 1)
Else
Sheets("dailytracking"
Range("a1"
End If
============================================================
Any help would be appreciated.
Thanks
Shcuck