Recent content by chrislee

Thanks for your reply Pat. I've managed to fix this now. The issue seemed to be my naming of the key fields, presumably the use of 'number' as a field name. I changed them to QuoteNumber on both tables and now everything works as it should. Chris. :) :)

I'm creating a simple database to handle quotes. My parent table is tblQuote: (fieldname /datatype) - number (pk) /number - createdate /datetime - owner /txt - title /txt - contactname /txt - customerid /number - revision /number - lastupdatedate /datetime - status /number Child table is...

Thanks. Can't believe it was that simple! I was trying to work out how to select the text automatically, but your method uses the existing technique which Access already applies when you tab to and from fields. Most appreciated! Chris.

I need a way of achieving the following: When the user clicks onto a textbox, the text displayed in it is automatically highlighted. This already happens when you tab from one field to the next and allows quick overtyping of the field text without the need to highlight first. Unless there's...

It sounds like you have a one-to-many scenario where a record identified by 'order number' has many child records. You're looking in the right place: under sorting and grouping, you need to add the 'order number' field (you've probably got this already), and then you need to set 'Group Header'...

Thanks for pointing me in the right direction!

Rich, you are a total star. :) :) :) This problem has been sitting on my to do list for months, and I couldn't find any reference to the problem on the Microsoft Knowledge Base. Did you experience the problem, or have you seen it referred to elsewhere? I'd like to know why AutoCorrect wants...

In my Access 2000 format database that I'm developing in Access 2002, I have a report to which I want to add 3 sub-reports. I add the first one -- no problem. I add the second and can link the child/master fields OK and preview OK. The problem occurs when I save changes (either clicking Save...