Links (1 Viewer)

[ssworthi]

I want to have my users have a button on my main form in my one data base be able to open another data base;(other database main form has all the buttons they need for the functions they want)is that possible?

 

[GinaWhipp]

You can use...

Application.FollowHyperlink FilePath

 

[ssworthi]

Thank you so much Gina. Do I accomplish this in a button on my form and is it in the properties and written in SQL? I am very new to SQL and learning by the seat of my pants as it were. Thanks for all your help.

 

[GinaWhipp]

Yes, you put that line in the On_Click event of your button. Where it says *FilePath* you would put the file path the databse you want to open.

 

[ssworthi]

Thank you so very much! I will try that now.

 

[ssworthi]

Does this look right?
FollowHyperlink \\bcohome\enterprise\ORCH\groups\Database\Attendance\Attendance.accdb

I'm getting a "Compile error: Syntax error" and the above is highlighted in red.

 

[GinaWhipp]

You need...

Application.FollowHyperlink "\\bcohome\enterprise\ORCH\groups\Database\Attendan ce\Attendance.accdb"

...also, is there a space in Attendance?

 

[ssworthi]

You're right; there was a space and there should not have been. It works! It's great, thank you so very much!

 

[GinaWhipp]

You're welcome!