Search results

I'm having a problem with a query, as follows: I need to be able to enter the name of an account handler when prompted. So in the criteria section of the AccountHandler field I've got [name]. This works OK when none of the other fields have criteria. However I also need to have data for...

Thanks, that's a good idea since my problem is really only a cosmetic one. I'll have a go at implementing this solution tomorrow. Indicentally, he way I've got round it so far is to put dummy data into the form to trick it into generating the subreport. It's to do with null values. Briefly...

I have a report comprised of several subreports. One of the subreports has calculated fields based on a query using using aggregate functions (SUM). If all the amounts come to zero/null, however, the subreport doesnt show when the main report is produced. This results in a large blank space...

thanks very much, that's really great. now I just have to work out what you did, but that's exactly what I wanted. I assume it'll work in A97 bcos you used DAO. thanks again.

I was not able to post the original version, so I've built a replica to illustrate the point I'm trying to make. The replica I built is in A2002 because that's what I have at home - but the original I built at for/work in A97 - I'm aware this may make a difference to it's functionality. In...

No, I haven't done it that way, was just doing it at form level (if that makes sense). How would I go about doing that with code?

it is stored in a table, yes

it is stored in a table, yes

I've put this post in the forms forum and didn't get a reply, so I'm thinking it may be more of a VBA question: I have a tabular subform linked to a main form. The main form (not tabular) has fields including TrainingNeed, RequiredScore and ActualScore. If there is a deficit between...

Great, thanks, that works.

I think this is pretty simple but I can't get it right! I need to design a query using COUNT in which there are two different criteria, ie Source = "recommendation" CreatedMonth = "nov" or "dec" or "jan" or "feb" (I want it to tell me how many records there are with source = "recommendation"...

I need to write VBA code to transfer information from a main form to one of its subforms if a condition equates to true. I would do this bit with the OnUpdate event of one of the controls in the main form and using If Then Else. The problem is that the subform is tabular, and I find that...