UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

> Duplicate Record To Omit Certain Fields    
 
   
hellabop
post Apr 3 2012, 08:51 AM
Post #1

UtterAccess Enthusiast
Posts: 56
Access 2010

Hello all, again I seek assistance. (IMG:style_emoticons/default/smile.gif)

I would like to have a button on my Form that once clicked the current Record is copied, but I'd like two fields 'EventDate' and 'Status' fields to be cleared on the duplicate Record...

What would be the best way to code this?


As usual -any help, advice etc. greatly appreciated!
Go to the top of the page
 
+

Posts in this topic
- hellabop   Duplicate Record To Omit Certain Fields   Apr 3 2012, 08:51 AM
- - missinglinq   CODEPrivate Sub CopyRecordl_Click() DoCm...   Apr 3 2012, 09:28 AM
- - hellabop   Works a dream! Many thanks!   Apr 3 2012, 10:22 AM
- - ScottGem   I would be more inclined to use SQL CODEDim strSQ...   Apr 3 2012, 10:26 AM
- - missinglinq   QUOTE (ScottGem @ Apr 3 2012, 11:26 AM) I...   Apr 3 2012, 11:26 AM
- - ScottGem   The why is because you can control EXACTLY what ge...   Apr 3 2012, 02:55 PM
- - missinglinq   QUOTE (ScottGem @ Apr 3 2012, 03:55 PM) T...   Apr 3 2012, 03:32 PM
- - ScottGem   Linq No offense, but how many posts do you have h...   Apr 3 2012, 03:47 PM

« Next Oldest · Access Forms · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Switch to: Standard · Switch to: Linear+ · Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 22nd May 2013 - 07:28 PM