Terry-
Then I don't understand what you're trying to do!
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Villefranche-sur-mer, France)
------------------------------
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Terry Olsen
Sent: Tuesday, April 24, 2012 7:20 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: Forms Population Question
During initial data entry, the Badge is not in tblCurrentPersonnel, but will be
once entered.
--- In MS_Access_Professionals@yahoogroups.com, John Viescas <JohnV@...> wrote:
>
> Terry-
>
> If Badge is in tblCurrentPersonnel, you can use the AfterUpdate event of the
> Badge control to open a recordset on tblCurrentPersonnel for records with the
> same Badge number. Grab the first record (if any), and populate the fields you
> want. You can leave the text boxes unlocked so the user can change stuff after
> your code loads the "default" values.
>
> John Viescas, author
> Microsoft Office Access 2010 Inside Out
> Microsoft Office Access 2007 Inside Out
> Building Microsoft Access Applications
> Microsoft Office Access 2003 Inside Out
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Villefranche-sur-mer, France)
>
> ------------------------------------------------
>
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Terry Olsen
> Sent: Monday, April 23, 2012 3:09 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: [MS_AccessPros] Re: Forms Population Question
>
>
> The record source of the form is tblCurrentPersonnel. All controls are bound
> controls. Badge, ID, PIN, Name are text boxes. Currently, I enter the same
data
> into each of them, varying only Name to a slight degree.
> What I'd like to have the form do is:
> 1) I enter a value into badge
> 2) I move to another control on the form and
> 3) PIN, ID, and Name values are populated from Badge
> 4) I'd also need to have Name be editable as I still need to add the
> concatenation.
> Thanks
> Terryomsn
>
> --- In MS_Access_Professionals@yahoogroups.com, John Viescas <JohnV@> wrote:
> >
> > Terry-
> >
> > OK, what's the Record Source of the form, and please explain how you're
using
> > Badge, ID, Name, and Pin and how you expect some values to autopopulate.
> >
> > John Viescas, author
> > Microsoft Office Access 2010 Inside Out
> > Microsoft Office Access 2007 Inside Out
> > Building Microsoft Access Applications
> > Microsoft Office Access 2003 Inside Out
> > SQL Queries for Mere Mortals
> > http://www.viescas.com/
> > (Villefranche-sur-mer, France)
> >
> > ------------------------------------
> >
> > From: MS_Access_Professionals@yahoogroups.com
> > [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Terry Olsen
> > Sent: Sunday, April 22, 2012 7:21 PM
> > To: MS_Access_Professionals@yahoogroups.com
> > Subject: [MS_AccessPros] Re: Forms Population Question
> >
> >
> > Thanks, Duane. I am not storing duplicate values in the table.
> > Terryomsn
> >
> > --- In MS_Access_Professionals@yahoogroups.com, "Duane" <duanehookom@>
wrote:
> > >
> > > Terryomsn,
> > >
> > > I think John was asking for more information regarding your tables. Are
you
> > really storing multiple duplicate values in the same table? Is the form
bound
> to
> > some type of a transaction table? Is there a separate employee table?
> > >
> > > How about provide more context to what you are trying to do so someone can
> > give the best help?
> > >
> > > Duane Hookom
> > > MS Access MVP
> > >
> > > --- In MS_Access_Professionals@yahoogroups.com, "Terry Olsen" <terryomsn@>
> > wrote:
> > > >
> > > > Thanks for your response.
> > > > I currently have a bound control for each of four employee fields Badge,
> ID,
> > Name, and Pin. While using the form, I've found that Badge needs to entered,
> and
> > 2 of the 3 other values are always the same and the third (Name) varies only
> by
> > the concatenation of a 2 character code. That works fine if I continue to
> enter
> > the same value 3 times.
> > > > While trying alternatives, I added 3 text boxes intending to display the
> > value entered in Badge in ID, Name, and PIN after the Badge control had been
> > populated and the user moved to another control on the form.
> > > >
> > > > Do I need to have these 3 additional text boxes or is it possible to
> > populate the original bound controls in the same manner?
> > > >
> > > > I've been studying the Access 2010 Inside Out book. While I have found
> > information on what the control and form events are, I haven't found a
> > discussion yet that pertains to populating forms in this manner. I am also
> > looking for how and when, or if I can, reference the values in the control
and
> > record buffers.
> > > > Thanks
> > > > Terryomsn
> > > >
> > > > --- In MS_Access_Professionals@yahoogroups.com, John Viescas <JohnV@>
> wrote:
> > > > >
> > > > > Terry-
> > > > >
> > > > > How is the table containing those three fields related to the table
> you're
> > > > > editing? Access might fetch that info for you automatically if you
> include
> > that
> > > > > table in your form's Record Source, and it's linked on Badge.
> > > > >
> > > > > John Viescas, author
> > > > > Microsoft Office Access 2010 Inside Out
> > > > > Microsoft Office Access 2007 Inside Out
> > > > > Building Microsoft Access Applications
> > > > > Microsoft Office Access 2003 Inside Out
> > > > > SQL Queries for Mere Mortals
> > > > > http://www.viescas.com/
> > > > > (Villefranche-sur-mer, France)
> > > > >
> > > > > -----------------------------------
> > > > >
> > > > > From: MS_Access_Professionals@yahoogroups.com
> > > > > [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Terry
> Olsen
> > > > > Sent: Saturday, April 21, 2012 6:45 AM
> > > > > To: MS_Access_Professionals@yahoogroups.com
> > > > > Subject: [MS_AccessPros] Forms Population Question
> > > > >
> > > > >
> > > > > For a new entry, I have a data entry form that I want to reduce
> keystrokes
> > on.
> > > > > In one bound control, badge, after initial data entry, I want to
> populate
> > three
> > > > > other text boxes, txtEmployeeId, txtEmployeePin, and txtEmployeeID.
> After
> > all
> > > > > entries on the form are complete, I want to populate fields in the DB
> > table
> > > > > columns for each of them.
> > > > > Which event do I use?
> > > > > What persists the data to the relevant DB record?
> > > > > Thanks
> > > > > Terryomsn
> > > > >
> > > >
> > >
> >
>
Tidak ada komentar:
Posting Komentar