Recent content by nx69

  1. N

    Expired Account

    irema you told me how to calculate the date of expiration ;) Thanks jam and mil.
  2. N

    Expired Account

    I have a query called qryExpiringAccounts, that calculates tha date of expiration and has as criteria >=Date() And <Date()+7 and it works great. I have an other query called qryExpiredAccounts with the same structure but it has <Date() for criteria and it doesnt work.(there have to be results...
  3. N

    relationships

    Thanks Pat.
  4. N

    Subtraction

    Both fields are text boxes. The field is frmBets shows the amount of units the members wishes to bet, and the field in frmMembers the units owned by the member. So i want the value of the field in frmBets to be substracted from the value of the field in frmMembers, showing the units left. e.g...
  5. N

    Subtraction

    Substraction I want to built up a query that will substract the value of a field from another. Ex. The "Amount of units to bet" field in frmBets, is 5, i want this value to be substracted from the "Units" field in frmMembers. Also i want another query that will check a check box when it runs...
  6. N

    Adding Fields

    I made a form which took me a lot of time to create, but i forgot couple of fields. Is there a way to add this fields to the form?
  7. N

    relationships

    Relationships This is how my relationships look now.
  8. N

    Date Validation

    I want a valid date inserted to be only between 1/10/1997 and today[Date()]. how can i do that?
  9. N

    Check Box + Email

    I want to built a macro which will check a check box and open a new form. How can i do that? And also how can i built an other macro to send an email and for the email address to automatically take the values in field call E-mail in tblMembers. [tblMembers]![Email] doesnt work Thanks.
  10. N

    relationships

    You are absolutely right. Apologies.
  11. N

    Help

    1. How can i remove the default navigation buttons of MS access?
  12. N

    Expressing 2 fields in one

    how can i express 2 fields in one?
  13. N

    relationships

    Done with the races form :) But now how do i built my Betting form? :confused: take a look at the changes i made
  14. N

    relationships

    re: After every session (9 or 10 races for example) is completed, the races' records will be deleted and new race records will created for the next session. What i wanted to say is that a horses runs only once every session. Won? will be used to locate bet wons for a report. Date, is for...
  15. N

    relationships

    I want to make a form where I will type the race number and in a subform below i will be able to select horses to participate. One horse can participate only in one race and in one race can participate many horses. To achieve this i believe i need one more table, linking tblRaces and...
Back
Top Bottom