Search results

  1. I

    Replace Hyperlink in Report With Image

    Thanks a lot Oldsoftboss! That is exactly what I needed! Alex
  2. I

    Replace Hyperlink in Report With Image

    Hi, I have a report which contains a hyperlink that displays a link to a certain image on the user's computer. When the report opens, is it possible for that hyperlink to be replaced by the actual image that it is linking? Thanks, Alex
  3. I

    Creating Report based on List Box Selection

    Thank You Thank you both! The attachment was a big help! That was exactly what I was looking for! Thanks, Alex
  4. I

    Creating Report based on List Box Selection

    Hi, I have a form that has a list box that lists all of the item id's that are currently in the database. Is it possible for the user to MultiSelect as many items as they want by item id and then click a command button that would open a report that displays only the items that the user...
  5. I

    Exporting Hyperlink to Word

    Hi, I want to export a hyperlink to word. Everything works, it exports the hyperlink to word, but when it is in word, it is no longer a hyperlink (no longer underlined), its just text. It looks like this: "<file://\\C:\Image\Image1.jpg>". How could I make it that it transfers the hyperlink...
  6. I

    Let User Choose What Items They Want to Appear on Report

    Hi, I have a form that has the following: Item Text (Memo) Graphic (OLE Object) Case Text (Memo) CmdButton (Find) CmdButton (Add) They all come from different tables. I also have a report that looks like this: Case Text (I want this to be invisible if no Case Text is assigned to an...
  7. I

    Report Based on Items from List Box

    Addition By the way, they will be searching for items using either Item ID or Unique Item Identifer!
  8. I

    Report Based on Items from List Box

    Hi, I have a form that has the following: Item ID Item Text Unique Item Identifier Case Text Case Title I want to have a multiselect ListBox that users can add items to. Then, after they choose all of the items they want to appear on a report, the report opens, showing only the items that...
  9. I

    Hide Duplicates

    Got It! Hi, I got the answer to it. Just use "Select Distinct...." instead of just "Select...." You were right Neileg! Also, thank you o1110010!
  10. I

    Hide Duplicates

    ICL stands for Item Classification Level. What I want to accomplish with the combo boxes is first have a screen where the user enters all of the classifications that they need: Level 1 (ICL 1) Math Science Level 2 (ICL 2) Algebra Calculus Physics Chemistry Level 3 (ICL 3) Factoring...
  11. I

    Hide Duplicates

    Database Hi, thanks for responding.... Here's the stripped down version of the program. What are your suggestions? I want to filter data that has not been entered yet! (Sort of like generic coding).
  12. I

    Hide Duplicates

    Hi, I have a combo box that has a bunch of values. Some values repeat themselves. How do I hide those that are duplicates? I tried this: "Form_ICL.Combo1.HideDuplicates" But it gives me this error: "Compile Error: Invalid use of property." How do I hide the duplicate values in a combo box...
  13. I

    Adding OLE Object using Word Merge

    Hi, I have an OLE Object on a form and when I click the button, I want it to copy into Word. My Template looks like this: CaseText Graphic ItemText What command would I use to copy it to the Word Document? I tried: ".Goto what:=wdGoToBookmark, Name:="Graphic" .Paste [Graphic]" but seem...
  14. I

    Add Multiple Items using Word Merge

    Hi, I have a word template that looks like this: CaseText ItemText I can add one item fine, for example, on the access form, my item text for item 1 is: Sample Item 1 A. B. C. It has no case text. After I add this item, I want to add another item to the same file. For example, item text...
  15. I

    "Compile Error: User-defiend type not defined"

    Nevermind, sorry. Figured it out. Didn't have the neccesary libraries checked!
  16. I

    Creating Merge Template

    Hi, I tried to create this document template: CaseText ItemText But everythime I click the button in access, the template opens, but it contains this: CaseText ItemText In other words, it does not change the preset values. Here's the code I am using: ' Check for empty fields and...
  17. I

    "Compile Error: User-defiend type not defined"

    Hi, When I try to merge access text into a word template, I get the following error: "Compile Error: User-defiend type not defined." It highlights the following: "Dim WordApp As Word.Application." Why am I getting this error? Thanks in advance!
  18. I

    "Compile Error: Block If without End If"

    Thank you! That solved the problem!
  19. I

    "Compile Error: Block If without End If"

    Hi, When code this statement on ButtonClick: If IsNull(Form_ICL.ICL_5.Value) Then Form_ICL.ICL_5.Value = "" End If I get the following error: "Compile Error: Block If without End If" Why am I getting this error? Thanks in advance!
  20. I

    Memo Box to Word

    Hi, I have a form that contains the following: Item ID Item Text Item Key Item Keyword Item Author I want the person to find the record that they want and with the click of a button, open word, and trasnfer the text from Item Text (Memo Box) to the open word document. Is this possible...
Back
Top Bottom