Search results

I have an invoice record incorporating an invoice line items sub-form. I have a prompt dialog that gives the user a choice to delete the current record (and its lineitem records). What is the best way to do this? given that the record in view is the record that I may wish to delete? I can...

Thanks - that was it! I did notice after posting the comment that the cell values would update on SAVE..... not sure why this option has switched off - as the AUTO formula update feature was working last week.... Thanks for your help!

I have two columns of figures - I create a third column, the cell for which contains a simple formula of 2nd column val minus the first column val. The result is correct for the first row. If I then copy and paste the formula for the remaining rows they all receive the formula correctly...

Hi - any chance you can post a copy here for us to view?

Sure enough - this does actually do the job! Thanks! (a bit of a fudge but in the absence of any other suggestions this will do!) Cheers

I have this really frustratingly annoying problem with my DB. If I make a change to an existing form or report whereby I duplicate a text field or label / create a new text field but then delete the text label tag.... the database crashes. I have even tried creating a new blank database ...

Well played Gemma - didnt realise that - works a treat- THANKS!

Thanks but I thought that event only fires if the field is a bound control - which it isn't.....

Hi I am looking to run a query on selection / keyed entry of a numerical value in a combo dropdown. The query returns a small recordset to the VB code that is analysed for a flag value. This value determines the value of a check box on the form. (for those interested : .....The form is a...

Found it - I appear to have NULL values appearing in the resultset. This is likely upsetting the SUM function - Consider this fixed!

Sorry - I have found similar postings on this forum that suggest that it is not the Query tht is the problem. Sure enough - I have played around with the report and for some reason - a field on the report : =Sum([Value]) Is the culprit. If I remove this control from the report - everything...

Notepad++ - have had a quick play around with it - excellent piece of software and you are right the colour coded highlighting is ideal for this type of checking, I'll shelve my plans for writing an editor now! THANKS

I have modified an existing stock list SQL query that is linked to a report. Previously the report ran fine - the Query runs without problem when run from the Query window. But now, if I attempt to open the report to which the Query is attached - I get : 'The Expression Is Typed Incorrectly...

Bob I have attached the function that I have attempted to call from the SQL Query (in lieu of the NESTED IIF discussed earlier). The error mentioned occurs for items reaching the final Else - here, it should simply return the Price value (sngPrice). For a handful of items only - #Error#...

Bob Whilst I agree with the theory here - in practice it is a little more complicated than that. In addition, IIF statements seem more forgiving when they encounter NULL Values in the parameter list. (as it is I have had to Nz prefix each param. passed to the function). The primary problem I...

Thanks for the diagram - will try representing my 'mess'(!) as such - to try and make it a little simpler to make further additions. I may write an editor application that enables construction of these pesky things with a little more ease. Im sure others would find this useful ... will stick a...

Thanks Chaps - this is OK on the diddy ones - but check out this baby, and it's still growing.....!!!! IIf([StockIdentifier] = 1 Or [StockIdentifier] = 2, IIf([StockIdentifier] = 1, IIf(IsNull([SupplierId]), [Unit_Dia], Reporting_EOY_SrcMaterialUnitCost!Price), IIf(IsNull([SupplierId])...

:confused:Hi All Does anyone know of - or has found an editor that makes for relatively easy construction of 'Nested IIf' statements? I am having to write some horrendously long ones for my reports and it is giving me a headache - namely getting the number of brackets and their positions within...

Thanks for the MZ tip. Respectfully, I am not too sure we are on the same wavelength here - I need to prevent the Switchboard panel from being accessed when any error occurs. There may be some other bugs in my code that presently I am not aware of. Sure these will likely come out in the...

Bob So there is nowhere that I could place a generic error handler to trap all other unhandled error events?