Search results

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

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?

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.

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

how can i express 2 fields in one?

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

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

I want to make a form where a staff member will book a bet, by selecting MembersID(which will automatically fill in, fields like name and surname) and Race, where this will allow the staff member only to select horses within that race. 1) when i try to select an other ID i get a msg at the...

I have a field called DateOfExpiration which i want to be automatically calculated according to the value of two other fields. ([TypesOfMemberships]="Bronze")=[DateAssigned]+91 Or ([TypesOfMemberships]="Silver")=[DateAssigned]+182 Or ([TypesOfMemberships]="Gold ")=[DateAssigned]+365 This is...

if someone knows the validation rule for a field to only accept letters i'd be more than thankful.