Re: Start options change subform update?

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Tom van Stiphout <no.spam.tom7744@xxxxxxx>
Date: Tue, 11 Dec 2007 07:57:13 -0700

On Tue, 11 Dec 2007 00:28:01 -0800, CarinKg
<CarinKg@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

If you suspect that the startup options contribute to the problem
you're observing, temporarily comment out that code and try again.

-Tom.

In a database I have a subform. The record source for this depends on two
succesive select-queries. Their sql content, set by VBA code, depend on
settings in the main form.
The subform works well, but only if I've used the shift-key to bypass an
AutoExec macro, ie when I'm redesigning it. When I start the DB in the
normal way, the subform either don't update the content according to settings
in the main form, or crash. No error messages.
The Start options for the database hide the database window, hide full menus
etc to prevent normal users from changing the design
The DB is designed in Access 2002, on a WinXP, all uppdated.
Suggestions on what's wrong and/or how to work around it?

Prev by Date: remove portion of string
Next by Date: Re: Cumulative Totals
Previous by thread: remove portion of string
Next by thread: RE: Recommendations on an Access Programming book
Index(es):
- Date
- Thread

Relevant Pages

Re: Limit Design View Access
... They would still be able to view the design of Tables and Queries, ... You can remove the database window, so users wouldn't be able to ... This is done in the Startup options. ... database from another Access app would be able to view your query and table design. ...
(microsoft.public.access.security)
Re: Message Alert
... the Startup options and add a coulpe of buttons to the Switchboard. ... is to uncheck the box for Show Database Window in the Startup options (Tools ... So the two strSQL lines needs to be changed also: ...
(microsoft.public.access.modulesdaovba)
Re: Using VBA to create start up options in Access
... create a MDE file of just the application parts (Queries, Forms, ... can open the database window simply by pressing F11. ... Using VBA to create start up options in Access ... What is the VBA code needed to change startup options for a specified ...
(microsoft.public.access.modulesdaovba)
Re: Showing Database Window
... I have a 2002 .mdb in which I want to allow viewing of the Database Window ... I can set the startup options to hide the database window, ... You can't use code to set startup options at runtime because the app will ...
(microsoft.public.access.formscoding)
Re: user permissions
... You can bypass the startup options by holding down the shift key ... re-enabling this shift bypass key. ... user might not see the database window nor he/she should be allowed to ... user id based startup environment in access, i have also tried to use ...
(microsoft.public.access.queries)