need help urgent

  • Thread starter Thread starter Santosh
  • Start date Start date
S

Santosh

Hi,

We have a desktop application which is a VBA application
working with Access. Very recently we upgradede to office
2003 and our application is not behaving properly.

When ever i try to click on the menu item I get an error.
Actually on the code side, on the click event of the menu
i have written the code,

Set myDialog = Forms![frmmain]![CommonDialog1]

this should open save dialog box.

But currently with office 2003 when i click the save
optin I get the following error..

"An Unexpected error has occured"
Error Message: 1
Error#: 2425
Error: Application-defined or object-defined error"

Can any body please tell me why this is happening.

thanks in advance,
santosh
 
The common dialog control usually breaks when you change version. You are
better off without it.

1. Press Ctrl+G to open the immediate window.

2. From the Tools menu, choose References.

3. Deselect the MS Common Dialog library (which may have the word "MISSING"
beside it.)

4. Delete the common dialog control from your form.

5. Use the code in this link to get the File Save dialog instead:
http://www.mvps.org/access/api/api0001.htm
 
Hi Allen,

Actually this application was developed Access 2000 and
was made compatible to accoee 2003. We package this
application using Install Shield and send it to users
who just install this application. The problem occurs
with only few users and not. These users have just noe
upgraded their Office to 2003 and are using Win XP as OS.
Now How can i change the code and the dependent reference
in the client machine.

This is a weird problem occuring on selecting any of the
menu items , now I am doubting any thing related to menu.
and this is occuring only if you upgrade office 2003 on
Win XP.

so is there any files or dlls missing that i have to
register? please reply back

thanks in advance
santosh
-----Original Message-----
The common dialog control usually breaks when you change version. You are
better off without it.

1. Press Ctrl+G to open the immediate window.

2. From the Tools menu, choose References.

3. Deselect the MS Common Dialog library (which may have the word "MISSING"
beside it.)

4. Delete the common dialog control from your form.

5. Use the code in this link to get the File Save dialog instead:
http://www.mvps.org/access/api/api0001.htm

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Santosh said:
We have a desktop application which is a VBA application
working with Access. Very recently we upgradede to office
2003 and our application is not behaving properly.

When ever i try to click on the menu item I get an error.
Actually on the code side, on the click event of the menu
i have written the code,

Set myDialog = Forms![frmmain]![CommonDialog1]

this should open save dialog box.

But currently with office 2003 when i click the save
optin I get the following error..

"An Unexpected error has occured"
Error Message: 1
Error#: 2425
Error: Application-defined or object-defined error"

Can any body please tell me why this is happening.

thanks in advance,
santosh
Click to expand...


.
Click to expand...
 
What references are you using?

I'm assuming from the name of the control that it is part of the Common
Dialog controls. If so, it may be possible for them to use regsvr32 to
reregister the control after the installation of Office 2003.

The best long-term solution would be to issue a new front-end that does not
need to reference the common dialog.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Hi Allen,

Actually this application was developed Access 2000 and
was made compatible to accoee 2003. We package this
application using Install Shield and send it to users
who just install this application. The problem occurs
with only few users and not. These users have just noe
upgraded their Office to 2003 and are using Win XP as OS.
Now How can i change the code and the dependent reference
in the client machine.

This is a weird problem occuring on selecting any of the
menu items , now I am doubting any thing related to menu.
and this is occuring only if you upgrade office 2003 on
Win XP.

so is there any files or dlls missing that i have to
register? please reply back

thanks in advance
santosh
-----Original Message-----
The common dialog control usually breaks when you change version. You are
better off without it.

1. Press Ctrl+G to open the immediate window.

2. From the Tools menu, choose References.

3. Deselect the MS Common Dialog library (which may have the word "MISSING"
beside it.)

4. Delete the common dialog control from your form.

5. Use the code in this link to get the File Save dialog instead:
http://www.mvps.org/access/api/api0001.htm

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Santosh said:
We have a desktop application which is a VBA application
working with Access. Very recently we upgradede to office
2003 and our application is not behaving properly.

When ever i try to click on the menu item I get an error.
Actually on the code side, on the click event of the menu
i have written the code,

Set myDialog = Forms![frmmain]![CommonDialog1]

this should open save dialog box.

But currently with office 2003 when i click the save
optin I get the following error..

"An Unexpected error has occured"
Error Message: 1
Error#: 2425
Error: Application-defined or object-defined error"

Can any body please tell me why this is happening.

thanks in advance,
santosh
Click to expand...


.
Click to expand...
Click to expand...
 
Back
Top