Connecting Tech Pros Worldwide Help | Site Map

Using a command button to edit a memo field

  #1  
Old November 12th, 2005, 07:40 PM
Rick
Guest
 
Posts: n/a
Hello,

I currently use a field that I have set up to keep notes in. It is a
memo data type field. It looks like a simple box, and I typically
time and date stamp my notes as I enter them. For now, whenever I want
to add a new note to one of my files I will click once at the very top
left corner of the field, hit <enter> twice to move all the previous
notes down two levels, then I move the cursor back up to the top left
again, then I'll hit the Ctrl and the semi-colon to put the date in, I
then add a couple of spaces, then I'll hit the Ctrl and colon to put
the time in, and finally add a few more spaces then begin making
notes.

I would like to set up a command button that will perform these steps
for me. These are the steps I forsee:

OnClick
1...go into the notes (I call this field "tblHistory")
2...move cursor to the beginning of the notes (upper left corner)
3...advance all current notes down 2 levels (like hitting return
twice)
4...move the cursor back to the beginning (upper left corner)
5...add the current date
6...add 2 spaces
7...add the current time
8...add three spaces

I get stuck on #2. When I click on the command button it goes into
the notes and it highlights ALL the notes. If I continue beyond this
step the notes will disappear because they are all highlighted instead
of the cursor starting at the beginning (upper left corner)

Any suggestions?
  #2  
Old November 12th, 2005, 07:40 PM
Bas Cost Budde
Guest
 
Posts: n/a

re: Using a command button to edit a memo field


See the SelStart property of a field.

Consider changing the data by using an UPDATE query. You enter the text
to be 'submitted' into a separate form control, run the query, and presto.

Rick wrote:

[color=blue]
> I get stuck on #2. When I click on the command button it goes into
> the notes and it highlights ALL the notes. If I continue beyond this
> step the notes will disappear because they are all highlighted instead
> of the cursor starting at the beginning (upper left corner)
>
> Any suggestions?[/color]

--
Bas Cost Budde

  #3  
Old November 12th, 2005, 08:15 PM
Rick
Guest
 
Posts: n/a

re: Using a command button to edit a memo field


I don't know where the SelStart property is found, also I'm not sure
how to use an update query in this capacity.

Any suggestions?
  #4  
Old November 12th, 2005, 08:15 PM
Rick
Guest
 
Posts: n/a

re: Using a command button to edit a memo field


Any other suggestions? This appears to be very easy, so I apparently
need more descriptive steps to help me. Please feel free to over-do
it.



LocateServices@aol.com (Rick) wrote in message news:<664ddb41.0401290558.2ba4c505@posting.google. com>...[color=blue]
> Hello,
>
> I currently use a field that I have set up to keep notes in. It is a
> memo data type field. It looks like a simple box, and I typically
> time and date stamp my notes as I enter them. For now, whenever I want
> to add a new note to one of my files I will click once at the very top
> left corner of the field, hit <enter> twice to move all the previous
> notes down two levels, then I move the cursor back up to the top left
> again, then I'll hit the Ctrl and the semi-colon to put the date in, I
> then add a couple of spaces, then I'll hit the Ctrl and colon to put
> the time in, and finally add a few more spaces then begin making
> notes.
>
> I would like to set up a command button that will perform these steps
> for me. These are the steps I forsee:
>
> OnClick
> 1...go into the notes (I call this field "tblHistory")
> 2...move cursor to the beginning of the notes (upper left corner)
> 3...advance all current notes down 2 levels (like hitting return
> twice)
> 4...move the cursor back to the beginning (upper left corner)
> 5...add the current date
> 6...add 2 spaces
> 7...add the current time
> 8...add three spaces
>
> I get stuck on #2. When I click on the command button it goes into
> the notes and it highlights ALL the notes. If I continue beyond this
> step the notes will disappear because they are all highlighted instead
> of the cursor starting at the beginning (upper left corner)
>
> Any suggestions?[/color]
  #5  
Old November 12th, 2005, 08:15 PM
Bas Cost Budde
Guest
 
Posts: n/a

re: Using a command button to edit a memo field


Rick wrote:[color=blue]
> I don't know where the SelStart property is found, also I'm not sure
> how to use an update query in this capacity.
>
> Any suggestions?[/color]

in the form module, type

me!tblHistory.se

and see if you can get SelStart from the list.

There is a list, right?

Using an update query is not sufficient; initially I overlooked your
'and start entering notes'. You cannot do that with a query, of course.
--
Bas Cost Budde
http://www.heuveltop.org/BasCB
but the domain is nl

Closed Thread