|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#21
December 10th, 2008, 04:35 PM
posted to microsoft.public.access
|
|||
|
|||
The OpenForm action was cancelled since upgrade from 2003 to 2
"David Harris" wrote in message
... I checked the "On Open", "On Load" or "On Activate" lines. There is nothing on the "On Load" or "On Activate" lines. On the "On Open" line there is a Macro called Mcr Open1/9CheckHrs. When checking this it has 10 actions in the Macro. Run Macro - Mcr Check Access Hrs1 Run Macro - Mcr Check Access Hrs2 Run Macro - Mcr Check Access Hrs3 Run Macro - Mcr Check Access Hrs4 Run Macro - Mcr Check Access Hrs5 Run Macro - Mcr Check Access Hrs6 Run Macro - Mcr Check Access Hrs7 Run Macro - Mcr Check Access Hrs8 Run Macro - Mcr Check Access Hrs9 Run Macro - Mcr Check Access Hrs10 Mcr Check Access Hrs1 (Contents below - All other macros are the smae except 1 Hours changes to 2 and so on depending on the Mcr name) [Forms]![Fm1/9 C1 Access Course]![Fm1/9 C1 Access CourseSubform].[Form]![C1Day 1 Hours][Forms]![Fm1/9 C1 Access Course]![Fm1/9 C1 Access CourseSubform].[Form]![Fm1/92 All Access Hrs Check subfm].[Form]![Day 1 Hours] Action = MsgBox ... Action = SetValue ... Action = SetValue [Forms]![Fm1/9 C1 Access Course]![Fm1/9 C1 Access CourseSubform].[Form]![C1Day 1 Hours]=0 Action = SetValue ... Action = StopMacro [Forms]![Fm1/9 C1 Access Course]![Fm1/9 C1 Access CourseSubform].[Form]![C1Day 1 Hours]=[Forms]![Fm1/9 C1 Access Course]![Fm1/9 C1 Access CourseSubform].[Form]![Fm1/92 All Access Hrs Check subfm].[Form]![Day 1 Hours] Action = SetValue [Forms]![Fm1/9 C1 Access Course]![Fm1/9 C1 Access CourseSubform].[Form]![C1Day 1 Hours][Forms]![Fm1/9 C1 Access Course]![Fm1/9 C1 Access CourseSubform].[Form]![Fm1/92 All Access Hrs Check subfm].[Form]![Day 1 Hours] Action = SetValue I'm having trouble interpreting the macro actions as you reported them, but before delving deeper into it, let's find out if that macro could be at fault. Try removing the macro ("Mcr Open1/9CheckHrs") from the On Open property line of the form, and see if the form can now be opened. -- Dirk Goldgar, MS Access MVP www.datagnostics.com (please reply to the newsgroup) 
|
|
#22
December 11th, 2008, 09:23 AM
posted to microsoft.public.access
|
|||
|
|||
|
The OpenForm action was cancelled since upgrade from 2003 to 2
Hi Dirk,
I removed the macro ("Mcr Open1/9CheckHrs") from the On Open property line of the form and it opened fine. It also opened from the button. It appears that the Macro is casuing the problem. David "Dirk Goldgar" wrote: "David Harris" wrote in message ... I checked the "On Open", "On Load" or "On Activate" lines. There is nothing on the "On Load" or "On Activate" lines. On the "On Open" line there is a Macro called Mcr Open1/9CheckHrs. When checking this it has 10 actions in the Macro. Run Macro - Mcr Check Access Hrs1 Run Macro - Mcr Check Access Hrs2 Run Macro - Mcr Check Access Hrs3 Run Macro - Mcr Check Access Hrs4 Run Macro - Mcr Check Access Hrs5 Run Macro - Mcr Check Access Hrs6 Run Macro - Mcr Check Access Hrs7 Run Macro - Mcr Check Access Hrs8 Run Macro - Mcr Check Access Hrs9 Run Macro - Mcr Check Access Hrs10 Mcr Check Access Hrs1 (Contents below - All other macros are the smae except 1 Hours changes to 2 and so on depending on the Mcr name) [Forms]![Fm1/9 C1 Access Course]![Fm1/9 C1 Access CourseSubform].[Form]![C1Day 1 Hours][Forms]![Fm1/9 C1 Access Course]![Fm1/9 C1 Access CourseSubform].[Form]![Fm1/92 All Access Hrs Check subfm].[Form]![Day 1 Hours] Action = MsgBox ... Action = SetValue ... Action = SetValue [Forms]![Fm1/9 C1 Access Course]![Fm1/9 C1 Access CourseSubform].[Form]![C1Day 1 Hours]=0 Action = SetValue ... Action = StopMacro [Forms]![Fm1/9 C1 Access Course]![Fm1/9 C1 Access CourseSubform].[Form]![C1Day 1 Hours]=[Forms]![Fm1/9 C1 Access Course]![Fm1/9 C1 Access CourseSubform].[Form]![Fm1/92 All Access Hrs Check subfm].[Form]![Day 1 Hours] Action = SetValue [Forms]![Fm1/9 C1 Access Course]![Fm1/9 C1 Access CourseSubform].[Form]![C1Day 1 Hours][Forms]![Fm1/9 C1 Access Course]![Fm1/9 C1 Access CourseSubform].[Form]![Fm1/92 All Access Hrs Check subfm].[Form]![Day 1 Hours] Action = SetValue I'm having trouble interpreting the macro actions as you reported them, but before delving deeper into it, let's find out if that macro could be at fault. Try removing the macro ("Mcr Open1/9CheckHrs") from the On Open property line of the form, and see if the form can now be opened. -- Dirk Goldgar, MS Access MVP www.datagnostics.com (please reply to the newsgroup)
|
|
#23
December 12th, 2008, 08:41 PM
posted to microsoft.public.access
|
|||
|
|||
|
The OpenForm action was cancelled since upgrade from 2003 to 2
"David Harris" wrote in message
... Hi Dirk, I removed the macro ("Mcr Open1/9CheckHrs") from the On Open property line of the form and it opened fine. It also opened from the button. It appears that the Macro is casuing the problem. Sure looks like it. I had trouble interpreting your post of the actions of "Mcr Check Access Hrs1". Can you try removing all the other macros executed by "Mcr Open1/9CheckHrs", leaving only "Mcr Check Access Hrs1", and see if that macro makes it fail all by itself? If it does, then we can focus on that one macro. If not, then you can successively try out all the other macros to see which one(s) causes the error. -- Dirk Goldgar, MS Access MVP www.datagnostics.com (please reply to the newsgroup)
|
|
#24
December 16th, 2008, 09:43 AM
posted to microsoft.public.access
|
|||
|
|||
|
The OpenForm action was cancelled since upgrade from 2003 to 2
I removed all the entries in "Mcr Open1/9CheckHrs" except "Mcr Check Access
Hrs1" and tried to open the form. The smae thing happens. "Dirk Goldgar" wrote: "David Harris" wrote in message ... Hi Dirk, I removed the macro ("Mcr Open1/9CheckHrs") from the On Open property line of the form and it opened fine. It also opened from the button. It appears that the Macro is casuing the problem. Sure looks like it. I had trouble interpreting your post of the actions of "Mcr Check Access Hrs1". Can you try removing all the other macros executed by "Mcr Open1/9CheckHrs", leaving only "Mcr Check Access Hrs1", and see if that macro makes it fail all by itself? If it does, then we can focus on that one macro. If not, then you can successively try out all the other macros to see which one(s) causes the error. -- Dirk Goldgar, MS Access MVP www.datagnostics.com (please reply to the newsgroup)
|
|
#25
December 16th, 2008, 03:36 PM
posted to microsoft.public.access
|
|||
|
|||
|
The OpenForm action was cancelled since upgrade from 2003 to 2
"David Harris" wrote in message
... I removed all the entries in "Mcr Open1/9CheckHrs" except "Mcr Check Access Hrs1" and tried to open the form. The smae thing happens. So it looks like there's a problem in that macro, and possibly the other ones if they follow the same pattern. Since you say it worked under Access 2003, I wonder what the problem can be. I was not able to make much sense of your original posting of the macro -- a fault of the posting format, not of the macro. If I were you, I would inspect every step of the macro to make sure that all named objects -- forms, controls, tables, fields, etc. -- are still present and named as expected. Failing that, would you mind posting the macro again, making sure that each macro action is completely described, including any conditions or arguments? Maybe I -- or someone else -- will be able to see something. -- Dirk Goldgar, MS Access MVP www.datagnostics.com (please reply to the newsgroup)
|
|
#26
December 16th, 2008, 04:01 PM
posted to microsoft.public.access
|
|||
|
|||
|
The OpenForm action was cancelled since upgrade from 2003 to 2
Here is a copy of the Macro. I hope this is better.
CONDITION = [Forms]![Fm1/9 C1 Access Course]![Fm1/9 C1 Access CourseSubform].[Form]![C1Day 1 Hours][Forms]![Fm1/9 C1 Access Course]![Fm1/9 C1 Access CourseSubform].[Form]![Fm1/92 All Access Hrs Check subfm].[Form]![Day 1 Hours] ACTION = MsgBox CONDITION = ... ACTION = SetValue ITEM = [Forms]![Fm1/9 C1 Access Course]![Fm1/9 C1 Access CourseSubform].[Form]![C1Day 1 Hours] EXPRESSION = 0 CONDITION = ... ACTION = SetValue ITEM = [Forms]![Fm1/9 C1 Access Course]![Fm1/9 C1 Access CourseSubform].[Form]![C1Day1Comp] EXPRESSION = No CONDITION = [Forms]![Fm1/9 C1 Access Course]![Fm1/9 C1 Access CourseSubform].[Form]![C1Day 1 Hours]=0 ACTION = SetValue EXPRESSION = No CONDITION = ... ACTION = StopMacro CONDITION = [Forms]![Fm1/9 C1 Access Course]![Fm1/9 C1 Access CourseSubform].[Form]![C1Day 1 Hours]=[Forms]![Fm1/9 C1 Access Course]![Fm1/9 C1 Access CourseSubform].[Form]![Fm1/92 All Access Hrs Check subfm].[Form]![Day 1 Hours] ACTION = SetValue EXPRESSION = Yes CONDITION = [Forms]![Fm1/9 C1 Access Course]![Fm1/9 C1 Access CourseSubform].[Form]![C1Day 1 Hours][Forms]![Fm1/9 C1 Access Course]![Fm1/9 C1 Access CourseSubform].[Form]![Fm1/92 All Access Hrs Check subfm].[Form]![Day 1 Hours] ACTION = SetValue EXPRESSION = No Regards, David "Dirk Goldgar" wrote: "David Harris" wrote in message ... I removed all the entries in "Mcr Open1/9CheckHrs" except "Mcr Check Access Hrs1" and tried to open the form. The smae thing happens. So it looks like there's a problem in that macro, and possibly the other ones if they follow the same pattern. Since you say it worked under Access 2003, I wonder what the problem can be. I was not able to make much sense of your original posting of the macro -- a fault of the posting format, not of the macro. If I were you, I would inspect every step of the macro to make sure that all named objects -- forms, controls, tables, fields, etc. -- are still present and named as expected. Failing that, would you mind posting the macro again, making sure that each macro action is completely described, including any conditions or arguments? Maybe I -- or someone else -- will be able to see something. -- Dirk Goldgar, MS Access MVP www.datagnostics.com (please reply to the newsgroup)
|
|
#27
December 16th, 2008, 05:54 PM
posted to microsoft.public.access
|
|||
|
|||
|
The OpenForm action was cancelled since upgrade from 2003 to 2
"David Harris" wrote in message
... Here is a copy of the Macro. I hope this is better. CONDITION = [Forms]![Fm1/9 C1 Access Course]![Fm1/9 C1 Access CourseSubform].[Form]![C1Day 1 Hours][Forms]![Fm1/9 C1 Access Course]![Fm1/9 C1 Access CourseSubform].[Form]![Fm1/92 All Access Hrs Check subfm].[Form]![Day 1 Hours] ACTION = MsgBox CONDITION = ... ACTION = SetValue ITEM = [Forms]![Fm1/9 C1 Access Course]![Fm1/9 C1 Access CourseSubform].[Form]![C1Day 1 Hours] EXPRESSION = 0 CONDITION = ... ACTION = SetValue ITEM = [Forms]![Fm1/9 C1 Access Course]![Fm1/9 C1 Access CourseSubform].[Form]![C1Day1Comp] EXPRESSION = No CONDITION = [Forms]![Fm1/9 C1 Access Course]![Fm1/9 C1 Access CourseSubform].[Form]![C1Day 1 Hours]=0 ACTION = SetValue EXPRESSION = No CONDITION = ... ACTION = StopMacro CONDITION = [Forms]![Fm1/9 C1 Access Course]![Fm1/9 C1 Access CourseSubform].[Form]![C1Day 1 Hours]=[Forms]![Fm1/9 C1 Access Course]![Fm1/9 C1 Access CourseSubform].[Form]![Fm1/92 All Access Hrs Check subfm].[Form]![Day 1 Hours] ACTION = SetValue EXPRESSION = Yes CONDITION = [Forms]![Fm1/9 C1 Access Course]![Fm1/9 C1 Access CourseSubform].[Form]![C1Day 1 Hours][Forms]![Fm1/9 C1 Access Course]![Fm1/9 C1 Access CourseSubform].[Form]![Fm1/92 All Access Hrs Check subfm].[Form]![Day 1 Hours] ACTION = SetValue EXPRESSION = No When you say ... CONDITION = ... .... do you mean there is no condition, or that you haven't posted it? You have several SetValue actions for which you haven't posted the Item for which the value is being set. Is that an oversight? -- Dirk Goldgar, MS Access MVP www.datagnostics.com (please reply to the newsgroup)
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
