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...


  3. OP
    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

    >>
    >>
    >>
     
Since you're here... we have a small favor to ask...     Become a Supporter      ::     Make a Contribution     


Share This Page