After Update Event
in [General]
|
Prev: all custom harley softail for sale or trade
Next: Getting Data from Pastel Partner 2009 Files in Access
From: Ms-Exl-Learner on 8 May 2010 02:28 After Update Event Hi All, I am having a table like the below:- Table Name : DCData Field Name Type Document Presented Yes/No Date Date/Time I have created a form Using Wizard and get the fields from DCdata Table to my form. Form Name: DCData (F) I require a after update event macro for my [Document Presented] field (Yes/No) if the person check the [Document Presented] check box then the form should show the [Date] field otherwise if it is unchecked then the [Date] field should not be visible and cannot be accessed by the users. (Using Access 2003) Awaiting for your reply. -------------------- (Ms-Exl-Learner) --------------------
From: Arvin Meyer [MVP] on 8 May 2010 08:27 I don't write macros, but here's some VBA code: Private Sub Document_Presented_AfterUpdate() If Me.[PDocument Presented] = True Then Me.[Date].Visible = True Else Me.[Date].Visible = False End If End Sub You will also need to use similar code in the form's current event. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.accessmvp.com http://www.mvps.org/access "Ms-Exl-Learner" <MsExlLearner(a)discussions.microsoft.com> wrote in message news:68FC0C6C-A846-411C-B615-1150A6CF7103(a)microsoft.com... > After Update Event > > Hi All, > > I am having a table like the below:- > > Table Name : DCData > > Field Name Type > Document Presented Yes/No > Date Date/Time > > I have created a form Using Wizard and get the fields from DCdata Table to > my form. > > Form Name: DCData (F) > > I require a after update event macro for my [Document Presented] field > (Yes/No) if the person check the [Document Presented] check box then the > form > should show the [Date] field otherwise if it is unchecked then the [Date] > field should not be visible and cannot be accessed by the users. (Using > Access 2003) > > Awaiting for your reply. > > -------------------- > (Ms-Exl-Learner) > --------------------
From: Ms-Exl-Learner on 8 May 2010 12:14 Thank you very much!!! -------------------- (Ms-Exl-Learner) -------------------- "Arvin Meyer [MVP]" wrote: > I don't write macros, but here's some VBA code: > > Private Sub Document_Presented_AfterUpdate() > If Me.[PDocument Presented] = True Then > Me.[Date].Visible = True > Else > Me.[Date].Visible = False > End If > End Sub > > You will also need to use similar code in the form's current event. > -- > Arvin Meyer, MCP, MVP > http://www.datastrat.com > http://www.accessmvp.com > http://www.mvps.org/access > > > "Ms-Exl-Learner" <MsExlLearner(a)discussions.microsoft.com> wrote in message > news:68FC0C6C-A846-411C-B615-1150A6CF7103(a)microsoft.com... > > After Update Event > > > > Hi All, > > > > I am having a table like the below:- > > > > Table Name : DCData > > > > Field Name Type > > Document Presented Yes/No > > Date Date/Time > > > > I have created a form Using Wizard and get the fields from DCdata Table to > > my form. > > > > Form Name: DCData (F) > > > > I require a after update event macro for my [Document Presented] field > > (Yes/No) if the person check the [Document Presented] check box then the > > form > > should show the [Date] field otherwise if it is unchecked then the [Date] > > field should not be visible and cannot be accessed by the users. (Using > > Access 2003) > > > > Awaiting for your reply. > > > > -------------------- > > (Ms-Exl-Learner) > > -------------------- > > > . >
From: nieves o. marberry on 8 May 2010 21:57
"Ms-Exl-Learner" <MsExlLearner(a)discussions.microsoft.com> wrote in message news:68FC0C6C-A846-411C-B615-1150A6CF7103(a)microsoft.com... > After Update Event > > Hi All, > > I am having a table like the below:- > > Table Name : DCData > > Field Name Type > Document Presented Yes/No > Date Date/Time > > I have created a form Using Wizard and get the fields from DCdata Table to > my form. > > Form Name: DCData (F) > > I require a after update event macro for my [Document Presented] field > (Yes/No) if the person check the [Document Presented] check box then the > form > should show the [Date] field otherwise if it is unchecked then the [Date] > field should not be visible and cannot be accessed by the users. (Using > Access 2003) > > Awaiting for your reply. > > -------------------- > (Ms-Exl-Learner) > -------------------- |