Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Running an Access Form from Excel using VBA

Status
Not open for further replies.

shcuck

Programmer
Dec 10, 2002
10
US
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top