Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. xplo5iv

    Word Mailmerge multiple records per record...

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

    Word Mailmerge multiple records per record...

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

    Word Mailmerge multiple records per record...

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

    Word Mailmerge multiple records per record...

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

    Word Mailmerge multiple records per record...

    Ok, thanks, posted over on the other forum.
  6. xplo5iv

    Merging multiple records in excel

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

    Word Mailmerge multiple records per record...

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

    Word Form Preview Issue

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

    Word Form Fields

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

    Word Form Preview Issue

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

    Word Form Preview Issue

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

    Unable to clear 'ok' box when importing Excel file into Project

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

    update combo list

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

    update combo list

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

    update combo list

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

    update combo list

    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!
  17. xplo5iv

    update combo list

    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.)
  18. xplo5iv

    update combo list

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

    Finding values in one table between those in another

    Thanks Golom, really useful
  20. xplo5iv

    Finding values in one table between those in another

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

Part and Inventory Search

Back
Top