DoCmd Option Not Available At This Time

#1 (**permalink**) 28-Jul-2006, 08:13 AM

I Would like to confirm if "DoCmd.FindRecord" only works when one is
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/10526-docmd-option-not-available-at-time.html
working with open forms. I am doing a short batch program to find
duplicate entries. No forms are utilized. I noticed that "DoCmd.Beep"
works but the "DoCmd.FindRecord" does not, I get the error message that
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10526
his option is not available. I am assuming that "FindRecord" will
work, provided it is operating within an open form.

My workaround, for now, is to use the "DCount" option. If I get two
hits, then I know there is a duplicate entry.

*

#2 (**permalink**) 28-Jul-2006, 08:14 AM

The FindRecord action will search the active form, or the active table or
query open in datasheet view. It won't work if no form is active and no
table or query is open in datasheet view. To access (no pun, etc) data
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10526
without opening a form or a table or query in datasheet view, you can use
commands such as DCount or DLookup, or you can open a DAO or ADO recordset.

--
Brendan Reynolds
Access MVP

wrote in message
news:1148995176.688450.269780@u72g2000cwu.googlegr oups.com...
>I Would like to confirm if "DoCmd.FindRecord" only works when one is
> working with open forms. I am doing a short batch program to find
> duplicate entries. No forms are utilized. I noticed that "DoCmd.Beep"
> works but the "DoCmd.FindRecord" does not, I get the error message that
> his option is not available. I am assuming that "FindRecord" will
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10526
> work, provided it is operating within an open form.
>
> My workaround, for now, is to use the "DCount" option. If I get two
> hits, then I know there is a duplicate entry.
>

#3 (**permalink**) 28-Jul-2006, 08:14 AM

Thanks. You confirmed what I expected.

Brendan Reynolds wrote:
> The FindRecord action will search the active form, or the active table or
> query open in datasheet view. It won't work if no form is active and no
> table or query is open in datasheet view. To access (no pun, etc) data
> without opening a form or a table or query in datasheet view, you can use
> commands such as DCount or DLookup, or you can open a DAO or ADO recordset.
>
> --
> Brendan Reynolds
> Access MVP
>
>
> wrote in message
> news:1148995176.688450.269780@u72g2000cwu.googlegr oups.com...
> >I Would like to confirm if "DoCmd.FindRecord" only works when one is
> > working with open forms. I am doing a short batch program to find
> > duplicate entries. No forms are utilized. I noticed that "DoCmd.Beep"
> > works but the "DoCmd.FindRecord" does not, I get the error message that
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10526
> > his option is not available. I am assuming that "FindRecord" will
> > work, provided it is operating within an open form.
> >
> > My workaround, for now, is to use the "DCount" option. If I get two
> > hits, then I know there is a duplicate entry.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10526
> >