Search results

Hi All, I have an unbound field on a report with the following data source.. =IIf([NET]=0,"100",[NET]) The '100' value will be replaced by something more significant once this gets working. Basicaly, it's a financial report looking at values of invoices. How do i add up to total sum of these...

Just found the solution... Clicked the properties of the details section, and set 'can grow' and 'can shrink' to YES. Bingo ! just what i needed.

Hi All, I don't know how to acheive the following - and wondered if any of you experts could help me. I have a simple report - set out as rows, with a product per row. This has been working well, but i've been asked to combine special product data, which can be upto 9 extra fields, and they...

Good call, but isn't that. The form is only used by 1 person. It's the last stage in invocing. There is a chance that the record may still be open somewhere on a different form, and somebody forgot to close a form page, but that would be a 1% chance. Plus, whenever the user reclicks, the form...

Hi All, I'm not an experienced user. I have a backend database sitting on a server. We have 6 or 7 people with copies of the front-end database, all local and all on the same network. From time to time, some of them get the following " the command or action 'saverecord' isn;t available now"...

brilliant - even though my quaestions seem to be more stupid, the answers are spot on. Should have thought to have looked at properties - i guessed it was going to be more complicated than that ! thanks again

Brilliant - works perfectly for me. Thanks a lot ! I knew it was a stupid basic question to ask ! All my combo boxes have been list based, i didn't realise that they could pick up values from other tables. Next - the display of the columns in the combo box isn't long enough to show the...

A simple newbie question here - tried to find the asnwers on the forum before posting, but don't know the correct terminology to use to can't find the answers.. I have a form linked to a table called 'orders'. i have a field on it called 'reference'. I want to click on this field, and select a...