Search results

Hi, I hope someone can give me a hand with this problem as I've been struggling with it for days and haven't got anywhere. I have a form with a subform on it. The subform has a few command buttons. The buttons modify some of the data on the main form and I need the have the data on the main...

When I try to save the "Main customer details" form from design view access says it has encountered a problem and needs to close. I'm unable to finilise the design of this form and unable to finish this project. If someone could just tell me whether they can reproduce the problem or not then I...

I want to create a form filled with summary statistics from various table within my database. The statistics are all counts and sums. For me to do this do I need to create a seperate query for each SUM fromeach table then combine them all using another query or is it possible to SUM and COUNT...

Hi, I have a form, with a sub form on it, and the sub form has two subforms of its own. I want the main form to only display one of the sub sub forms depending on a field on the main form. The code I'm using is below. The problem I'm having is that when I change records or load the form it says...

How do I design a query that returns all records that have one or more null fields in them. Or one that returns records if one of a predetermined subset of the fields is null? I can't for the life of me work out how to do it so any help would be welcome. TIA Tom