Results 1 to 2 of 2
  1. #1
    Sherry Black is offline Novice
    Windows 10 Access 2016
    Join Date
    Oct 2019
    Posts
    1

    Copy a date to a table using VBA

    I have a table (tblCustomer) that has the field LastTrans I want to use VBA to send ShipDate from the frmOutgoingServiceOrders after it has been entered or updated. It will need to replace the previous date in the customer table. The CustCode is the primary key in tblCustomer and the tblServiceOrders is linked by CustCode. I need LastTrans to be updated each time an order goes out so that we can tell if a customer is still active in sending us repair work to do.

    It seems a simple problem but I don't know VBA that well yet and I cant figure it out. Any suggestions ?

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Typically you wouldn't store a value that can be calculated from transactions. If you insist, you could execute an update query from the after update event of that form.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. How can I make Copy date, with two tables
    By CPimenta in forum Access
    Replies: 2
    Last Post: 10-04-2018, 12:24 PM
  2. Replies: 4
    Last Post: 01-11-2018, 08:49 PM
  3. Copy the date from otherfield if IsNull!
    By cap.zadi in forum Queries
    Replies: 5
    Last Post: 07-03-2017, 06:43 AM
  4. Replies: 1
    Last Post: 01-21-2015, 11:33 PM
  5. How to copy the month of a date
    By rudenberg2013 in forum Programming
    Replies: 2
    Last Post: 11-04-2013, 05:37 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