Modal Form, want taskbar 1

[ZOR]

I have all forms set as modal/popup = yes, to stop users wandering off. However they now say they must have access to the task bar. All my forms are set to maximise on opening, how can I make the task bar visible without losing the benefits I have of modal forms. Many thanks

 

[kjv1611]

Border Style - set to "Sizable" or "Dialog" or "Thin"
Then, depending upon which style you chose, you may need to set this option:
Control Box - to "No"
or
Min Max Buttons - to "None" or "Min Enabled"

It just depends upon what you need/want.

You can also disable the close button:
Close Button - set to "No"

These are all under the "Format" tab of the Form properties.


--

"If to err is human, then I must be some kind of human!" -Me

 

[ZOR]

Thanks, but those settings are already in place. I have just set the popup to no, and now I have the taskbar showing, however how/if can I get rid of the close button, File/Edit/Insert array at the top. All I want to see is my forms set as modal, and the taskbar. Thanks

 

[missinglinq]

Afternoon, ZOR!

What you appear to have is the situation of the horse telling the rider which direction to go in! Ain't life grand!
What's their purpose in having the Taskbar available? I mean, the point of the Taskbar is to be able to switch focus to another open object/form, and the whole purpose/benefit of Modal is to make it mandatory to close the Modal Form before doing just that!

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!

 

[ZOR]

Thanks, yes I know. They want to have access to other running programs and see various prompts that appear on the taskbar? As you say, the function of a modal form is important. Nobody mentioned this until now, means I have to squash up my forms to get things in. I hoped an MDE version would eliminated all the top clutter, but with access to delete record etc its asking for trouble. ??

 

[kjv1611]

I do know of a way to do exactly what you want to do, I think. I'll dig up the thread I'm speaking of, and post it here for you, if I can find it..

--

"If to err is human, then I must be some kind of human!" -Me

 

[kjv1611]

Okay, have a look at this:

[blue]Running Form in a window independent of Microsoft Access[/blue]
thread702-798009

--

"If to err is human, then I must be some kind of human!" -Me

 

[ZOR]

Many thanks. I tried it but it did not work. Maybe its pre XP? But thanks for looking for it.

 

[kjv1611]

Hmm, what do you mean, "it did not work"?

and "Maybe it's pre XP?"

I am using Office 2003, and it works perfectly. It also worked perfectly with Office 2000.

Make sure you read through it all, and add any necessary references. Also, make sure your form is set to POP-UP... maybe not modal, but I can't remember for sure.

Let us know how you are instantiating the code, by typing it here, and we can double-check and make sure you've got it setup correctly.

--

"If to err is human, then I must be some kind of human!" -Me

 

[ZOR]

Thanks, I just cut and pasted the module code into a module. Pasted the code into the form load event. Tried Modal and Non Modal, but keeping as popup. Nothing seemed different, do I need I border on the form, just thought of that, I will try it, as there is nothing around it.

 

[ZOR]

Many thanks kiv1611,

That did it, looks like I'm wanting. Thanks very, very much. Have a star for the help. Regards

 

[kjv1611]

I know it's worked WONDERFUL for me. I've used it on a handful of Access databases I've created for various uses at work.

--

"If to err is human, then I must be some kind of human!" -Me

 

[ZOR]

I seem to be having problems switching focus to a subform and back?. I did nothing to my subform, ie no on load bit, and its not a popup form. Any ideas? Thanks

 

[ZOR]

Is there any way to hide the taskbar during certain operations. I have a series of form controls in a sequential chain of losing focus and moving to the next. If the sequence gets broken by someone leaving via the taskbar It all falls over. I have told people its stupid wanting the taskbar, they are working on data nothing else. If they want the Internet, then close the application, but they insist on this hybrid mess. Thanks

 

[kjv1611]

You can manipulate whether the taskbar shows or not by changing the border programatically in the VBA window. I'd suggest just changing the border according to whatever criteria you may have.

As far as the subform not showing up, I'm assuming you mean a separate form, b/c the subform would be within anothre form. But, for any form to show up with this method, the form has to be set to Pop-up, or else it will not work correctly.

--

"If to err is human, then I must be some kind of human!" -Me

 

[ZOR]

I tried this in the subform, where a command button starts a series of input events that must not lose focus, however got the message I could not do this.

"You cannot assign a value to this object"


Forms!Mainform1.Form.BorderStyle = 0

 

[PHV]

starts a series of input events that must not lose focus
So, either don't use a multitasking OS or amend your code to make it more robust.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[ZOR]

Thanks PHV. However as my forms are no longer Modal, just popup, can I stop a user leaving a field to click on the taskbar, would the mouse take charge?

 

[ZOR]

Just set the form back to Modal, the mouse won!!

 

[PHV]

For me, the main issue is why a user shouldn't launch another application when your code is running ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886