Search results

Sounds very interesting. Thanks for the tips. I am not sure what you mean by this and the access help file does not tell me anything. Would you guys be able to explain how to go about this? Or if you happen to know if this can be even done in Access 2.0? Thanks for your help.

It has not changed since the first post :) it is still "NewStock" and it does not work with any of these references. :( Any ideas on what is causing this? Or what I could do to work around this problem? Cheers.

Hello! Got a bit of a problem with setting passwords for admin to the database... When I set a password for the admin... and then start another unrelated database, it will ask for the password I entered for the other database... how do I set separate passwords to each database? what is going...

http://support.microsoft.com/default.aspx?scid=kb;EN-US;113354 Ive used a hidden controlbox before which keeps a running total through the report... then display it in the end in another box...

You can't do a Sum on a calculated field.... have you tried using "RunningSum" (overg roup, or over all)

as far as I know... the main report property sheet does not refer to the subreport... right clicking on the subreport control and selecting the properties shows me: name: NewStock SourceObject: Report.NewStockMonthTotal I have tried several methods of referring to this £%^"$% report and it's...

You think I haven't tried that? :D :confused:

Using this just causes the report to ask me for a value for the NewStockMonthTotal variable. Report is called "NewStockMonthTotal" - The subform control is named "NewStock" any more suggestions? :) Please? :rolleyes:

Rich, Which one of the syntaxes were you referring to? I have tried so many different ways of doing it... obviously starting with what I though was the correct way... I have also tried using the the expression builder... but it's no help. Besides... I cantr find the HasData property on the...

This is still doing my head in... :mad: If you guys have any suggestions for a workaround... I would be more than happy to try anything... :) I've also tried using an IIF in the subform so that the sums textbox displays 0 if the fields to be summed are null. this works correctly on the...

I would probably do it in the "on load" of the report... just check which tickbox is ticked... then change the value of a label or textbox accordingly to display the code that the tick is referring to...

Yup... have tried this... and this format worked fine before when I tried it elsewhere... but in this report it always gives me the #name? error :mad: any more suggestions? :confused:

I have tried =IIf([Reports]![NewStockMonthTotal].[HasData],1,0) and several variations of this... but they all give me the #name? error

Hello all!! I have been trying to get this to work for a while now... but I just cant work out what is going wrong... I have used the HasData property successfully before, but no luck now. I have a sub report "Report.NewStockMonthTotal" with the Name "NewStock". To do the calculations...