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

automation confusion

P: n/a
HI - I am coding in access 2003 - but the database is in access 2000 format.
I have a 'menu' form that contains buttons that transfer the user to other
databases in the system. I am using VBA to do the transfer and am using
create object, opencurrentdatabase, and openform commands. The program works
beautifully on my computer - xp server -- but as soon as I move it to another
computer (xp) I cannot get the secondary databases to open. Problem is that
when a button is clicked - the screen flashes - but nothing else -- then I
find that an additional copy of msaccess.exe shows up in the windows process
links - but I cannot get the db to show up.......I hope I explained this
somewhat clearly.......I am wondering if the issue could be the references
checked on my development system - or the fact that I am using 2000 format on
a 2003 system. any help would be greatly appreciated.......thank you in
advance.
Bev A.
May 1 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On Mon, 01 May 2006 15:32:24 GMT, "bev a" <u21403@uwe> wrote:

That's because it's not visible. Try this:
set obj = CreateObject(...)
obj.Visible = True

-Tom.

HI - I am coding in access 2003 - but the database is in access 2000 format.
I have a 'menu' form that contains buttons that transfer the user to other
databases in the system. I am using VBA to do the transfer and am using
create object, opencurrentdatabase, and openform commands. The program works
beautifully on my computer - xp server -- but as soon as I move it to another
computer (xp) I cannot get the secondary databases to open. Problem is that
when a button is clicked - the screen flashes - but nothing else -- then I
find that an additional copy of msaccess.exe shows up in the windows process
links - but I cannot get the db to show up.......I hope I explained this
somewhat clearly.......I am wondering if the issue could be the references
checked on my development system - or the fact that I am using 2000 format on
a 2003 system. any help would be greatly appreciated.......thank you in
advance.
Bev A.


May 2 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.