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!

Recent content by jazminecat23

  1. jazminecat23

    Change Form Caption based on where it's opened from

    Sweet- that is exactly the bit I was missing. I will work with this tonight and see what I can accomplish. Thank you!
  2. jazminecat23

    Change Form Caption based on where it's opened from

    Hi all - how do i reference the button and form location which opens a particular form? I have a form NameDataEntry which can be opened from 3 different places on my database. Depending on where it's opened from, I want to change certain characteristics of the form, mainly it's caption and...
  3. jazminecat23

    use IF in qry when count is >1

    Duane, it works great. thanks for your help!
  4. jazminecat23

    Mail Merge Word to Excel missing columns?

    LOL. Me too Skip. I will give that a try, and see what happens. Thank you so much for all your suggestions though! :)
  5. jazminecat23

    Mail Merge Word to Excel missing columns?

    Data. I highlighted only the data, and pasted it into a new workbook.
  6. jazminecat23

    use IF in qry when count is >1

    Duane - haven't had a chance to try this yet, but it makes sense and I"ll give it a shot later tonight and let you know. Just wanted to say thanks for your response.
  7. jazminecat23

    Mail Merge Word to Excel missing columns?

    I have tried it both as selecting the print area in the mail merge wizard, and selecting the entire sheet in the mail merge wizard. It shows everything except the supervisor column in *both* instances. It's like that column just doesn't exist to MSWord for some reason. And it has no...
  8. jazminecat23

    Mail Merge Word to Excel missing columns?

    oh, and the range is A1:G19. and that is the only data in the worksheet, and the only worksheet in the workbook.
  9. jazminecat23

    Mail Merge Word to Excel missing columns?

    column headings: Supervisor Customer No. Customer Name Department Invoice Date Description Amount the data is contiguous. All rows have something in every column. there are no empty cells in the print area. There are no empty columns, cell A1 contains the word Supervisor above.
  10. jazminecat23

    Mail Merge Word to Excel missing columns?

    Hi - I am doing a mailmerge from excel to word, and when I go to insert the merge fields, it doesn't show all the columns in my worksheet. I have cleared and reset the print area, rearranged the columns, copied the data in to a NEW workbook, and even renamed the area I wanted (and it didn't...
  11. jazminecat23

    Merge Excel --> word. Multiple records

    Thanks for all your replies. I like Markus' idea, but lack the expertise in Excel to try it out right now. I'll give it a shot sometime when things are more settled here. What I ended up doing was just sorting the data by name, doing the merge, and just cutting and pasting the info for the...
  12. jazminecat23

    use IF in qry when count is >1

    Hello all - I have a query I use to populate a subform. This subform lists all charges against a client, by case. Currently, if one case has multiple charges, it lists them each individually. What I would like it to do is this - if there is only one charge on the case, list the chargetype...
  13. jazminecat23

    Merge Excel --> word. Multiple records

    ugh. so in a word, I can't do it in Word, and use my word templates, which have all of our letterhead and stuff on them, right? Because it's not a huge thing, and I won't have to do it often enough to spend hours trying to set up a memo document in Excel. thanks tho.
  14. jazminecat23

    Merge Excel --> word. Multiple records

    Hi, I have a data set with names and charges. Some names have many charges, some names have one charge. I need to send out a word document to each name listing their charges. Can anyone tell me how to do a merge and have it create one document per person, listing all of that person's charges...
  15. jazminecat23

    Excel Cell References not working

    :lightbulb: Ah, they were indeed formatted as text! Thanks y'all!! You saved me yet again.
See more

Part and Inventory Search

Back
Top