Recent content by xplo5iv

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...