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

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