Recent content by nx69

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

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...

Thanks Pat.

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...

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...

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?

Relationships This is how my relationships look now.

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

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.

You are absolutely right. Apologies.

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

how can i express 2 fields in one?

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

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...

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...