 | |
access2007 docmd.maximize crashes
comp.databases.ms-access comp.databases.ms-access
 |
| | Thread Tools | Display Modes |
#11
 
| |||
| |||
|
Re: access2007 docmd.maximize crashes -
11-10-2010
, 04:55 AM
|
XML is case sensitive. customUI -- AG Email: npATadhdataDOTcom "Roger" <lesperan... (AT) natpro (DOT) com> wrote in message news:2d1d61b4-0164-4889-a7e4-76169d085767 (AT) 35g2000prb (DOT) googlegroups.com... On Nov 9, 10:29 am, Roger <lesperan... (AT) natpro (DOT) com> wrote: On Nov 9, 10:24 am, "agiamb" <NOSPAMagi... (AT) newsgroup (DOT) nospam> wrote: Sounds like there is something wrong with your ribbon xml, or a missing ribbon callback function, or something wrong with a callback function.. -- AG Email: npATadhdataDOTcom "Roger" <lesperan... (AT) natpro (DOT) com> wrote in message news:53c6eca6-b55f-4f32-8069-c95f560c41eb (AT) o11g2000prf (DOT) googlegroups.com.... On Nov 8, 3:52 pm, Roger <lesperan... (AT) natpro (DOT) com> wrote: On Nov 8, 2:28 pm, Roger <lesperan... (AT) natpro (DOT) com> wrote: On Nov 8, 1:58 pm, "David-W-Fenton" <NoEm... (AT) SeeSignature (DOT) invalid wrote: Roger <lesperan... (AT) natpro (DOT) com> wrote innews:05e9ab7c-f9b4-4d9a-89e8-3b3d438c25f7 (AT) v28g2000prn (DOT) googlegroups.co m: I have a bound form with a docmd.maximize in the form open event, this crashes the system, even though I have error handling - it's been working fine for years with access97 A couple of things: 1. remove both On Error Resume Next statements. Neither has any effect whatsoever (the first is superseded by the call to a sub with error handling, the second happens as the last line before exiting the sub, where it can't have any effect, since there is no following line that can produce an error), and both are mis-used in your code. 2. have you tried moving the DoCmd.Maximize to before you set the Recordsource of your form? Or before you call LoadForm()? Or before you open your new form instance? The point is, that DoCmd.Maximize effects all windows that aren't PopUp windows, so you can call it anywhere -- it doesn't apply to the specific object you're opening, but to everything open in the MDI window (although, perhaps the tabbed and split forms in A2007/2010 work differently?). All that said, the first thing I'd check on is video drivers. This is a classic kind of case where buggy/outdated video drivers have often caused Access to crash in the past, so I'd check if moving the Maximize command doesn't have any effect. (my expectation is that if you move the Maximize to somewhere before the setting of the Recordsource that you're going to get an error when you set the Recordsource, or shortly thereafter) -- David W. Fentonhttp://www.dfenton.com/ contact via website onlyhttp://www.dfenton.com/DFA/ I moved the docmd.maximize to the top of formOpen(), same problem if I put a stop statement at the top of formOpen(), and stopped execution, and 'x' out of access, it crashes too if I put docmd.maximize at the top of editBusiness it doesn't crash so the only things that I step through from there are DoCmd.Maximize <- doesn't crash Set frm = New Form_frmBusiness Private Sub Form_Open(Cancel As Integer) DoCmd.Maximize <- crashes I will check the video drivers and the access SP's- Hide quoted text - - Show quoted text - I tried running the mdb using access2003, and I needed to comment out one line Application.LoadCustomUI "ribbon", strOut and is works fine with access2003, and with the line commented out it works fine with access2007 put the line back in, and it crashed I have a very simple quick toolbar ribbon, needed for use with the runtime, stored in an xml file the contents of the file is read into strOut in many applications I know there's another way to setup a ribbon, something about a hidden table, but I couldn't get it to work, thus the xml file I guess now I have to figure out how to use the table ....- Hide quoted text - - Show quoted text - I created a table uSysRibbons and loaded a record with my XLS data it now runs properly in access2003, cause it ignores the ribbon but still crashes with access2007 the office SP is up to date the video drivers are current now what can I try ?- Hide quoted text - - Show quoted text - I don't use callbacks, and this is the xml customUI xmlns="http://schemas.microsoft.com/office/2006/01/ customui" !--http://www.accessribbon.de/en/index.php-- ribbon startFromScratch="true" qat documentControls button idMso="FileSave"/ button idMso="Copy"/ button idMso="Paste"/ button idMso="PrintDialogAccess"/ button idMso="PrintPreviewClose"/ button idMso="FilterBySelection"/ button idMso="ApplyFilter"/ button idMso="AdpOutputOperationsSortAscending"/ button idMso="AdpOutputOperationsSortDescending"/ button idMso="ExportExcel"/ button idMso="ExportWord"/ button idMso="SpellingAccess"/ button idMso="WindowsCascade"/ button idMso="FileExit"/ /documentControls /qat /ribbon /customUI I will start trimming it until it works or....- Hide quoted text - - Show quoted text - this trimmed down xml causes the app to work properly customUI xmlns="http://schemas.microsoft.com/office/2006/01/ customui" /customUI this xml causes the crash customUI xmlns="http://schemas.microsoft.com/office/2006/01/ customui" * *<ribbon startFromScratch="true" * *</ribbon /customUI I've checked other postings in this group, and the xml should / does hide the ribbon, but in some conditions, it crashes access2007- Hide quoted text - - Show quoted text - |
string ?
if so, it is correct because if I change it to 'customUI', and I turn
on 'show add-in user interface errors', I get errors
no errors if I use the lower case version
if I change
<customUI>
</customUI>
to
<customui>
</customui>
I also get errors, so I'm thinking, with no errors, my XML must be
correct
#12
| |||
| |||
|
|
XML is case sensitive. customUI -- AG Email: npATadhdataDOTcom "Roger" <lesperan... (AT) natpro (DOT) com> wrote in message news:2d1d61b4-0164-4889-a7e4-76169d085767 (AT) 35g2000prb (DOT) googlegroups.com... On Nov 9, 10:29 am, Roger <lesperan... (AT) natpro (DOT) com> wrote: On Nov 9, 10:24 am, "agiamb" <NOSPAMagi... (AT) newsgroup (DOT) nospam> wrote: Sounds like there is something wrong with your ribbon xml, or a missing ribbon callback function, or something wrong with a callback function. -- AG Email: npATadhdataDOTcom "Roger" <lesperan... (AT) natpro (DOT) com> wrote in message news:53c6eca6-b55f-4f32-8069-c95f560c41eb (AT) o11g2000prf (DOT) googlegroups.com... On Nov 8, 3:52 pm, Roger <lesperan... (AT) natpro (DOT) com> wrote: On Nov 8, 2:28 pm, Roger <lesperan... (AT) natpro (DOT) com> wrote: On Nov 8, 1:58 pm, "David-W-Fenton" <NoEm... (AT) SeeSignature (DOT) invalid wrote: Roger <lesperan... (AT) natpro (DOT) com> wrote innews:05e9ab7c-f9b4-4d9a-89e8-3b3d438c25f7 (AT) v28g2000prn (DOT) googlegroups.co m: I have a bound form with a docmd.maximize in the form open event, this crashes the system, even though I have error handling - it's been working fine for years with access97 A couple of things: 1. remove both On Error Resume Next statements. Neither has any effect whatsoever (the first is superseded by the call to a sub with error handling, the second happens as the last line before exiting the sub, where it can't have any effect, since there is no following line that can produce an error), and both are mis-used in your code. 2. have you tried moving the DoCmd.Maximize to before you set the Recordsource of your form? Or before you call LoadForm()? Or before you open your new form instance? The point is, that DoCmd.Maximize effects all windows that aren't PopUp windows, so you can call it anywhere -- it doesn't apply to the specific object you're opening, but to everything open in the MDI window (although, perhaps the tabbed and split forms in A2007/2010 work differently?). All that said, the first thing I'd check on is video drivers. This is a classic kind of case where buggy/outdated video drivers have often caused Access to crash in the past, so I'd check if moving the Maximize command doesn't have any effect. (my expectation is that if you move the Maximize to somewhere before the setting of the Recordsource that you're going to get an error when you set the Recordsource, or shortly thereafter) -- David W. Fentonhttp://www.dfenton.com/ contact via website onlyhttp://www.dfenton.com/DFA/ I moved the docmd.maximize to the top of formOpen(), same problem if I put a stop statement at the top of formOpen(), and stopped execution, and 'x' out of access, it crashes too if I put docmd.maximize at the top of editBusiness it doesn't crash so the only things that I step through from there are DoCmd.Maximize <- doesn't crash Set frm = New Form_frmBusiness Private Sub Form_Open(Cancel As Integer) DoCmd.Maximize <- crashes I will check the video drivers and the access SP's- Hide quoted text - - Show quoted text - I tried running the mdb using access2003, and I needed to comment out one line Application.LoadCustomUI "ribbon", strOut and is works fine with access2003, and with the line commented out it works fine with access2007 put the line back in, and it crashed I have a very simple quick toolbar ribbon, needed for use with the runtime, stored in an xml file the contents of the file is read into strOut in many applications I know there's another way to setup a ribbon, something about a hidden table, but I couldn't get it to work, thus the xml file I guess now I have to figure out how to use the table ....- Hide quoted text - - Show quoted text - I created a table uSysRibbons and loaded a record with my XLS data it now runs properly in access2003, cause it ignores the ribbon but still crashes with access2007 the office SP is up to date the video drivers are current now what can I try ?- Hide quoted text - - Show quoted text - I don't use callbacks, and this is the xml customUI xmlns="http://schemas.microsoft.com/office/2006/01/ customui" !--http://www.accessribbon.de/en/index.php-- ribbon startFromScratch="true" qat documentControls button idMso="FileSave"/ button idMso="Copy"/ button idMso="Paste"/ button idMso="PrintDialogAccess"/ button idMso="PrintPreviewClose"/ button idMso="FilterBySelection"/ button idMso="ApplyFilter"/ button idMso="AdpOutputOperationsSortAscending"/ button idMso="AdpOutputOperationsSortDescending"/ button idMso="ExportExcel"/ button idMso="ExportWord"/ button idMso="SpellingAccess"/ button idMso="WindowsCascade"/ button idMso="FileExit"/ /documentControls /qat /ribbon /customUI I will start trimming it until it works or....- Hide quoted text - - Show quoted text - this trimmed down xml causes the app to work properly customUI xmlns="http://schemas.microsoft.com/office/2006/01/ customui" /customUI this xml causes the crash customUI xmlns="http://schemas.microsoft.com/office/2006/01/ customui" ribbon startFromScratch="true" /ribbon /customUI I've checked other postings in this group, and the xml should / does hide the ribbon, but in some conditions, it crashes access2007- Hide quoted text - - Show quoted text - |
string ?
if so, it is correct because if I change it to 'customUI', and I turn
on 'show add-in user interface errors', I get errors
no errors if I use the lower case version
if I change
<customUI>
</customUI>
to
<customui>
</customui>
I also get errors, so I'm thinking, with no errors, my XML must be
correct
#13
| |||
| |||
|
|
Sorry, was going quickly and got caught in a word wrap. Didn't realize that the 'customui' was not the tag. Try a blank ribbon customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui" * <ribbon startFromScratch="true"/ /customUI If that works, build it back one element at a time. -- AG Email: npATadhdataDOTcom "Roger" <lesperan... (AT) natpro (DOT) com> wrote in message news:1f00cdc6-3012-473a-bffa-c20f507d4225 (AT) i41g2000vbn (DOT) googlegroups.com... On Nov 9, 2:30 pm, "agiamb" <NOSPAMagi... (AT) newsgroup (DOT) nospam> wrote: XML is case sensitive. customUI -- AG Email: npATadhdataDOTcom "Roger" <lesperan... (AT) natpro (DOT) com> wrote in message news:2d1d61b4-0164-4889-a7e4-76169d085767 (AT) 35g2000prb (DOT) googlegroups.com... On Nov 9, 10:29 am, Roger <lesperan... (AT) natpro (DOT) com> wrote: On Nov 9, 10:24 am, "agiamb" <NOSPAMagi... (AT) newsgroup (DOT) nospam> wrote: Sounds like there is something wrong with your ribbon xml, or a missing ribbon callback function, or something wrong with a callback function. -- AG Email: npATadhdataDOTcom "Roger" <lesperan... (AT) natpro (DOT) com> wrote in message news:53c6eca6-b55f-4f32-8069-c95f560c41eb (AT) o11g2000prf (DOT) googlegroups.com... On Nov 8, 3:52 pm, Roger <lesperan... (AT) natpro (DOT) com> wrote: On Nov 8, 2:28 pm, Roger <lesperan... (AT) natpro (DOT) com> wrote: On Nov 8, 1:58 pm, "David-W-Fenton" <NoEm... (AT) SeeSignature (DOT) invalid wrote: Roger <lesperan... (AT) natpro (DOT) com> wrote innews:05e9ab7c-f9b4-4d9a-89e8-3b3d438c25f7 (AT) v28g2000prn (DOT) googlegroups.co m: I have a bound form with a docmd.maximize in the form open event, this crashes the system, even though I have error handling - it's been working fine for years with access97 A couple of things: 1. remove both On Error Resume Next statements. Neither has any effect whatsoever (the first is superseded by the call to a sub with error handling, the second happens as the last line before exiting the sub, where it can't have any effect, since there is no following line that can produce an error), and both are mis-used in your code. 2. have you tried moving the DoCmd.Maximize to before you set the Recordsource of your form? Or before you call LoadForm()? Or before you open your new form instance? The point is, that DoCmd.Maximize effects all windows that aren't PopUp windows, so you can call it anywhere -- it doesn't apply to the specific object you're opening, but to everything open in the MDI window (although, perhaps the tabbed and split forms in A2007/2010 work differently?). All that said, the first thing I'd check on is video drivers. This is a classic kind of case where buggy/outdated video drivers have often caused Access to crash in the past, so I'd check if moving the Maximize command doesn't have any effect. (my expectation is that if you move the Maximize to somewhere before the setting of the Recordsource that you're going to get an error when you set the Recordsource, or shortly thereafter) -- David W. Fentonhttp://www.dfenton.com/ contact via website onlyhttp://www.dfenton.com/DFA/ I moved the docmd.maximize to the top of formOpen(), same problem if I put a stop statement at the top of formOpen(), and stopped execution, and 'x' out of access, it crashes too if I put docmd.maximize at the top of editBusiness it doesn't crash so the only things that I step through from there are DoCmd.Maximize <- doesn't crash Set frm = New Form_frmBusiness Private Sub Form_Open(Cancel As Integer) DoCmd.Maximize <- crashes I will check the video drivers and the access SP's- Hide quoted text - - Show quoted text - I tried running the mdb using access2003, and I needed to comment out one line Application.LoadCustomUI "ribbon", strOut and is works fine with access2003, and with the line commented out it works fine with access2007 put the line back in, and it crashed I have a very simple quick toolbar ribbon, needed for use with the runtime, stored in an xml file the contents of the file is read into strOut in many applications I know there's another way to setup a ribbon, something about a hidden table, but I couldn't get it to work, thus the xml file I guess now I have to figure out how to use the table ....- Hide quoted text - - Show quoted text - I created a table uSysRibbons and loaded a record with my XLS data it now runs properly in access2003, cause it ignores the ribbon but still crashes with access2007 the office SP is up to date the video drivers are current now what can I try ?- Hide quoted text - - Show quoted text - I don't use callbacks, and this is the xml customUI xmlns="http://schemas.microsoft.com/office/2006/01/ customui" !--http://www.accessribbon.de/en/index.php-- ribbon startFromScratch="true" qat documentControls button idMso="FileSave"/ button idMso="Copy"/ button idMso="Paste"/ button idMso="PrintDialogAccess"/ button idMso="PrintPreviewClose"/ button idMso="FilterBySelection"/ button idMso="ApplyFilter"/ button idMso="AdpOutputOperationsSortAscending"/ button idMso="AdpOutputOperationsSortDescending"/ button idMso="ExportExcel"/ button idMso="ExportWord"/ button idMso="SpellingAccess"/ button idMso="WindowsCascade"/ button idMso="FileExit"/ /documentControls /qat /ribbon /customUI I will start trimming it until it works or....- Hide quoted text - - Show quoted text - this trimmed down xml causes the app to work properly customUI xmlns="http://schemas.microsoft.com/office/2006/01/ customui" /customUI this xml causes the crash customUI xmlns="http://schemas.microsoft.com/office/2006/01/ customui" ribbon startFromScratch="true" /ribbon /customUI I've checked other postings in this group, and the xml should / does hide the ribbon, but in some conditions, it crashes access2007- Hide quoted text - - Show quoted text - I presume you are referring to 'customui' at the end of the http string ? if so, it is correct because if I change it to 'customUI', and I turn on 'show add-in user interface errors', I get errors no errors if I use the lower case version if I change customUI /customUI to customui /customui I also get errors, so I'm thinking, with no errors, my XML must be correct- Hide quoted text - - Show quoted text - |
what's the difference between what you propose and this
<customUI xmlns="http://schemas.microsoft.com/office/2006/01/
customui">
<ribbon startFromScratch="true">
</ribbon>
</customUI>
#14
| |||
| |||
|
|
Sorry, was going quickly and got caught in a word wrap. Didn't realize that the 'customui' was not the tag. Try a blank ribbon customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui" ribbon startFromScratch="true"/ /customUI If that works, build it back one element at a time. -- AG Email: npATadhdataDOTcom "Roger" <lesperan... (AT) natpro (DOT) com> wrote in message news:1f00cdc6-3012-473a-bffa-c20f507d4225 (AT) i41g2000vbn (DOT) googlegroups.com... On Nov 9, 2:30 pm, "agiamb" <NOSPAMagi... (AT) newsgroup (DOT) nospam> wrote: XML is case sensitive. customUI -- AG Email: npATadhdataDOTcom "Roger" <lesperan... (AT) natpro (DOT) com> wrote in message news:2d1d61b4-0164-4889-a7e4-76169d085767 (AT) 35g2000prb (DOT) googlegroups.com... On Nov 9, 10:29 am, Roger <lesperan... (AT) natpro (DOT) com> wrote: On Nov 9, 10:24 am, "agiamb" <NOSPAMagi... (AT) newsgroup (DOT) nospam> wrote: Sounds like there is something wrong with your ribbon xml, or a missing ribbon callback function, or something wrong with a callback function. -- AG Email: npATadhdataDOTcom "Roger" <lesperan... (AT) natpro (DOT) com> wrote in message news:53c6eca6-b55f-4f32-8069-c95f560c41eb (AT) o11g2000prf (DOT) googlegroups.com... On Nov 8, 3:52 pm, Roger <lesperan... (AT) natpro (DOT) com> wrote: On Nov 8, 2:28 pm, Roger <lesperan... (AT) natpro (DOT) com> wrote: On Nov 8, 1:58 pm, "David-W-Fenton" NoEm... (AT) SeeSignature (DOT) invalid wrote: Roger <lesperan... (AT) natpro (DOT) com> wrote innews:05e9ab7c-f9b4-4d9a-89e8-3b3d438c25f7 (AT) v28g2000prn (DOT) googlegroups.co m: I have a bound form with a docmd.maximize in the form open event, this crashes the system, even though I have error handling - it's been working fine for years with access97 A couple of things: 1. remove both On Error Resume Next statements. Neither has any effect whatsoever (the first is superseded by the call to a sub with error handling, the second happens as the last line before exiting the sub, where it can't have any effect, since there is no following line that can produce an error), and both are mis-used in your code. 2. have you tried moving the DoCmd.Maximize to before you set the Recordsource of your form? Or before you call LoadForm()? Or before you open your new form instance? The point is, that DoCmd.Maximize effects all windows that aren't PopUp windows, so you can call it anywhere -- it doesn't apply to the specific object you're opening, but to everything open in the MDI window (although, perhaps the tabbed and split forms in A2007/2010 work differently?). All that said, the first thing I'd check on is video drivers. This is a classic kind of case where buggy/outdated video drivers have often caused Access to crash in the past, so I'd check if moving the Maximize command doesn't have any effect. (my expectation is that if you move the Maximize to somewhere before the setting of the Recordsource that you're going to get an error when you set the Recordsource, or shortly thereafter) -- David W. Fentonhttp://www.dfenton.com/ contact via website onlyhttp://www.dfenton.com/DFA/ I moved the docmd.maximize to the top of formOpen(), same problem if I put a stop statement at the top of formOpen(), and stopped execution, and 'x' out of access, it crashes too if I put docmd.maximize at the top of editBusiness it doesn't crash so the only things that I step through from there are DoCmd.Maximize <- doesn't crash Set frm = New Form_frmBusiness Private Sub Form_Open(Cancel As Integer) DoCmd.Maximize <- crashes I will check the video drivers and the access SP's- Hide quoted text - - Show quoted text - I tried running the mdb using access2003, and I needed to comment out one line Application.LoadCustomUI "ribbon", strOut and is works fine with access2003, and with the line commented out it works fine with access2007 put the line back in, and it crashed I have a very simple quick toolbar ribbon, needed for use with the runtime, stored in an xml file the contents of the file is read into strOut in many applications I know there's another way to setup a ribbon, something about a hidden table, but I couldn't get it to work, thus the xml file I guess now I have to figure out how to use the table ....- Hide quoted text - - Show quoted text - I created a table uSysRibbons and loaded a record with my XLS data it now runs properly in access2003, cause it ignores the ribbon but still crashes with access2007 the office SP is up to date the video drivers are current now what can I try ?- Hide quoted text - - Show quoted text - I don't use callbacks, and this is the xml customUI xmlns="http://schemas.microsoft.com/office/2006/01/ customui" !--http://www.accessribbon.de/en/index.php-- ribbon startFromScratch="true" qat documentControls button idMso="FileSave"/ button idMso="Copy"/ button idMso="Paste"/ button idMso="PrintDialogAccess"/ button idMso="PrintPreviewClose"/ button idMso="FilterBySelection"/ button idMso="ApplyFilter"/ button idMso="AdpOutputOperationsSortAscending"/ button idMso="AdpOutputOperationsSortDescending"/ button idMso="ExportExcel"/ button idMso="ExportWord"/ button idMso="SpellingAccess"/ button idMso="WindowsCascade"/ button idMso="FileExit"/ /documentControls /qat /ribbon /customUI I will start trimming it until it works or....- Hide quoted text - - Show quoted text - this trimmed down xml causes the app to work properly customUI xmlns="http://schemas.microsoft.com/office/2006/01/ customui" /customUI this xml causes the crash customUI xmlns="http://schemas.microsoft.com/office/2006/01/ customui" ribbon startFromScratch="true" /ribbon /customUI I've checked other postings in this group, and the xml should / does hide the ribbon, but in some conditions, it crashes access2007- Hide quoted text - - Show quoted text - I presume you are referring to 'customui' at the end of the http string ? if so, it is correct because if I change it to 'customUI', and I turn on 'show add-in user interface errors', I get errors no errors if I use the lower case version if I change customUI /customUI to customui /customui I also get errors, so I'm thinking, with no errors, my XML must be correct- Hide quoted text - - Show quoted text - |
what's the difference between what you propose and this
<customUI xmlns="http://schemas.microsoft.com/office/2006/01/
customui">
<ribbon startFromScratch="true">
</ribbon>
</customUI>
#15
| |||
| |||
|
|
It should be the same. I just copied and pasted what I use in all of my apps. Do you possibly have a form that has the ribbon property set to a ribbon that does not exist? -- AG Email: npATadhdataDOTcom "Roger" <lesperan... (AT) natpro (DOT) com> wrote in message news:4deaf3e0-59ef-443a-95da-04d268e2465a (AT) q36g2000vbi (DOT) googlegroups.com... On Nov 10, 6:28 am, "agiamb" <NOSPAMagi... (AT) newsgroup (DOT) nospam> wrote: Sorry, was going quickly and got caught in a word wrap. Didn't realize that the 'customui' was not the tag. Try a blank ribbon customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui" ribbon startFromScratch="true"/ /customUI If that works, build it back one element at a time. -- AG Email: npATadhdataDOTcom "Roger" <lesperan... (AT) natpro (DOT) com> wrote in message news:1f00cdc6-3012-473a-bffa-c20f507d4225 (AT) i41g2000vbn (DOT) googlegroups.com.... On Nov 9, 2:30 pm, "agiamb" <NOSPAMagi... (AT) newsgroup (DOT) nospam> wrote: XML is case sensitive. customUI -- AG Email: npATadhdataDOTcom "Roger" <lesperan... (AT) natpro (DOT) com> wrote in message news:2d1d61b4-0164-4889-a7e4-76169d085767 (AT) 35g2000prb (DOT) googlegroups.com.... On Nov 9, 10:29 am, Roger <lesperan... (AT) natpro (DOT) com> wrote: On Nov 9, 10:24 am, "agiamb" <NOSPAMagi... (AT) newsgroup (DOT) nospam> wrote: Sounds like there is something wrong with your ribbon xml, or a missing ribbon callback function, or something wrong with a callback function. -- AG Email: npATadhdataDOTcom "Roger" <lesperan... (AT) natpro (DOT) com> wrote in message news:53c6eca6-b55f-4f32-8069-c95f560c41eb (AT) o11g2000prf (DOT) googlegroups..com... On Nov 8, 3:52 pm, Roger <lesperan... (AT) natpro (DOT) com> wrote: On Nov 8, 2:28 pm, Roger <lesperan... (AT) natpro (DOT) com> wrote: On Nov 8, 1:58 pm, "David-W-Fenton" NoEm... (AT) SeeSignature (DOT) invalid wrote: Roger <lesperan... (AT) natpro (DOT) com> wrote innews:05e9ab7c-f9b4-4d9a-89e8-3b3d438c25f7 (AT) v28g2000prn (DOT) googlegroups.co m: I have a bound form with a docmd.maximize in the form open event, this crashes the system, even though I have error handling - it's been working fine for years with access97 A couple of things: 1. remove both On Error Resume Next statements. Neither has any effect whatsoever (the first is superseded by the call to a sub with error handling, the second happens as the last line before exiting the sub, where it can't have any effect, since there is no following line that can produce an error), and both are mis-used in your code. 2. have you tried moving the DoCmd.Maximize to before you set the Recordsource of your form? Or before you call LoadForm()? Or before you open your new form instance? The point is, that DoCmd.Maximize effects all windows that aren't PopUp windows, so you can call it anywhere -- it doesn't apply to the specific object you're opening, but to everything open in the MDI window (although, perhaps the tabbed and split forms in A2007/2010 work differently?). All that said, the first thing I'd check on is video drivers. This is a classic kind of case where buggy/outdated video drivers have often caused Access to crash in the past, so I'd check if moving the Maximize command doesn't have any effect. (my expectation is that if you move the Maximize to somewhere before the setting of the Recordsource that you're going to get an error when you set the Recordsource, or shortly thereafter) -- David W. Fentonhttp://www.dfenton.com/ contact via website onlyhttp://www.dfenton.com/DFA/ I moved the docmd.maximize to the top of formOpen(), same problem if I put a stop statement at the top of formOpen(), and stopped execution, and 'x' out of access, it crashes too if I put docmd.maximize at the top of editBusiness it doesn't crash so the only things that I step through from there are DoCmd.Maximize <- doesn't crash Set frm = New Form_frmBusiness Private Sub Form_Open(Cancel As Integer) DoCmd.Maximize <- crashes I will check the video drivers and the access SP's- Hide quoted text - - Show quoted text - I tried running the mdb using access2003, and I needed to comment out one line Application.LoadCustomUI "ribbon", strOut and is works fine with access2003, and with the line commented out it works fine with access2007 put the line back in, and it crashed I have a very simple quick toolbar ribbon, needed for use with the runtime, stored in an xml file the contents of the file is read into strOut in many applications I know there's another way to setup a ribbon, something about a hidden table, but I couldn't get it to work, thus the xml file I guess now I have to figure out how to use the table ....- Hide quoted text - - Show quoted text - I created a table uSysRibbons and loaded a record with my XLS data it now runs properly in access2003, cause it ignores the ribbon but still crashes with access2007 the office SP is up to date the video drivers are current now what can I try ?- Hide quoted text - - Show quoted text - I don't use callbacks, and this is the xml customUI xmlns="http://schemas.microsoft.com/office/2006/01/ customui" !--http://www.accessribbon.de/en/index.php-- ribbon startFromScratch="true" qat documentControls button idMso="FileSave"/ button idMso="Copy"/ button idMso="Paste"/ button idMso="PrintDialogAccess"/ button idMso="PrintPreviewClose"/ button idMso="FilterBySelection"/ button idMso="ApplyFilter"/ button idMso="AdpOutputOperationsSortAscending"/ button idMso="AdpOutputOperationsSortDescending"/ button idMso="ExportExcel"/ button idMso="ExportWord"/ button idMso="SpellingAccess"/ button idMso="WindowsCascade"/ button idMso="FileExit"/ /documentControls /qat /ribbon /customUI I will start trimming it until it works or....- Hide quoted text - - Show quoted text - this trimmed down xml causes the app to work properly customUI xmlns="http://schemas.microsoft.com/office/2006/01/ customui" /customUI this xml causes the crash customUI xmlns="http://schemas.microsoft.com/office/2006/01/ customui" ribbon startFromScratch="true" /ribbon /customUI I've checked other postings in this group, and the xml should / does hide the ribbon, but in some conditions, it crashes access2007- Hide quoted text - - Show quoted text - I presume you are referring to 'customui' at the end of the http string ? if so, it is correct because if I change it to 'customUI', and I turn on 'show add-in user interface errors', I get errors no errors if I use the lower case version if I change customUI /customUI to customui /customui I also get errors, so I'm thinking, with no errors, my XML must be correct- Hide quoted text - - Show quoted text - that ribbon loads but the application still crashes for some records what's the difference between what you propose and this customUI xmlns="http://schemas.microsoft.com/office/2006/01/ customui" * *<ribbon startFromScratch="true" * *</ribbon /customUI>- Hide quoted text - - Show quoted text - |
same ribbon used for all
so I don't know where to go from here
#16
| |||
| |||
|
|
It should be the same. I just copied and pasted what I use in all of my apps. Do you possibly have a form that has the ribbon property set to a ribbon that does not exist? -- AG Email: npATadhdataDOTcom "Roger" <lesperan... (AT) natpro (DOT) com> wrote in message news:4deaf3e0-59ef-443a-95da-04d268e2465a (AT) q36g2000vbi (DOT) googlegroups.com... On Nov 10, 6:28 am, "agiamb" <NOSPAMagi... (AT) newsgroup (DOT) nospam> wrote: Sorry, was going quickly and got caught in a word wrap. Didn't realize that the 'customui' was not the tag. Try a blank ribbon customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui" ribbon startFromScratch="true"/ /customUI If that works, build it back one element at a time. -- AG Email: npATadhdataDOTcom "Roger" <lesperan... (AT) natpro (DOT) com> wrote in message news:1f00cdc6-3012-473a-bffa-c20f507d4225 (AT) i41g2000vbn (DOT) googlegroups.com... On Nov 9, 2:30 pm, "agiamb" <NOSPAMagi... (AT) newsgroup (DOT) nospam> wrote: XML is case sensitive. customUI -- AG Email: npATadhdataDOTcom "Roger" <lesperan... (AT) natpro (DOT) com> wrote in message news:2d1d61b4-0164-4889-a7e4-76169d085767 (AT) 35g2000prb (DOT) googlegroups.com... On Nov 9, 10:29 am, Roger <lesperan... (AT) natpro (DOT) com> wrote: On Nov 9, 10:24 am, "agiamb" <NOSPAMagi... (AT) newsgroup (DOT) nospam> wrote: Sounds like there is something wrong with your ribbon xml, or a missing ribbon callback function, or something wrong with a callback function. -- AG Email: npATadhdataDOTcom "Roger" <lesperan... (AT) natpro (DOT) com> wrote in message news:53c6eca6-b55f-4f32-8069-c95f560c41eb (AT) o11g2000prf (DOT) googlegroups.com... On Nov 8, 3:52 pm, Roger <lesperan... (AT) natpro (DOT) com> wrote: On Nov 8, 2:28 pm, Roger <lesperan... (AT) natpro (DOT) com> wrote: On Nov 8, 1:58 pm, "David-W-Fenton" NoEm... (AT) SeeSignature (DOT) invalid wrote: Roger <lesperan... (AT) natpro (DOT) com> wrote innews:05e9ab7c-f9b4-4d9a-89e8-3b3d438c25f7 (AT) v28g2000prn (DOT) googlegroups.co m: I have a bound form with a docmd.maximize in the form open event, this crashes the system, even though I have error handling - it's been working fine for years with access97 A couple of things: 1. remove both On Error Resume Next statements. Neither has any effect whatsoever (the first is superseded by the call to a sub with error handling, the second happens as the last line before exiting the sub, where it can't have any effect, since there is no following line that can produce an error), and both are mis-used in your code. 2. have you tried moving the DoCmd.Maximize to before you set the Recordsource of your form? Or before you call LoadForm()? Or before you open your new form instance? The point is, that DoCmd.Maximize effects all windows that aren't PopUp windows, so you can call it anywhere -- it doesn't apply to the specific object you're opening, but to everything open in the MDI window (although, perhaps the tabbed and split forms in A2007/2010 work differently?). All that said, the first thing I'd check on is video drivers. This is a classic kind of case where buggy/outdated video drivers have often caused Access to crash in the past, so I'd check if moving the Maximize command doesn't have any effect. (my expectation is that if you move the Maximize to somewhere before the setting of the Recordsource that you're going to get an error when you set the Recordsource, or shortly thereafter) -- David W. Fentonhttp://www.dfenton.com/ contact via website onlyhttp://www.dfenton.com/DFA/ I moved the docmd.maximize to the top of formOpen(), same problem if I put a stop statement at the top of formOpen(), and stopped execution, and 'x' out of access, it crashes too if I put docmd.maximize at the top of editBusiness it doesn't crash so the only things that I step through from there are DoCmd.Maximize <- doesn't crash Set frm = New Form_frmBusiness Private Sub Form_Open(Cancel As Integer) DoCmd.Maximize <- crashes I will check the video drivers and the access SP's- Hide quoted text - - Show quoted text - I tried running the mdb using access2003, and I needed to comment out one line Application.LoadCustomUI "ribbon", strOut and is works fine with access2003, and with the line commented out it works fine with access2007 put the line back in, and it crashed I have a very simple quick toolbar ribbon, needed for use with the runtime, stored in an xml file the contents of the file is read into strOut in many applications I know there's another way to setup a ribbon, something about a hidden table, but I couldn't get it to work, thus the xml file I guess now I have to figure out how to use the table ....- Hide quoted text - - Show quoted text - I created a table uSysRibbons and loaded a record with my XLS data it now runs properly in access2003, cause it ignores the ribbon but still crashes with access2007 the office SP is up to date the video drivers are current now what can I try ?- Hide quoted text - - Show quoted text - I don't use callbacks, and this is the xml customUI xmlns="http://schemas.microsoft.com/office/2006/01/ customui" !--http://www.accessribbon.de/en/index.php-- ribbon startFromScratch="true" qat documentControls button idMso="FileSave"/ button idMso="Copy"/ button idMso="Paste"/ button idMso="PrintDialogAccess"/ button idMso="PrintPreviewClose"/ button idMso="FilterBySelection"/ button idMso="ApplyFilter"/ button idMso="AdpOutputOperationsSortAscending"/ button idMso="AdpOutputOperationsSortDescending"/ button idMso="ExportExcel"/ button idMso="ExportWord"/ button idMso="SpellingAccess"/ button idMso="WindowsCascade"/ button idMso="FileExit"/ /documentControls /qat /ribbon /customUI I will start trimming it until it works or....- Hide quoted text - - Show quoted text - this trimmed down xml causes the app to work properly customUI xmlns="http://schemas.microsoft.com/office/2006/01/ customui" /customUI this xml causes the crash customUI xmlns="http://schemas.microsoft.com/office/2006/01/ customui" ribbon startFromScratch="true" /ribbon /customUI I've checked other postings in this group, and the xml should / does hide the ribbon, but in some conditions, it crashes access2007- Hide quoted text - - Show quoted text - I presume you are referring to 'customui' at the end of the http string ? if so, it is correct because if I change it to 'customUI', and I turn on 'show add-in user interface errors', I get errors no errors if I use the lower case version if I change customUI /customUI to customui /customui I also get errors, so I'm thinking, with no errors, my XML must be correct- Hide quoted text - - Show quoted text - that ribbon loads but the application still crashes for some records what's the difference between what you propose and this customUI xmlns="http://schemas.microsoft.com/office/2006/01/ customui" ribbon startFromScratch="true" /ribbon /customUI>- Hide quoted text - - Show quoted text - |
same ribbon used for all
so I don't know where to go from here
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.