Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 01-10-2011, 04:20 PM   #1
lynchoftawa
Newly Registered User
 
Join Date: Jan 2011
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
lynchoftawa is on a distinguished road
Create Cut and Append button

Hi there, first time user.

I have a form that contains two comments memo boxes. One has the Most Recent Comment, and the other holds the Archive Comments.

What I am trying to build is a button that will cut the comments from the Most Recent Comment memo box, and append them to the top of the Archived Comments memo box.

When I type it out, it sounds too easy, I just can't seem to make it work.

Can somebody please help.

Thanks in advance

LOFT

lynchoftawa is offline   Reply With Quote
Old 01-10-2011, 04:37 PM   #2
pbaldy
Wino Moderator
 
pbaldy's Avatar
 
Join Date: Aug 2003
Location: Nevada, USA
Posts: 33,371
Thanks: 13
Thanked 4,120 Times in 4,052 Posts
pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold
Re: Create Cut and Append button

How about

Me.ArchiveTextbox = Me.RecentTextbox & vbCrLf & Me.ArchiveTextbox

which should put a carriage return between them.
__________________
Paul
Microsoft Access MVP 2007-2019

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
pbaldy is offline   Reply With Quote
Old 01-10-2011, 04:51 PM   #3
lynchoftawa
Newly Registered User
 
Join Date: Jan 2011
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
lynchoftawa is on a distinguished road
Re: Create Cut and Append button

Many thanks for your post, this works very well except that it does not create a new line between the recent and archived comments, anyother ideas?

LOFT

lynchoftawa is offline   Reply With Quote
Old 01-10-2011, 05:27 PM   #4
lynchoftawa
Newly Registered User
 
Join Date: Jan 2011
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
lynchoftawa is on a distinguished road
Re: Create Cut and Append button

Quote:
Originally Posted by lynchoftawa View Post
Many thanks for your post, this works very well except that it does not create a new line between the recent and archived comments, anyother ideas?

LOFT
Fixed by adding vbNewLine twice to the line of code. Thanks for your help.

LOFT
lynchoftawa is offline   Reply With Quote
Old 01-10-2011, 06:11 PM   #5
pbaldy
Wino Moderator
 
pbaldy's Avatar
 
Join Date: Aug 2003
Location: Nevada, USA
Posts: 33,371
Thanks: 13
Thanked 4,120 Times in 4,052 Posts
pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold
Re: Create Cut and Append button

No problem, and welcome to the site.

__________________
Paul
Microsoft Access MVP 2007-2019

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
pbaldy is offline   Reply With Quote
Reply

Tags
append , button , cut , forms

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Question How i create a Save Button and A Clear Form Button? Amenofhis General 8 08-16-2012 09:51 AM
Using Append Query in a loop to create 6 records in one go. Mel_P Queries 4 03-13-2009 02:56 PM
Append Query Key Violation (as used in Create Similar Record) vbaDev Queries 1 10-18-2007 09:05 AM
Create an append query momo007 General 1 12-24-2006 02:33 PM
Can an Append Query create new columns? Rebel Queries 8 05-24-2005 09:20 AM




All times are GMT -8. The time now is 02:51 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World