Recent content by Gram123

Cheers David, But they didn't have what I wanted. Anyone else? Gram

Hi. I'd like to be able to say that today is so many years, months & days since a specified date. Better yet, would be to include hours and minutes, or hours to 2 dps. At present I can only count days, using: =Date()-#13/02/99#+1 & " days" I know I can use the DateDiff function as an...

Or just swap the arguments round - i.e. change the control source to: =DateDiff("n",[Equipment Stop Time],[Equipment Start Time]) Gram

Yeah, cheers Rich. I figured it out today at work. When it didn't work I panicked and forgot that there is actually a help file with Access! Got there in the end though. Thanks mate. Gram

This doesn't work either, Rich. It returns a value of 1. Any more ideas? Please mail me at work: graham.cat@hslltd.co.uk, where I am going now and for the next 8.5 hours. Cheers, Gram

Hi. I have a report that contains duplicated fields. Also in the group header is a hidden field: Name:AAA Control Source: =1 I was told by a list member (Rich) that if I sum the 1s from the group header in the report footer it would give me an accurate count of all distinct records (and not...

Hi. I recently asked for help with a problem regarding counting only non-duplicated records on a report, and a member called Rich gave me a solution, but I'm still lost. My database is basically monitoring damage to vehicles. Each vehicle has a unique Chassis Number, and some of these have...

I have a report with a grouped header (damage type) and a sum in the group footer, with a grand total on the last page. This basically gives subtotals on each page and a grand total on the final page. At present the last sub-title (group header) appears on the second last page (which it should...

Hi. I have a data entry form that contains price boxes. There is a total box, which simply adds these prices together with the control source =Sum([Price 1] + [Price 2] + [Price 3]) This works fine. However, when I go into design view and save changes, the total stops working and displays...

Hi. I am in desparate need of help a.s.a.p. I'm currently programming a database at work and have come across one of those frustrating Access stumbling blocks. My database is basically monitoring damage to vehicles. Each vehicle has a unique Chassis Number, and some of these have multiple...

I realise this has been answered, but I didn't undrestand the answer! I NEED TO HAVE A TEXT BOX AUTOMATICALLY INSERT TEXT WHEN I ENTER A CODE FROM AN ADJACENT COMBO BOX. I have to program a database at work (within the next 8 hours), which must include lots of fields that have a code number...

WHAT?!?! I don't understand SQL or whatever this is! I urgently need a simple answer of how I can do this on a form in Microsoft Access 97, using the controls I mentioned in the first msg. Please help!!! Please e-mail me wiht any answers to: graham.cat@hslltd.co.uk

I realise this has been answered, but I didn't undrestand the answer! I have to program a database at work which must include lots of fields that have a code number and a name, for example, Ship Number and Ship Name. I have a Main table containing all required fields on the form and a second...