Maximize On Activate

[samjesse]

Hi

I have both Office 2000 and 2007 on XP.

This Access 2000 database is producing an error, when it first starts it opens a Form which has an event as below. Is there a fix please? Thank you

Private Sub Form_Activate()
'Maximize the form and Sets size of forms
    DoCmd.Maximize
   

End Sub

 

[vbaInet]

Move that code to the On Load event of the form instead.

 

[missinglinq]

There's nothing wrong with this being in the Form_Activate event, it should work fine there. But in order to help you we need to know what error it's producing. Also, is there any other code in the Activate event?

 

[vbaInet]

I was thinking since the Maximize method only maximizes the active window, the open or load event would be the most appropriate for handling this.

 

[ghudson]

I use the forms OnOpen event when I am doing stuff that affects the form.

When you first open a form, the following events occur in this order:
Open → Load → Resize → Activate → Current
http://msdn.microsoft.com/en-us/library/aa211439(office.11).aspx

This will maximize the application...
DoCmd.RunCommand acCmdAppMaximize

This maximizes the current form...
DoCmd.Maximize

 

[missinglinq]

The Open Form event would be fine, but the Activate works, too. Using the Activate event will maximize the form, for instance, when the form opens and if you navigate away from the form, minimizing it, then later return to the form.

I doubt that the error is actually being popped by the maximizing code, which is why the OP needs to post the actual error as well as other code they're using.

 

[samjesse]

There's nothing wrong with this being in the Form_Activate event, it should work fine there. But in order to help you we need to know what error it's producing. Also, is there any other code in the Activate event?

I tried Form_Open as suggested by others for no avail. It gave the same error which is:

"Object or class does not support the set of events"

It is the only code in the Form_Activate.

 

[samjesse]

deleted for duplication.

 

[ghudson]

You need to post all the code you are using in the offending form unless you want to post your db [minus any data]. Something is conflicting and we cannot help without seeing it.

If you click the Debug Compile option, does anything trigger an error?

Ensure you have these two statements at the top of all your modules...

Option Compare Database
Option Explicit

 

[vbaInet]

The Open Form event would be fine, but the Activate works, too. Using the Activate event will maximize the form, for instance, when the form opens and if you navigate away from the form, minimizing it, then later return to the form.

You're correct and I'm actually aware of that. I thought maybe the method was being called unecessarily which was causing the problems.

I doubt that the error is actually being popped by the maximizing code, which is why the OP needs to post the actual error as well as other code they're using.

I agree with that.

Also, when the error message pops-up the OP should click the DEBUG button and show the line of code that is highlighted in yellow.

 

[samjesse]

OK. I would like to post the whole database without the data. I have 2 files for this database "since it is linked tables", DAS.mdb and DAS_be.mdb.

If I post the DAS.mdb, would that not post the data?

thx

 

[vbaInet]

Create a copy of your db and use the utility provided by Bob Larson, one of this forum's VIPs to strip your db of data. Here's the link:

http://www.btabdevelopment.com/main/MyFreeAccessTools/tabid/78/Default.aspx

It's the DATABASE RESET TOOL.

 

[samjesse]

OK. here is the database. BTW. all works OK when I run it in another machine running windows 2000 OS.

the problem is with other machines running XP with office 2000 installed.

 

[SOS]

I would suggest opening it on that machine and then going to the VBA window and then going to DEBUG > COMPILE <yourprojectnamehere> and it might shed some light on things.

 

[samjesse]

ops. could not upload it since it was bigger than max. allowed. for mdb or zip.

 

[SOS]

ops. could not upload it since it was bigger than what is required. for mdb or zip.

Did you run COMPACT AND REPAIR before zipping?

 

[samjesse]

Did you run COMPACT AND REPAIR before zipping?

I used the tool suggested in post 1498 above.

 

[samjesse]

I would suggest opening it on that machine and then going to the VBA window and then going to DEBUG > COMPILE <yourprojectnamehere> and it might shed some light on things.

I get Compile Error: User-defined type not defined.
the blue highlight is on
DialParams As LINEDIALPARAMS

in Telephony module.

 

[vbaInet]

I used the tool suggested in post 1498 above.

That must be a good year

Do what SOS suggested before and after using the tool.

 

[SOS]

I get Compile Error: User-defined type not defined.
the blue highlight is on
DialParams As LINEDIALPARAMS

in Telephony module.

That would be a dll, ocx or olb that isn't registered on that machine.