Open Form another database - Urgent

[Guest]

Hi,

Thanks in advance.

I am in a form on a database and I need to open another form but it is in a
different database.

If it is possible please let me know how I would go about it in coding.

Thanks


Trev

 

[MacDermott]

You could try adding your second database as a reference.

 

[Guest]

How do I add a second referance?

You could try adding your second database as a reference.

 

[PC Datasheet]

This will do it ---
Put the following code in the click event of a button or in some other
appropriate event:
Dim SecondApp As Application
Set SecondApp = New Access.Application
SecondApp.OpenCurrentDatabase <Full path to second app here>
SecondApp.DoCmd.OpenForm "MyForm"

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com

If you can't get the help you need in the newsgroup, I can help you for a
very reasonable fee. Over 1000 Access users have come to me for help.
Need a month calendar or 7 day calendar? Need appointment scheduling? Need
room reservations scheduling? Need employee work scheduling? Contact me!

 

[StopThisAdvertising]

If you can't get the help you need in the newsgroup, I can help you for a
very reasonable fee. Over 1000 Access users have come to me for help.

These 1000 (if at all a real figure..) is only the result of
-- 4 years abusing the newsgroups.
-- 4 years blatantly advertising and job hunting.

You only care about making money, and you act as if the groups are your private hunting ground.
So why would ANYBODY ever trust a person like you and hire you?
********************************************************

Need a month calendar or 7 day calendar? Need appointment scheduling? Need
room reservations scheduling? Need employee work scheduling? Contact me!

Need a psychiatrist ...Contact me!

Arno R

 

[PC Datasheet]

Why don't you take Salad's advise and grow up and get a life and quit
sending emails to my office.

"If you have anything to contribute to the group, contribute. Your war
with Datasheet is simply pissing and moaning in the wind for the sake of
nothing. Grow up and get a life."

Salad

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com

If you can't get the help you need in the newsgroup, I can help you for a
very reasonable fee. Over 1000 Access users have come to me for help.
Need a month calendar or 7 day calendar? Need appointment scheduling? Need
room reservations scheduling? Need employee work scheduling? Contact me!

If you can't get the help you need in the newsgroup, I can help you for a
very reasonable fee. Over 1000 Access users have come to me for help.

These 1000 (if at all a real figure..) is only the result of
-- 4 years abusing the newsgroups.
-- 4 years blatantly advertising and job hunting.

You only care about making money, and you act as if the groups are your
private hunting ground.
So why would ANYBODY ever trust a person like you and hire you?
********************************************************

Need a month calendar or 7 day calendar? Need appointment scheduling? Need
room reservations scheduling? Need employee work scheduling? Contact me!

Need a psychiatrist ...Contact me!

Arno R

 

[WSF]

Hello Steve,
I've been a way a few days and I see you have been busy.
I've not come across Salad before - is it you?
I notice that there seems to be a trend in your selective responses to
posts - you know, the ones you get to before anyone else - most of the
posters are female? And you are strong on dates? Or is it you self
posting again?

You're the piss-off STEVE!

Stop stalking the newsgroups.
Stop your blatant bullshit advertising, and the rest of us will
appreciate your contributions for what they should be.
Cut the crap about your thousand ?? satisfied customers - just leave
your card - okay?