Search results

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

Pat thanks for your reply. I dont think the problem is with the tables coz the relationship is one-to-many(one horse can particate ine one race and in one race can participate many horses). However i cant use cascading box as i havent manage to understand how to create them. If someone could...

Thanks Thanks a lot. Some more help would be more than welcome. 1. I want according to the type of bet, some combo boxes to appear. e.g. If the type of bet is Trio, where you have to find the first 3 horses, I want 3 combo boxes to appear where i will select the three horses. How can i do...

I want to have a form where a staff member will be able to book a bet. In the main form i want to have a Race list box, with the races, so in the subform i will be able to choose from a drop down menu only horses that are in tha particular race and not from all horses. ** e.g. I have entered 80...

I made a form, with a subform. There is only one field in the main form, Race field, and a subform in datasheet view, where each cell, has a drop down menu where you select a horse that will participate in the race. When i choose a horse for one place, all cells take the same value. why is that...

em thanks for your responce but to be honest what you tell me is not something new, a way to solve it would be more welcome ;) thanks again