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
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
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...
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.)
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.