Re: a form as front-end to a table of execution parameters

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

In news:1A56D0E3-6ACF-4950-84E5-33DCC7D9F3DF@xxxxxxxxxxxxx,
Allen_N <AllenN@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
Thanks Marshall.

Thats seems right, but I had previously tried many combinations of
settings and decided to stay as close to default as possible until I
could find out how they interact. Some settings caused the text boxes
to disappear when I switched out of Design View.

I seem to have got past the disappearing data problem (by setting
Cycle to Current Record, but the table still doesn't update when I
leave a text box.

The table will not normally be updated until one of several things
happens:

(a) You go to a new record on the form ... but you've set Cycle to
"Current Record", so that's not going to happen automatically,

or

(b) You close the form, forcing Access to save the "dirty" record,

or

(c) You explicitly tell Access to save the record, by pressing
Shift+Enter or choosing menu item Records -> Save Record or Records ->
Refresh,

or

(d) You execute one of several possible statements in code (or execute a
macro action) that forces Access to save the record.

If you're doing one of these things, and yet the modified record isn't
being saved, then there's something wrong. If you're not doing any of
these things, then from your description, Access is behaving as
designed; in which case the only question is, do you need to change
this behavior? If so, there are ways to do it. You can force Access to
save the record as soon as you modify any of the fields on the form, if
that's what you want. It'll take a little code, but it's no big deal.
However, people usually want to delay saving a record until they've made
all the changes to it that they intend to make, and then indicate in
some fashion that they're satisfied with them.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)


.

Relevant Pages

  • Re: /bin/sh does not read profile
    ... because my standard dialog shell is the system's ... C shell, the files important are /etc/cshrc with the settings, ... start some programs and then exec the window manager / desktop ... it's last action is to execute ~/.xinitrc. ...
    (freebsd-questions)
  • Re: Unable to browse a page IIS 6.0 Settings.
    ... To get your ASP.NET files to work you'll need ASP.NET enabled AND execute ... I do not do technical support via email. ... "Atul" wrote in message ... These settings ...
    (microsoft.public.inetserver.iis.security)
  • Re: v2005 vs. v2008 Configuration settings
    ... settings of the new v2008 to match the "generic" app wizard configuration ... The applications compile/link OK, but the programs do not execute ... When you say it doesn't execute correctly, ... I apologize for the confusion, ...
    (microsoft.public.dotnet.languages.vc)
  • Re: Set a program to run before a user logs in?
    ... You could have a Computer Startup script executed through a GPO. ... Check out gpedit.msc, Computer Configuration, Windows Settings, Scripts, ... > Is it possible to have the computer execute a program before a user logs ...
    (microsoft.public.windowsxp.general)
  • Problem with Item.Size
    ... returns something other than zero for some users even on first opening it, ... the block of code does not execute. ... Is she using Item.Size wrong or is there a situation where the clients ... settings can cause data to be written to the page changing the Item.Size ...
    (microsoft.public.outlook.program_forms)