URGENT: Spllting a form

[Noreen]

I also forgot to mention that the form MUST be opened before running the code.

It works once you open the Training Done form first but this is not what I wanted as I have a button in Prog_Report to open Training Done Report

is there anyway I can stop this or do I have to develop a macro to open training done form first?

As the button has now become useless apart from opening it afterwards

 

[Noreen]

Hi, just going on lunch I promise I will try whatever you suggest when I come back - Thanks a million for all your help

You're a star bar

 

[vbaInet]

You cannot refer to a form that is not open so yes you must have the Training Done form open before opening your other form. However, you call it a report?

 

[Noreen]

I autoexcued it to open with a macro so it opens so that's solved.

However, this is bringing up the training done FORM first is there anyway in a macro to assign which form opens first?

Also it is only the way we describe the form it is NOT a report


Thanks a whole bunch for all your help.

Star Bar Executive

 

[vbaInet]

Change the sequence of events in the macro, it starts from top down.

You can also change the Window mode of the form to open as Hidden. Look into that.

 

[Noreen]

Change the sequence of events in the macro, it starts from top down.

You can also change the Window mode of the form to open as Hidden. Look into that.

Perfect, you wouldn't know how to do that by any chance?

Thanks a million!

 

[Noreen]

Nevermind I found it! Thank you Can I give you a good rating or something?

 

[vbaInet]

Look in the macro options. There should be something like Window mode under that OpenForm macro action.

I don't use macros so I'm not entirely sure what it's called.

In code it would look like this:

Docmd.Openform "Name of Form",,,,,acHidden

But remember to close the form after or before closing the other form.

 

[vbaInet]

Nevermind I found it! Thank you Can I give you a good rating or something?

I was a bit slow there then

If you feel so inclined then please do Click on the Scales at the top right hand corner.

Glad we could help.

 

[Noreen]

I was a bit slow there then

If you feel so inclined then please do Click on the Scales at the top right hand corner.

Glad we could help.

Haha Yea, I've learned a lot this morning, more than a days training at the training center!

Fantastic forum to get help from

Forgot to say: You should be star bar named

 

[vbaInet]

We do what we can, when we can.

Sounds like a good slogan for an advert

 

[Noreen]

We do what we can, when we can.

Sounds like a good slogan for an advert

Haha, it does now that Ive read over it again!!!

One last question before I leave you be!

I created a button in the db is there anyway I can give a description if someone overs over this button with their mouse?

I have been trying to find this out for quite a bit

If you could answer it Id be forever your slave

Hahaha

 

[DCrake]

Every control has a control tip text property. Insert the tool tip text you want to appear when the cursor hovers over the button.

 

[Noreen]

Every control has a control tip text property. Insert the tool tip text you want to appear when the cursor hovers over the button.

Oh cool got it thanks a million for all ye're help