PC Review


Reply
Thread Tools Rate Thread

Autosaving forms

 
 
=?Utf-8?B?Q2hyaXN0aWFuID48Pg==?=
Guest
Posts: n/a
 
      19th Jun 2006
Is there a way to make a form automatically save after someone enters or
changes any data in any field?

It saves automatically when you go to a different record or close, but I
need it to do this when any of the fields are edited...
 
Reply With Quote
 
 
 
 
Terry Kreft
Guest
Posts: n/a
 
      19th Jun 2006
You're tryin to automatially save the record not the form.

In the AfterUpdate event of each control, in the code module behind the form
put
Me.Dirty = False



--

Terry Kreft


"Christian >" <(E-Mail Removed)> wrote in message
news:FC6D068C-5F8B-4AD2-BCA4-(E-Mail Removed)...
> Is there a way to make a form automatically save after someone enters or
> changes any data in any field?
>
> It saves automatically when you go to a different record or close, but I
> need it to do this when any of the fields are edited...



 
Reply With Quote
 
=?Utf-8?B?Q2hyaXN0aWFuID48Pg==?=
Guest
Posts: n/a
 
      19th Jun 2006
My bad on the form/report thing... I start to get all the terms mixed up.

Is there a place to put that code in one time, such as the form after
update, instead of on each control?

Perhaps I don't understand enough. By control you are referring to each
field of data, correct?

"Terry Kreft" wrote:

> You're tryin to automatially save the record not the form.
>
> In the AfterUpdate event of each control, in the code module behind the form
> put
> Me.Dirty = False
>
>
>
> --
>
> Terry Kreft
>
>
> "Christian >" <(E-Mail Removed)> wrote in message
> news:FC6D068C-5F8B-4AD2-BCA4-(E-Mail Removed)...
> > Is there a way to make a form automatically save after someone enters or
> > changes any data in any field?
> >
> > It saves automatically when you go to a different record or close, but I
> > need it to do this when any of the fields are edited...

>
>
>

 
Reply With Quote
 
=?Utf-8?B?Q2hyaXN0aWFuID48Pg==?=
Guest
Posts: n/a
 
      19th Jun 2006
Sorry. I figured it out.

"Terry Kreft" wrote:

> You're tryin to automatially save the record not the form.
>
> In the AfterUpdate event of each control, in the code module behind the form
> put
> Me.Dirty = False
>
>
>
> --
>
> Terry Kreft
>
>
> "Christian >" <(E-Mail Removed)> wrote in message
> news:FC6D068C-5F8B-4AD2-BCA4-(E-Mail Removed)...
> > Is there a way to make a form automatically save after someone enters or
> > changes any data in any field?
> >
> > It saves automatically when you go to a different record or close, but I
> > need it to do this when any of the fields are edited...

>
>
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Autosaving Steve Microsoft Excel Programming 2 29th Feb 2008 03:35 PM
autosaving as .html not .htm Jesse Hand Microsoft Frontpage 3 15th Apr 2004 09:15 PM
Autosaving Bryn Microsoft Excel Programming 0 5th Feb 2004 10:58 AM
Autosaving Workbook Microsoft Microsoft Excel Programming 6 8th Jan 2004 01:59 PM
autosaving shortcuts? why is it doing this???? moe Microsoft Excel Misc 1 9th Sep 2003 11:55 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:52 AM.