Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

Default Values in Data Access Page

Discussion in 'Information Technology' started by Nikki, Jul 28, 2006.

  1. Nikki

    Expand Collapse

    Can someone help me understand using default values in data access

    I want to create a dap on one table which will have two fields with
    defaults. DateOrdered which will default to today and DateDue which
    will default to 14 days from the DateOrdered field. I want both fields
    to be editable and I want DateDue to change based on changes made in

    I was able to create a form that did this. In the table, I put =date()
    in the default for DateOrdered. In the form I used Me.DueDate =
    DateAdd("d", 14, Me.DateOrdered) for the DateOrdered AfterUpdate

    I tried saving this as a dap but the defaults do not appear when you
    start a new record, nor does the DateDue change to 14 days from the
    DateOrdered unless you save. Is there a way I can make the defaults
    appear automatically at the opening of a new record and have the
    DateDue change immediately after changes made to DateOrdered? If
    possible, the more details the better because I'm new to dap and vba.
    Also, if anyone has suggestions for tutorials or books for learning dba
    and vba in access that will be appreciated as well.
  2. Loading...

Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     

Share This Page