By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,978 Members | 1,467 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,978 IT Pros & Developers. It's quick & easy.

Opening access form from VB

100+
P: 123
Hi,

Can anyone tell me how to open an access form from VB when access database is closed?

Form gets open when database is open but I want code to open access form when database is closed?
Apr 4 '07 #1
Share this Question
Share on Google+
4 Replies


vijaydiwakar
100+
P: 579
Hi,

Can anyone tell me how to open an access form from VB when access database is closed?

Form gets open when database is open but I want code to open access form when database is closed?
pls clear it
Apr 4 '07 #2

100+
P: 123
pls clear it

See, I have one form designed in MS Access. Now I want to open that MS Access form from VB. When I click on command button, MS Access form should open. Access form opens from VB only when access database is opened. i.e. I have to keep my database open then n only then I am able to open an Access form from VB.

If database is closed, i am not able to open an form. I want code of that, How to open an access form from VB when my access database is closed?

If u know, plz let me know
Apr 6 '07 #3

Dököll
Expert 100+
P: 2,364
See, I have one form designed in MS Access. Now I want to open that MS Access form from VB. When I click on command button, MS Access form should open. Access form opens from VB only when access database is opened. i.e. I have to keep my database open then n only then I am able to open an Access form from VB.

If database is closed, i am not able to open an form. I want code of that, How to open an access form from VB when my access database is closed?

If u know, plz let me know
Hello, Shailja!

Sounds like you can really use some help, please stay tuned...

I could be totally off base with this but, I think VB does not know where to look if an Access database is open. The whole database must be closed, as far I as I can remember, for VB to open/delete/add/update data to it. Again, things may have changed, and I've missed it. Nonetheless, if your VB code is unable to see your report, please add it here so one can take a closer look. I have seen a wonderful tutorial somewhere, should help get you started. With your coe posted I or truly helpful members here will likely help you tackle the task. Please let us know.

In a bit, Shailja!

Dököll
Apr 10 '07 #4

Expert 5K+
P: 8,434
See, I have one form designed in MS Access. Now I want to open that MS Access form from VB. When I click on command button, MS Access form should open. Access form opens from VB only when access database is opened. i.e. I have to keep my database open then n only then I am able to open an Access form from VB.

If database is closed, i am not able to open an form. I want code of that, How to open an access form from VB when my access database is closed?

If u know, plz let me know
If you're saying that you don't want the database to be opened, then I don't think it's possible.

If opening the database is alright, then the Microsoft Access Object Library should provide a way to do this.
Apr 10 '07 #5

Post your reply

Sign in to post your reply or Sign up for a free account.