Recent content by jGURU

Thanks Mile and dcx - worked like a charm. When performing calculations, do i have to use the old BODMAS (Brackets Of Division Multiplication Addition Subraction) routine in that order, or does anything go? What i'm trying to do is this...

Thanks Mile for your prompt reply. One more question...how do i round off the number to a whole number? I have used integer in the Overdue field but it still doesn't work. Many thanks.

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.

Thanks, i considered that but the whole thing has to be automated, as there has to be a way of checking whether the item is availalbe or not (as far as i can see this is the only way). It is for a library assignment, so incase the user tries to hire the same item to another user (while on hire)...

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