Results 1 to 9 of 9
  1. #1
    aamer is offline Competent Performer
    Windows 7 Access 2007
    Join Date
    Jul 2010
    Location
    Pakistan
    Posts
    276

    Help Needed To Fix Date on a Data Entry

    I am working on cash book / Day Book Project.
    I am stuck with a problem that am unable to solve. I have tried to locate the issue but am unable to do so.


    I have placed a default value of Date on the date field DBDATE on Form "DBKViewSubfrm"
    When I do the data entry on the form "DBKViewSubfrm" and skip to enter the value of date in DBDATE as it should take the system date due to the default date value is set to date()
    after the transaction is completed the date is changed to previous date value.

    I have attached a sample database for better understanding the problem.

    Help will be appreciated.

    Please Download Sample

    Test Sample.zip

  2. #2
    aamer is offline Competent Performer
    Windows 7 Access 2007
    Join Date
    Jul 2010
    Location
    Pakistan
    Posts
    276
    Can anyone help. I guess the problem is with linking of master & child fields in the FORM "DbKView".
    Last edited by aamer; 02-08-2016 at 08:59 AM.

  3. #3
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Yes, since that field is the child link, it follows the value of the master.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  4. #4
    aamer is offline Competent Performer
    Windows 7 Access 2007
    Join Date
    Jul 2010
    Location
    Pakistan
    Posts
    276
    What should I change to fix the issue

  5. #5
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Depends on your goals. Most simply is to delete the master/child links. With them, you're telling Access you only want the subform to display records with the same date, and that affects new records as well (as you've seen). You can filter the form differently if you want to start with those on the displayed date but be able to enter others.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  6. #6
    aamer is offline Competent Performer
    Windows 7 Access 2007
    Join Date
    Jul 2010
    Location
    Pakistan
    Posts
    276
    How can I display records with the same date after deleting the master / child links.
    can you give suggestion where I should look / read.

  7. #7
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    One way, in the after update event of the combo:

    Me.DBKViewSubFrm.Form.RecordSource = "SELECT * FROM DBKDetailQry WHERE DBDte = #" & Me.Combo117 & "#"
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  8. #8
    aamer is offline Competent Performer
    Windows 7 Access 2007
    Join Date
    Jul 2010
    Location
    Pakistan
    Posts
    276
    Thank U greatful for your help.
    it works perfect. I had to make some changes in design.

  9. #9
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Happy to help!
    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. Replies: 4
    Last Post: 12-21-2015, 10:57 PM
  2. Replies: 7
    Last Post: 03-05-2015, 07:34 AM
  3. Replies: 1
    Last Post: 11-21-2011, 01:09 AM
  4. Error Message re: data entry of date
    By Pro-not in forum Access
    Replies: 9
    Last Post: 10-22-2010, 10:14 AM
  5. Automatic Data Entry on a Specific Date
    By alanbrai in forum Programming
    Replies: 2
    Last Post: 11-14-2007, 05:15 PM

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