Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Re: need date/time stamp on each line in memo field

Discussion in 'Information Technology' started by Maly, Jul 28, 2006.

  1. Maly

    Maly
    Expand Collapse
    Guest

    Allen, I have followed these instructions as I had the same issue. It was all
    a great help, but now I need just a little more guidance. What can I do to
    make sure that the record (it its entirety) is locked once data is entered?
    i.e. after I enter the memo and tab to the next record, I want the previous
    record locked (even if only on the form, but preferably on the query and/or
    table as well)


    "Allen Browne" wrote:

    > Open the subform in design view.
    > Open the Properties box (View menu).
    > While looking at the properties of the Form (not a text box), on the Format
    > tab, set the Default View to one of these:
    > Continuous Form
    > Datasheet.
    > It will then show one record per row.
    > --
    > Allen Browne - Microsoft MVP. Perth, Western Australia.
    > Tips for Access users - http://allenbrowne.com/tips.html
    > Reply to group, rather than allenbrowne at mvps dot org.
    >
    > "Fatboymedic" <Fatboymedic@discussions.microsoft.com> wrote in message
    > news:F7EFBC0D-11F8-4D31-8FAE-131829FE174D@microsoft.com...
    > > thank you so much, Allen
    > >
    > > one last bit.. can i display all the values, date/time + note, for each
    > > record, in a text box? I have successfully created the new table, with an
    > > ID,
    > > date, and note field,linked by ID, so each entry is associated with the
    > > main
    > > record, and i made a text box, with the "=[subfrm date/time
    > > notes].Form!date
    > > & " " & [subfrm date/time notes].Form!note" control.. but it only gives
    > > the
    > > data from the selected entry on the subform... i want to see ALL entries
    > > for
    > > the record - i will need this for the report i create as well....
    > >
    > > "Allen Browne" wrote:
    > >
    > >> Yes, typically the interface would be a main form for whatever you are
    > >> making notes on, with a subform to show the many notes (one per line.)
    > >>
    > >> "Fatboymedic" <Fatboymedic@discussions.microsoft.com> wrote in message
    > >> news:15FA02D1-45E8-4B1B-B952-63E50D2EF7F5@microsoft.com...
    > >> >I think i get it...
    > >> > the memo field is set up on the form to be a scrolling record of notes
    > >> > added
    > >> > (its a simple dispatching database), and displays on the form itself,
    > >> > and
    > >> > on
    > >> > a report. If I set up a related table, I assume I would need a control
    > >> > (ie
    > >> > button) and an unbound display field, with the info concatenated? I
    > >> > will
    > >> > not
    > >> > need to search for the updated notes, thats why i just wanted to have
    > >> > it
    > >> > stamp the memo field entries
    > >> >
    > >> > Thank You!!
    > >> >
    > >> > "Allen Browne" wrote:
    > >> >
    > >> >> It would be possible to use the KeyDown or Change events of the
    > >> >> control
    > >> >> to
    > >> >> trap the Enter key, and replace it with the previous characters &
    > >> >> Now() &
    > >> >> the subsequent characters, using SelStart, SelLength, Len() and so on.
    > >> >>
    > >> >> However, if each line is intended to be dated, a better solution would
    > >> >> be
    > >> >> to
    > >> >> create a related table of notations instead of trying to force all of
    > >> >> this
    > >> >> data into a single memo field, and still not be able to search on the
    > >> >> dates,
    > >> >> or manipulate their order, etc.
    > >> >>
    > >> >> Create a related table with a date field and a memo field. Set the
    > >> >> Default
    > >> >> Value of the date/time field to:
    > >> >> =Now()
    > >> >> and it will automatically populate whenever someone adds a new comment
    > >> >> row
    > >> >> to the related table.
    > >> >>
    > >> >> "Fatboymedic" <Fatboymedic@discussions.microsoft.com> wrote in message
    > >> >> news:7192830A-189A-47E7-BD94-0FA47A41A467@microsoft.com...
    > >> >> >I have a memo field, which needs to have a date/time stamp appended
    > >> >> >to
    > >> >> >the
    > >> >> > end of each line, when the enter key is pressed
    > >> >> >
    > >> >> > ie: test line 1 <enter> 01:01:01 09/05/05
    > >> >> > test line 2 <enter> 01:01:50 09/05/05

    >
    >
    >
     
  2. Loading...

    Similar Threads Forum Date
    Sikh News WWI Sikh Heroes Need To Be Remembered: Dr Atamjit Breaking News Sep 11, 2016
    Interracial And Interfaith Marriage, Help Needed To Confront/convince My Parents Love & Marriage Aug 16, 2016
    Sikh News Sikh Seva Volunteers Keep The Food Service Drive For The Needy Going After Passing Away Of Breaking News Jul 29, 2016
    Need some info regarding bibek wrt eating Sikh Rehat Maryada Jan 14, 2016
    Spiritual Why We Only Need To Pray For Naam Blogs Dec 20, 2015

  3. strive4peace

    strive4peace
    Expand Collapse
    Guest

    Hi Maly,

    put this on the form OnCurrent event for the form with your
    memo field:

    '~~~~~~~~~~~~~~~~~~~
    me.AllowEdits = _
    IIF(isnull(me.memo_controlname), true,false)
    '~~~~~~~~~~~~~~~~~~~

    Warm Regards,
    Crystal
    Microsoft Access MVP 2006

    *
    Have an awesome day ;)

    remote programming and training
    strive4peace2006 at yahoo.com

    *

    Maly wrote:
    > Allen, I have followed these instructions as I had the same issue. It was all
    > a great help, but now I need just a little more guidance. What can I do to
    > make sure that the record (it its entirety) is locked once data is entered?
    > i.e. after I enter the memo and tab to the next record, I want the previous
    > record locked (even if only on the form, but preferably on the query and/or
    > table as well)
    >
    >
    > "Allen Browne" wrote:
    >
    >
    >>Open the subform in design view.
    >>Open the Properties box (View menu).
    >>While looking at the properties of the Form (not a text box), on the Format
    >>tab, set the Default View to one of these:
    >> Continuous Form
    >> Datasheet.
    >>It will then show one record per row.
    >>--
    >>Allen Browne - Microsoft MVP. Perth, Western Australia.
    >>Tips for Access users - http://allenbrowne.com/tips.html
    >>Reply to group, rather than allenbrowne at mvps dot org.
    >>
    >>"Fatboymedic" <Fatboymedic@discussions.microsoft.com> wrote in message
    >>news:F7EFBC0D-11F8-4D31-8FAE-131829FE174D@microsoft.com...
    >>
    >>>thank you so much, Allen
    >>>
    >>>one last bit.. can i display all the values, date/time + note, for each
    >>>record, in a text box? I have successfully created the new table, with an
    >>>ID,
    >>>date, and note field,linked by ID, so each entry is associated with the
    >>>main
    >>>record, and i made a text box, with the "=[subfrm date/time
    >>>notes].Form!date
    >>>& " " & [subfrm date/time notes].Form!note" control.. but it only gives
    >>>the
    >>>data from the selected entry on the subform... i want to see ALL entries
    >>>for
    >>>the record - i will need this for the report i create as well....
    >>>
    >>>"Allen Browne" wrote:
    >>>
    >>>
    >>>>Yes, typically the interface would be a main form for whatever you are
    >>>>making notes on, with a subform to show the many notes (one per line.)
    >>>>
    >>>>"Fatboymedic" <Fatboymedic@discussions.microsoft.com> wrote in message
    >>>>news:15FA02D1-45E8-4B1B-B952-63E50D2EF7F5@microsoft.com...
    >>>>
    >>>>>I think i get it...
    >>>>>the memo field is set up on the form to be a scrolling record of notes
    >>>>>added
    >>>>>(its a simple dispatching database), and displays on the form itself,
    >>>>>and
    >>>>>on
    >>>>>a report. If I set up a related table, I assume I would need a control
    >>>>>(ie
    >>>>>button) and an unbound display field, with the info concatenated? I
    >>>>>will
    >>>>>not
    >>>>>need to search for the updated notes, thats why i just wanted to have
    >>>>>it
    >>>>>stamp the memo field entries
    >>>>>
    >>>>>Thank You!!
    >>>>>
    >>>>>"Allen Browne" wrote:
    >>>>>
    >>>>>
    >>>>>>It would be possible to use the KeyDown or Change events of the
    >>>>>>control
    >>>>>>to
    >>>>>>trap the Enter key, and replace it with the previous characters &
    >>>>>>Now() &
    >>>>>>the subsequent characters, using SelStart, SelLength, Len() and so on.
    >>>>>>
    >>>>>>However, if each line is intended to be dated, a better solution would
    >>>>>>be
    >>>>>>to
    >>>>>>create a related table of notations instead of trying to force all of
    >>>>>>this
    >>>>>>data into a single memo field, and still not be able to search on the
    >>>>>>dates,
    >>>>>>or manipulate their order, etc.
    >>>>>>
    >>>>>>Create a related table with a date field and a memo field. Set the
    >>>>>>Default
    >>>>>>Value of the date/time field to:
    >>>>>> =Now()
    >>>>>>and it will automatically populate whenever someone adds a new comment
    >>>>>>row
    >>>>>>to the related table.
    >>>>>>
    >>>>>>"Fatboymedic" <Fatboymedic@discussions.microsoft.com> wrote in message
    >>>>>>news:7192830A-189A-47E7-BD94-0FA47A41A467@microsoft.com...
    >>>>>>
    >>>>>>>I have a memo field, which needs to have a date/time stamp appended
    >>>>>>>to
    >>>>>>>the
    >>>>>>>end of each line, when the enter key is pressed
    >>>>>>>
    >>>>>>>ie: test line 1 <enter> 01:01:01 09/05/05
    >>>>>>> test line 2 <enter> 01:01:50 09/05/05

    >>
    >>
    >>
     

Share This Page