DoCmd Sometimes does not appear to work

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Michael Hudston - 28 Apr 2008 14:54 GMT

I have a very strange symptom occuring. I am developing and testing a Client
Management Database, and for some reason. One of the "DoCmd.Openform" lines
I am using does not appear to work, when placed the Front End database, is
installed on to the machine that it will be running on.

It works ok, on the test bed Its a simple command

DoCmd.OpenForm "RMA Details", , , , acFormAdd

I use similar commands throughout the database on several switchboards, and
these all work ok.

Is there something simple I am missing? I think I have checked all the
permissions and settings for Macro's etc so they are the same from the Test
bed to the live machine, but still to no avail.

Help

Reply to this Message

Alex Dybenko - 28 Apr 2008 15:51 GMT

Hi,
if only one form fails to open - then could be that form has code running in
open event and it fails due to missing references

Signature

Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

>I have a very strange symptom occuring. I am developing and testing a
>Client
[quoted text clipped - 17 lines]
>
> Help

Reply to this Message

Michael Hudston - 29 Apr 2008 11:58 GMT

That doesnt appear to be the issue as there is no on open or on load event on
the target form.

The only event is afterupate which is a me.refresh

> Hi,
> if only one form fails to open - then could be that form has code running in
[quoted text clipped - 21 lines]
> >
> > Help

Reply to this Message

Alex Dybenko - 29 Apr 2008 12:02 GMT

But this is the only form that dont open?

Signature

Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

> That doesnt appear to be the issue as there is no on open or on load event
> on
[quoted text clipped - 29 lines]
>> >
>> > Help

Reply to this Message

Michael Hudston - 29 Apr 2008 15:17 GMT

This is now one of two forms that does not open. Both are using the
DoCMd.OpenForm to open them, no special arguments are being used and other
forms are using similar commands to open forms from the switch board.

Yet the very same database works on the Test Bed. This makes me think it is
a permissions issue or something to do with the set up of access on the live
machine.

> But this is the only form that dont open?
>
[quoted text clipped - 31 lines]
> >> >
> >> > Help

Reply to this Message

Alex Dybenko - 29 Apr 2008 15:54 GMT

try to put an error handler in this proc, and check if you get any error. if
no - then, hmm, perhaps recreate form again. no more ideas so far

Signature

Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

> This is now one of two forms that does not open. Both are using the
> DoCMd.OpenForm to open them, no special arguments are being used and other
[quoted text clipped - 49 lines]
>> >> >
>> >> > Help

Reply to this Message

Robert Morley - 29 Apr 2008 18:33 GMT

I think Alex has covered everything, but one possibility that came to mind
to double-check: there isn't something that's silently cancelling the Open
Form, is there (i.e., setting the Cancel value in Form_Open)? Maybe
something that doesn't happen on the test bed due to the specific records
you're opening or something to that effect?

Just a thought.

Rob

> This is now one of two forms that does not open. Both are using the
> DoCMd.OpenForm to open them, no special arguments are being used and other
[quoted text clipped - 3 lines]
> a permissions issue or something to do with the set up of access on the live
> machine.

Reply to this Message

Michael Hudston - 30 Apr 2008 11:52 GMT

Well, I have now got it to work, although I still do not know what the
origional problem was.

I deleted the button and used the button wizard re-create the code, which
then I copied and pasted on to my own button event procedure.

The only difference I an tell between the DoCmd.Openform commands is that
the izard used Null values between quotes "" in the command line, where as I
have not.

> This is now one of two forms that does not open. Both are using the
> DoCMd.OpenForm to open them, no special arguments are being used and other
[quoted text clipped - 39 lines]
> > >> >
> > >> > Help

Reply to this Message