Search results

I am trying to have the results of a calculation automatically stored/displayed in a textbox named Overdue.text. Basically i only want positive whole values as fines are based on the number of days people are overdue. DateReturned.text and DateDue.text are Date/Time fields. If...

How can i reset the count/autonumber? During testing the Autonumber count reached 46, and now it continues from there. How can i make it go back to 1 and also continue from deleted records so if i delete number 46, it realizes that it should continue again from 46 and not 47? Many thanks.

Is it possible for me to use an IF...Else statement in a query, or possibly within the textbox default value/validation properties? What i am trying to do is this: IF (Overdue <= 0) Then Overdue = 0 Else (Overdue = DateRet - DateDue) End if Any help would be hugely appreciated.

Basically what i'm trying to do is, when the user clicks OK, the Yes/No attribute in tblHire is set to Yes. How can i acheive this? I have tried to use a macro but hasn't worked. Any help would be appreciated.

Ok, what i am basically trying to do is say insert the current date in the curDate field (done that), then i am trying to say, in the dueDate field, make the default value next day by 9 pm. How can i add it to the current time. What kind of arguments do Date() and Time() accept? I have also...

Hi I've been working with MySQL and i can assure you, it is considerably easier working with Access although the simplest things sometimes can't be acheived. Basically, i am working on a college project in Access. I am trying to get the value in a table to change automatically in relation to...