Results 1 to 5 of 5
  1. #1
    jeffrey.ccs is offline Novice
    Windows Vista Access 2000
    Join Date
    Jun 2009
    Posts
    3

    Auto populate date field in payment table

    Hi



    I am new to Access and have started to move across some Excel based programs.

    I have a simple example with two tables and a form where on the form a customer ID is entered which displays the name and below it is necessary to enter the total payments made by that customer for the day ( all records for the same day are entered at one time, which is why I would like to autofill the date). I can enter the date directly on the form for each customer entry but I would like to automatically enter the required date in the payment table using the value of a datepicker on the form to ensure that no date errors are made.

    I have been trying to use the expression builder to do this but the datepicker does not seem to appear as a valid option.

    Any advice would be warmly welcomed.

    Regards

    Jeff
    Attached Files Attached Files

  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,043
    I wouldn't use an ActiveX control. If you just add a textbox bound to the date field, you should automatically get a date picker in 2007/2010. If you want today's date, you can use Date() in the default value.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    jeffrey.ccs is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Jun 2009
    Posts
    3
    Hi

    Thanks for your reply.

    I can show the date field from the payment table on the form and have a picker but with up to 300 entries daily I would like to pick the date once and have it populate the payment date field automatically and thus minimize the amount of manual entry. It is that part that I can not find how to achieve, it seems that it should be straightforward but I tried using expression builder to use the change event in the datepicker and could not get it to update.

    Regards

    Jeff

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,043
    You can try this in the after update event of the date control.

    http://access.mvps.org/access/forms/frm0012.htm
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  5. #5
    jeffrey.ccs is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Jun 2009
    Posts
    3
    Hi

    Thanks a lot I will go and try it out.

    Regards

    Jeff

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

Similar Threads

  1. Auto Populate Txt Field
    By Andyjones in forum Forms
    Replies: 1
    Last Post: 03-27-2012, 05:53 PM
  2. Replies: 3
    Last Post: 10-03-2011, 02:33 PM
  3. Auto populate a field (without a form)
    By DonL in forum Access
    Replies: 1
    Last Post: 06-21-2011, 03:19 AM
  4. Replies: 4
    Last Post: 09-02-2010, 02:11 PM
  5. auto populate combo field?
    By myboii in forum Access
    Replies: 8
    Last Post: 07-09-2010, 05:46 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