Can anyone tell me if it's possible to use the WindowMode argument to
hide a window and still make changes in the window?

I have a form that i have a macro open a form- update data - then
close again, and i would like the user NOT to see the form open and
close. Is this possible?

thanks
Steve

fishqqq (AT) hotmail (DOT) com wrote:
Does this syntax work
docmd.openform "Test",acNormal,,,,acHidden

You could try using the echo method. Be careful and make sure you have
docmd.Echo True execute even if the code fails.

Public Sub HiddenForm()
DoCmd.Echo False
DoCmd.OpenForm "FAQ Details"
'Do stuff here
DoCmd.Close acForm, "FAQ Details"
DoCmd.Echo True
End Sub

There is an echo action available in macros.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

On 4/14/2011 9:09 AM, fishqqq (AT) hotmail (DOT) com wrote:

Making updates by using a macro to open and close a form seems an
ineffective approach. Have you considered simply updating from macros or
code, not by changing data on a form?

You can execute update, append, or delete queries... no form needed... and
avoid the extra overhead of unhiding and hiding the form. With more detail
on what you want to do, possibly someone could help you do this with
macros... I just don't use them... but am one of the many here who could
likely help you accomplish it with VBA code.

Larry Linson
Microsoft Office Access

<fishqqq (AT) hotmail (DOT) com> wrote

fishqqq (AT) hotmail (DOT) com wrote:

As I said in your other thread with this question, I think
the problem is the way you are referencing the form you want
to update.

--
Marsh

On Apr 14, 7:09*am, "fish... (AT) hotmail (DOT) com" <fish... (AT) hotmail (DOT) com> wrote:
if you're just updating data, why do you need a form (especially if
you don't want the user to see it)
just execute an update query

On Apr 14, 2:08*pm, "Access Developer" <accde... (AT) gmail (DOT) com> wrote:
thanks Larry,
I'm a lot more comfortable using macros/forms/tables etc then i am
with VBA code - which is why i'm trying to do this this way. I'm going
to try a couple more ideas and if i'm still stuck i may ask for your
help (vba or otherwise) -
tks
Steve

The overhead of updating a table by automating a Form with Macros is
substantial.

I have solved the problem of "flashing forms" for some people by directly
updating the table. Where's the data coming from that you are using to
update? You might be able to do it by executing an action query from a
macro.

But, if you're not sufficiently interested to describe what you're trying to
do, not how, then good luck.

Larry Linson
Microsoft Office Access MVP

<fishqqq (AT) hotmail (DOT) com> wrote

On Apr 14, 2:08 pm, "Access Developer" <accde... (AT) gmail (DOT) com> wrote:
thanks Larry,
I'm a lot more comfortable using macros/forms/tables etc then i am
with VBA code - which is why i'm trying to do this this way. I'm going
to try a couple more ideas and if i'm still stuck i may ask for your
help (vba or otherwise) -
tks
Steve