Linked Database (1 Viewer)

[syedadnan]

Regards,

I would like to know and get help in the context that i have a completed DB with forms table reports and module, now i created another DB with nothing in it else only a single form, i want to create command buttons on this form and on click of button the form from the previous DB to be open ...

 

[Ranman256]

create a new db
create the form in it
link all tables you need from the other db.

 

[CJ_London]

there is probably more than one way to do this but the following code will open the other database


Shell """" & SysCmd(acSysCmdAccessDir) & "msaccess.exe" & """" & " " & """" & PathAndNameOfDB & """", vbNormalFocus

If you want a specific form to open, then you need to set a macro to open that form and then call it with the appropriate command line parameter - see here for more info

https://support.office.com/en-us/ar...r-Access-558cfe1d-3c98-4292-bee8-1f5df9702bf1

another method can be found here

https://www.experts-exchange.com/questions/26803401/Access-Button-to-open-another-database-Form.html