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!

  • Congratulations TouchToneTommy 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: *

  • Users: kklaus
  • Content: Threads
  • Order by date
  1. kklaus

    Keyword Search - return multiple rows in listbox

    I need some help with a keyword search function. I have a button that when the user hits it, an InputBox appears asking for their keyword they would like to search. I need the results displayed in Listbox1. I'm having 2 problems right now. 1. The code below is returning an error that says...
  2. kklaus

    NewLine in Textbox

    I have a line of code that displays the selections the user makes in a combobox to a textbox. It separates each selection with a comma. Here's the code: ActiveDocument.FormFields("Text1").Result = temp & ", " & ComboBox1.Value The result will display as: I would like to have a new line...
  3. kklaus

    Loop & copy/paste particular number of rows

    I'm hoping you guys can help me with a simple loop problem. I have some VB code that takes a particular range of cells and copies and pastes them into a Word doc as a picture. The users have the ability to show and hide rows as needed in the worksheet. I need to just pick up the first 45...
  4. kklaus

    Determine where auto page breaks are

    Right now I have code that selects a particular range of cells and it copys and pastes those cells in a Word doc. Then it goes onto my next range of cells and does the same thing and so on. The problem is that because users need to hide various rows, the length of the page changes. I need to...
  5. kklaus

    Pasting Multiple times in Word

    I'm having a problem pasting from Excel to Word. I paste cells A1:F63 as a picture with no problem. When I copy and paste cells A64:F267, it pastes over my first picture. I haven't been able to successfully move to the end of the document or add a page break then paste the 2nd set of cells...
  6. kklaus

    Pasting Multiple times in Word

    I'm having a problem pasting from Excel to Word. I paste cells A1:F63 as a picture with no problem. When I copy and paste cells A64:F267, it pastes over my first picture. I haven't been able to successfully move to the end of the document or add a page break then paste the 2nd set of cells...
  7. kklaus

    Converting one XL sheet to .doc file

    Hi, I need help converting one sheet in excel to a .doc file. I've created a letter in Excel that contains our company logo and the text of the letter. I was trying to copy the first 6 rows of the letter as a "picture" in word (that's where the logo is). Then paste the remaining rows as text...
  8. kklaus

    Coping data from XL to Word Doc

    Below is my code to copy data from a worksheet to a Word Doc. The problem I'm having is that it seems to be copied as a picture or text box. Instead of it pulling in cells A1:F301 as stated in the code, only cells A1:F70 are showing in the .doc file. My data takes up about 6 pages in Word so...
  9. kklaus

    Coping data from XL to Word Doc

    Below is my code to copy data from a worksheet to a Word Doc. The problem I'm having is that it seems to be copied as a picture or text box. Instead of it pulling in cells A1:F301 as stated in the code, only cells A1:F70 are showing in the .doc file. My data takes up about 6 pages in Word so...
  10. kklaus

    Merge field from one Word Doc to another Word Doc

    I have a need to feed data from a letter in one Word doc to a letter in another Word doc file. Is this possible? When I try to use the Mail Merge feature in Word it wants a data source like Excel, Access, or a table in Word. I need to feed from one letter to another. For example, a user...
  11. kklaus

    Syntax Error - VB code

    I'm trying to write some code in VB for an Access Database. I'm writing a procedure that updates the selection available for a Combobox based on selections from 2 other Comboboxes. However, the tricky part for me is the "OR" piece. The user does not have to make selections for both comboboxes...
  12. kklaus

    Query using multiple combobox selections

    I need help writing a query using multiple combobox selections. I've done this successfully for one combobox. The part I'm having a problem with is having the query "ignore" comboboxes where the user doesn't make a selection and leaves it blank. For Example: I have 4 comboboxes on a form...

Part and Inventory Search

Back
Top