My Assistant
Site Message
(Message will auto close in 2 seconds)
 Duplicate Record To Omit Certain Fields
|
|
 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! |
 |
 
|
 |
Replies
|
Apr 3 2012, 11:26 AM
Post
#2
|
|
|
UtterAccess Ruler Posts: 2,662 |
QUOTE (ScottGem @ Apr 3 2012, 11:26 AM)  I would be more inclined to use SQL Why, pray tell? Say you've got a Record with 12 Fields, and you want all except 2 Fields duplicated, why would you go to the trouble of using an insert and having to innumerate thru 10 Fields? Also, while doing an INSERT like this, the New Record will be created, but the user will not be taken to the New Record in order to fill in the other two Fields; this is always, in my experience, a requirement for this type of task. Linq ;0)> This post has been edited by missinglinq: Apr 3 2012, 12:09 PM |
|
|
|
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 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 |
 |
Jump To Forum:
|
Go to Top · Lo-Fi Version | Time is now: 23rd May 2013 - 03:38 PM |