Opening a form

[jo15765]

Is it possible to open a Visual Studio Windows Form Application, as your "startup" form when Access starts? If so, how would I begin to do this?

[ajetrumpet]

the question is, WHY?

[jo15765]

Yet again, I am trying to decipher how a database that someone else designed works. And there is a form that opens @ startup, but if I go to tools, startup, and look for a startup form there isn't one specified. So, my thought process was, maybe they have a VSFA opening and running once Windows Opens.

Maybe not even possible, Maybe not even the case! Just curious if it is possible, and if so, how to find out. I tried to run a dependency analyzer (Dependency Analyzer is what it is called) to find out, and unfortunately, it can not even complete running until it tells me that the computer is out of memory, so I am SOL on that one.

[Rod]

... er - sorry to butt in. Have you looked for a macro called 'autoexec?'

[jo15765]

No, I haven't. I haven't quite understood how to read/decipher macro's. I usually convert them to a vb procedure, and follow the code there, but I recently found out that is not actually a good idea to do.

[Rod]

What I meant is that the legacy way of displaying a form at start-up is to code a macro called 'autoexec' to display that form.

[jo15765]

I looked at the auto-exec macro and it is calling a form to open at startup, but that form is not in the database that it is opening in. I don't see in the macro a location of where it is calling the form from either?!

[boblarson]

I looked at the auto-exec macro and it is calling a form to open at startup, but that form is not in the database that it is opening in. I don't see in the macro a location of where it is calling the form from either?!

Perhaps the form is HIDDEN. You would need to right click on the Navigation Pane at the top just above the part which you select which objects you like to see and select PROPERTIES. Then make sure the SHOW HIDDEN checkbox is checked.

[jo15765]

If I right click on the blue directly above where it shows where it shows my objects, I get an option that says database properties, which has tabs --- General, Summary, Statistics, Contents, Custom --- I don't see a show hidden check box on any of those tabs?

[boblarson]

If I right click on the blue directly above where it shows where it shows my objects, I get an option that says database properties, which has tabs --- General, Summary, Statistics, Contents, Custom --- I don't see a show hidden check box on any of those tabs?

Oops, sorry. I somehow mistook your Access 2000 for 2007. So, it would be at TOOLS > OPTIONS and then on the view tab.

[jo15765]

Ah, that was it! Now I can see the form that is being called at startup! Now only if I can figure out what it requires to run all of it's functions!!