Results 1 to 2 of 2
  1. #1
    DubCap01 is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Sep 2014
    Location
    Dubbo, Australia
    Posts
    104

    Is it possible to copy and paste?


    Hi all,

    I am trying to pick up the numeric value of a date field (23-Dec-16 = 42727) and use the number in a concatenated field. The end result field is picking up another numeric field first, and then adding 23-Dec-16 on the end, instead of 42727.

    Here's my code:
    Code:
            Me.DepartDate1 = Me.DepartDate
            Me.ManifestID1 = Me.RegoValue & "" & Me.DepartDate1
    RegoValue is anything between 1 and 40, in this instance let's say 32

    The result I want is .... 3242727
    The result I get is....... 3223-Dec-16

    Any help appreciated

    cheers
    Pete

  2. #2
    DubCap01 is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Sep 2014
    Location
    Dubbo, Australia
    Posts
    104
    Fixed, the correct code I need is:
    Code:
            Me.ManifestID1 = Format(Me.DepartDate1, "#") & "" & Me.RegoValue
    cheers
    Pete

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Macro to copy and paste
    By chr1stoper1 in forum Macros
    Replies: 2
    Last Post: 04-11-2016, 06:51 AM
  2. Copy and Paste Row (vb)
    By Computer202 in forum Programming
    Replies: 7
    Last Post: 03-28-2014, 01:59 AM
  3. Copy-Paste
    By BorisGomel in forum Access
    Replies: 4
    Last Post: 10-25-2011, 07:17 AM
  4. Copy/paste to new record.
    By xbox1513 in forum Forms
    Replies: 1
    Last Post: 02-23-2011, 04:52 PM
  5. Copy / Paste some fields
    By isnpms in forum Access
    Replies: 2
    Last Post: 08-25-2010, 10:13 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums