Open form in Access with web page...

[JHDavis]

While Access is running, can I have a web page that when a button is clicked it will open the form in Access (not in the browser)?

 

[WildHare]

That DEPENDS on where your web page is running.

You can insert a HYPERLINK that opens an Access database, but I'm not sure how you'd tell the page where the database is - I just tried it with a simple Word document on my PC , tossed in a hyperlink to a database and viewed the doc in "Web Page Preview" - worked just fine when I clidked the hyperlink text.

BUT, if you put this document on a web server, I'm not sure how it would react. And I can't test that at the moment.

SO, the answer is, if the web page is "local", e.g. on your disk or a network share, you should be able to get it to work. But if the web page is 'served' to a browser by IIS or Apache or something like that, it might not.

Jim

Me? Ambivalent? Well, yes and no....
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare2.htm

 

[JHDavis]

Assuming the database is open already, and like Jim said, both are on a local disk, can I hyperlink to a form within the database?

 

[WildHare]

Yes you can. Use the /CMD command-line argument option, and pass it the name of a form you want to open.

"C:\Program Files\Microsoft Office\Office\Samples\Northwind.mdb" _
/cmd "Orders"

then, write a small function that checks the value of the COMMAND argument:

Function CheckCommandLine()
' Check value returned by Command function.
If Command = "Orders" Then
DoCmd.OpenForm "Orders"
ElseIf Command = "Employees" Then
DoCmd.OpenForm "Employees"
Else
Exit Function
End If
End Function


Stick a call to this function in the AUTOEXEC macro, and you should be all set.

The above is lifted from Access Help on Command-line arguments, and the COMMAND function.



Me? Ambivalent? Well, yes and no....
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare2.htm

 

[JHDavis]

Thanks!

I very much appreciate your pointing me in the right direction.

John