Recent content by iandanescourt

Thanks guys, when I get chance I will try that out, will get back to you to let you know how I get on Ian

Hello to everybody. I have a problem in calculating the difference between two dates and displaying the output into Years Months Weeks Days. My problem is that dividing the number of days by 30 and requesting an integer is not accurate enough. I have looked at Pat and Jons examples shown in...

Thanks Very Much Kevin you are a gentleman and a scholar. Thank you for your time Ian :D

Hi Kevin. thanks for the response however the format is in hours, minutes and seconds. its not the formatting causing the problem. If i go in now days later the time still comes in at the same value. here is the test database that I am working on if anyone fancies a look. It must be an obvious...

one time value is created and stamped when the record is created by having a default value in the table of time() lets call this the Time of creation. This records the time of the system when the record is created. The table has other fields for other values, one of which is another time field...

I Have a problem in which when I create a record I wish the record to automatically record the time it was created. I have achieved this by having a timerecorded field within the table and setting its default value to time(). later on I wish another time to be recorded. This time when the user...

I am using a report to represent a replica of a form that I require for my workplace. The report is separated into columns in which data is entered and segregated by vertical lines and each report is separated by a group header. I have been able to follow the advice given in knowledge base...

I have a form with several subforms layered with the use of the tab control icon in the form toolbox and I am wishing one of the categories to display either formA, formB or formC dependent in a value in the main form. Is this possible or do I have to have all 3 subforms in the same position...