Search results for query: *

Just realised re the zero values - I was suppressing the description fields as well, hence the IF. Useful to know for next time, though, Thanks

Ah, thanks I used the tutorial, and your totalling method for the allowances but my dataset (provided from elsewhere)required a different approach to add the salary on. It was in the format Name - Salary - Allowance Type - Allowance Value John - 25000 - Shift - 2500 John - 25000 -...

I've now achieved everything I needed, thank you. For the reference of others who may read this post it is possible to create a grand total of a field/ fields in the upper section to the total of the lower section by using SET e.g. in my document I have Annual salary in the top part of the...

Fantastic, had a good look through it, exactly what I wanted. Now in the process of converting to suit my needs. Having seen the complexity of the fields I now know why I couldn't work out how to do it! Jonathan

Ok, thanks, posted over on the other forum.

I have an excel source with the following headings Staff Number Name Allowance Amount Each employee appears one or more times, as they can have more than one allowance. The list is sorted by staff number, so the records are together for each staff member. I need to create a document per...

I have an excel source with the following headings Staff Number Name Allowance Amount Each employee appears one or more times, as they can have more than one allowance. The list is sorted by staff number, so the records are together for each staff member. I need to create a document per...

Thanks everyone, lots of useful stuff there. I've got a version that works, using a custom 'preview' button, but I'll explore the other options too. Thanks for your help Jonathan

Is the relevant document section still protected, or has somehow the selection been changed and only the top section been protected for forms?

Thanks, that's saved me from spending even more time trying to fix the problem. Workarounds here we come...

I've created a form in Word 2003, significant quantities of it are bookmarked text which is hidden/ unhidden by means of form check boxes changing the font to hidden. (This works fine) There are also a number of form text boxes, and one (continuous break) section in the middle which is...

Hi Part of my code imports data from an Excel file into Project... FileOpen Name:=strExcel, ReadOnly:=False, Merge:=0, FormatID:="MSProject.XLS5", map:="TaskExportForVisio" As my Excel file does not have a project start date in it, a warning box comes up, which just needs 'ok'ing, because...

Sorry, Tony, was away all day yesterday at a supplier meeting. (I have a real job, too!) :-)

Yes! Do both. Great And delete both the Control Sources while you're about it, as you don't want these combos to alter those tables.

No, looks about right, but you may want to consider enforcing relationships. Each combo box Row Source should be based on a table, or a query/ SQL expression, so that the combos remain dynamic. Right click on the combo, and go to 'properties' to look up the row source. DONT use the 'control...

Assuming that staff_combo is based on a query which uses comp_combo (If not it should be...) then in the Change event of comp_combo you need to add the code staff_combo.requery in order to update staff_combo Hope that's clearer!

Sorry, just re-read your post. You need to base each cascaded combo on a query which uses the previous combo contents as well (I'd assumed you'd done that, but then realised you hadn't said so.)

You need to put cmbCombo2BoxName.Requery into the on change event of ComboBox 1 etc. (Hope that's understandable) Jonathan

Thanks Golom, really useful

Hi (I'm not quite sure what you call this, so I've had trouble searching) I have two tables Salaries NINO Salary ScalePoints SCP AnnualPay I need a query which will tell me the nearest SCP for each NINO. (Salary is actual amount earned, SCP is point on the pay scale, e.g. if SCP 5 is £10k and...