ACCESS FEED: Re: [MS_AccessPros] Control on Form Has Derived Data, Data Doesn't Persist to Table Column

Rabu, 25 Mei 2011

Re: [MS_AccessPros] Control on Form Has Derived Data, Data Doesn't Persist to Table Column

Thank you. Your suggestion regarding the AfterUpdate on RawData did work.
In answer to your question, I parsed the data field out on the form for user reading ease. After I had it parsed, I based my reporting on the column.
It would probably be a good idea to go back and adjust the process to use the query to parse the data.
Terryomsn
--- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@...> wrote:
>
> Probably the AfterUpdate of the RawData control.
>
> Private Sub RawData_AfterUpdate()
>
> Me.[Date 1] = Left(Right([RawData], 27), 8)
>
> End Sub
>
> I'm wondering why you're storing this calculated value. It would be easy to
> generate using the expression in a query on the table.
>
> 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/
> (Paris, France)
>
>
>
> -----Original Message-----
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Terry Olsen
> Sent: Wednesday, May 25, 2011 3:00 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: Re: [MS_AccessPros] Control on Form Has Derived Data, Data Doesn't
> Persist to Table Column
>
> Thanks, John.
> Right now I have the =Left(Right([RawData],27),8 expression in the Control
> Source. Where do I move this expression to pick up the parsed data from the
> RawData text box control?
> Terryomsn
> --- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@> wrote:
> >
> > Terry-O
> >
> > Set the Control Source of the Date 1 text box to the Date 1 field in the
> table.
> >
> > 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/
> > (Paris, France)
> >
> >
> > -----Original Message-----
> > From: MS_Access_Professionals@yahoogroups.com
> > [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of terryomsn
> > Sent: Wednesday, May 25, 2011 2:56 AM
> > To: MS_Access_Professionals@yahoogroups.com
> > Subject: [MS_AccessPros] Control on Form Has Derived Data, Data Doesn't
> Persist
> > to Table Column
> >
> > Hi,
> > In Access 2003,
> > I have a form that is based on one table called tblImportedData.
> > In the form, I have one bound text box [RawData] that I use to paste a file
> name
> > into.
> > During data entry, I parse the [RawData] text box into another form unbound
> text
> > control called [Date 1] using =Left(Right([RawData],27),8) after the RawData
> > text box control is populated.
> > The Date 1 text box correctly shows the 20110430 number that I'm looking for.
> > I also need the values in the Date 1 text box control to be updated into a
> [Date
> > 1] column in tblImportedData.
> >
> > How can I persist the 20110430 value from the form's Date 1 text control into
> > tblImportedData Date 1 column?
> >
> > Thanks for any help you can offer.
> >
> > Terryomsn
> >
> >
> >
> > ------------------------------------
> >
> > Yahoo! Groups Links
> >
>
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>