A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Thanks Ling Adams for your detailed & succinct answer...



 
 
Thread Tools Display Modes
  #1  
Old August 28th, 2008, 08:28 PM posted to microsoft.public.access.forms
Tank
external usenet poster
 
Posts: 45
Default Thanks Ling Adams for your detailed & succinct answer...

Thanks Ling Adams for your detailed and succinct answer to a question I and
many others pondered in how to copy or repeat form values from one record to
the next. In your reply to JaneM, “Preautopopulate from records” on 8-26-08,
you brought out the simple example that “People doing "batch" data entries
often find themselves entering ***some*** fields over and over again, and can
benefit from the technique I offered.”

I especially appreciated your intuition in diagnosing the question and
providing a carefully worded summary interpretation of what you believed the
person was referring to: “If, by ‘copying (autopopulating) data from the
previous record’ you mean can you enter one record, move to a new record and
have certain fields populated with the same values from the previous record,
yes you can and yes, it'll require code.” You go on to explain precisely how
this can be done.

Note for readers who are interested in Ling’s full answer to this pre-auto
fill question, please see “Preautopopulate Form Records” in Form Design,
8-26-08.

I am surprised that this need to repeat form values from one record to the
next is even being questioned as to why.

In your reply you brought out the simple example that “People doing "batch"
data entries often find themselves entering ***some*** fields over and over
again, and can benefit from the technique I offered.”

This “auto-fill” question has been raised and answered many times in the
past. Here are some other very good references on this subject supporting
Ling’s excellent response to JaneM:

4-02-08 Auto Fill (Dave Hargis)
11-16-07 Create a Duplicate Record (Allen Browne)
8-07-07 Repeat Form Values From 1 Record to the Next (Doug Steele)
6-07-07 Copying a Previous Entry (Sprinks)

- -
Tank

 




Thread Tools
Display Modes

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

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:08 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 OfficeFrustration.
The comments are property of their posters.