[access 2007] event doesn't happen

[serbring]

I have created a small db with a form. I'd like maximize the form when is started. So on the "On Load" form Event property i have putted the command

DoCmd.Maximize

but when the form is loaded the on load sub procedure isn't called. I have tried to put a breakpoint in the sub. None form event procedure isn't called. I have just enabled Macro VBA procedure.

Thank you

 

[RuralGuy]

The chance of a form loading without the OnLoad event firing is just simply non-existant. Something else is going on.

 

[RuralGuy]

Everything is now in a trusted location, correct?

 

[boblarson]

Everything is now in a trusted location, correct?

Here's a visual of what RG said.

 

[gemma-the-husky]

there is an option in A2007 to show all forms in a sort of "tabbed" manner. I would think this overrides a maximise setting. Is this possibly happening?

 

[serbring]

Here's a visual of what RG said.

i have added the location in trusted area, but events don't occur. I have noticed the events occur only in the subform contained in the main form in subform view.

 

[serbring]

there is an option in A2007 to show all forms in a sort of "tabbed" manner. I would think this overrides a maximise setting. Is this possibly happening?

how can i do that?

 

[JamesMcS]

Wouldn't it have to be in the on open anyway?

 

[serbring]

Wouldn't it have to be in the on open anyway?

i think so, infact it is strange in my opinion

the property "has module" is on yes

 

[JamesMcS]

Try it in the on open event instead then and see how you get on I guess.... RG was right though, any event will never fail to be triggered.

 

[serbring]

Try it in the on open event instead then and see how you get on I guess.... RG was right though, any event will never fail to be triggered.

it doesn't work. Nones event occur in the form.
if someone would like want to take a look on my db, i have uploaded here

http://www.megaupload.com/?d=HZOXBDAC

 

[JamesMcS]

Can't go on that website at work sorry! Not a solution but have you tried creating a new form and putting the code in there? I'm not aware of a setting that turns off all the events in a form but you never know....

Just as a test, try putting [Msgbox "Hi"] without the square brackets in the on open of the form that's causing trouble. Does it pop up and say hi?

 

[serbring]

Can't go on that website at work sorry! Not a solution but have you tried creating a new form and putting the code in there? I'm not aware of a setting that turns off all the events in a form but you never know....

Just as a test, try putting [Msgbox "Hi"] without the square brackets in the on open of the form that's causing trouble. Does it pop up and say hi?

i have attached the db. I have tried but it doesn't work. I have putted a breakpoint in the event procedure, but the code it is never stopped in it

 

[Subcancel]

I just looked at your DB and your code behind (VBA).It looks like your DoCmd.Maximize is a Sub Click() event on one of your text boxes.

Try adding this if you have not already.

Also try setting you Pop Up to "yes".

Private Sub Form_Load()

DoCmd.Maximize

End Sub

 

[JamesMcS]

That'll be why it's not kicking off in on open or on load then!

Just to re-ask the cleverer posters - will it still maximise in the on load event, or does it need to be in the on open event?

 

[serbring]

I just looked at your DB and your code behind (VBA).It looks like your DoCmd.Maximize is a Sub Click() event on one of your text boxes.

Try adding this if you have not already.

Also try setting you Pop Up to "yes".

Private Sub Form_Load()

DoCmd.Maximize

End Sub

Sorry maybe i haven't understood what you have writtem, but i have just putted the command DoCmd.Maximize on form_open and form_load procedure. I have putted also as click event in a textbox only for testing it.

what do you mean with "setting you Pop Up to "yes""?

 

[Subcancel]

http://www.access-programmers.co.uk/forums/showthread.php?t=113078

Post #2 and #4 has a good explanation of the on open and on load. This should help on what you want to do.

 

[Subcancel]

Sorry maybe i haven't understood what you have writtem, but i have just putted the command DoCmd.Maximize on form_open and form_load procedure. I have putted also as click event in a textbox only for testing it.

what do you mean with "setting you Pop Up to "yes""?

In design view.. you should be able to bring up your Propety Sheet (F4) and go to the "other" tab. The first property at the top has a field call "Pop Up" and you can choose 'yes' or 'no'.

 

[serbring]

I just looked at your DB and your code behind (VBA).It looks like your DoCmd.Maximize is a Sub Click() event on one of your text boxes.

Try adding this if you have not already.

Also try setting you Pop Up to "yes".

Private Sub Form_Load()

DoCmd.Maximize

End Sub

in your pc do event procedures occur?

 

[Subcancel]

Yes.. I tested it on my pc and I was able to get the form to maximize. After i set my "Pop up" to yes.