By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,248 Members | 1,979 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,248 IT Pros & Developers. It's quick & easy.

Using a command button to edit a memo field

P: 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?
Nov 12 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
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:

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?


--
Bas Cost Budde

Nov 12 '05 #2

P: n/a
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?
Nov 12 '05 #3

P: n/a
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.

Lo************@aol.com (Rick) wrote in message news:<66**************************@posting.google. com>...
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?

Nov 12 '05 #4

P: n/a
Rick wrote:
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?


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

Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.