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 Wanet Telecoms Ltd 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. LangAdel

    Using a form to enter report critia

    Hi Cillies Good ideas, but unfortunately that is not the case. Brian
  2. LangAdel

    Using a form to enter report critia

    I have used the "use a form to enter report criteria" help in access, and everything works fine, except: When I run the report I get my form up and I can enter the criterias. However when I press OK, instead of running the report, I get the standard Access "Enter Parameter...
  3. LangAdel

    Error in executing Excel-VBA when running on another PC

    Hi Leigh Your advise to Dim myFile As String actually solved the problem. Allthough I still dont understand why it works on my PC and not some of the others. Thanks Brian
  4. LangAdel

    Error in executing Excel-VBA when running on another PC

    Hi Leigh Thanks for your reply. Error message "error in hidden module". Myfile is being defined in the first line. Like I wrote it works on my own PC Brian
  5. LangAdel

    Error in executing Excel-VBA when running on another PC

    I have tool in Excel 2000, which can run a quesionaire in forms. One file has been made as a "administrative" tool where all questions are kept, and another file to run the questionaire. Problem: When running the files on my own PC everything works out fine, but when trying to run...
  6. LangAdel

    Copy a comment in a cell into another Cell

    Hi Glenn Thanks for your reply. But yes I need to do this for many cells, so I am looking for a VBA solution. Any Suggestions? Brian
  7. LangAdel

    Copy a comment in a cell into another Cell

    Hi Neil By duing that you copy the comment into another cell, which then has the comment as a comment. What I'm interested in is to copy the comment into another cell. regards Brian
  8. LangAdel

    Excel - IF function not quite working...

    Hi sohunter Tried your second formula, and I don't have any problems in making it work. (asuming that you seperate the argumentsin the formulan with ; and not ,) Could be your cellreferences which are not correct? regards Brian
  9. LangAdel

    Copy a comment in a cell into another Cell

    I have a cell, where a user has entered text in a comment, and I want to copy the comment itself into another cell. I have tried different approaches, but none of them work. Any help appriciated. Brian
  10. LangAdel

    Filter Vendor POC combo box based on the selected Vendor

    Hi Ann It dit'nt work exactly the same way, because I have the combobox on the same form. But if I put the Me.combobox.Request on the Combobox's own property under "On got focus" it works perfectly. You've earned a star for this Brian
  11. LangAdel

    Filter Vendor POC combo box based on the selected Vendor

    Ann I have the same problem and it sounds like you have solved yours by adding the WHERE clause. It works partly for me. I get the right "filter" but alwas the POC's related to the first vendor. So if I choose another vendor my form doesnt seem to be updated. Any suggestions? Brian

Part and Inventory Search

Back
Top