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 Chriss Miller 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. MikeCDPQ

    Open Webi report (.wid) from VBA

    Hi Steve, Would the same apply for Rich Client 3.1 which we also have access to. Thanks again. Mike
  2. MikeCDPQ

    Open Webi report (.wid) from VBA

    Thanks Steve, That's pretty much what I thought. I just wanted to have confirmation from a more knowlegeable person. Thanks and take care !
  3. MikeCDPQ

    Open Webi report (.wid) from VBA

    We are in the process of migrating from Deski to Webi (XI R3.1) Right now, I have VBA code that opens deski reports, refreshes etc etc. How can I open a Webi report on a repository from VBA ??? I looked in many different forums and have not found an answer yet. A trace of a hint would be...
  4. MikeCDPQ

    retrieving last updated file in folder

    Hi CautionMP Your solution works beautifully. That's exactly what I was looking for. Thanks a bunch ! Mike
  5. MikeCDPQ

    retrieving last updated file in folder

    I would like to know how to be able to retrieve the name of the last updated file that is found in a given folder. I have tried different file scripting scenarios but could not get it to work yet it should be so simple. Thanks for any suggestion. Mike
  6. MikeCDPQ

    Fomat local in control

    Thanks TheAceMan1 That's not something I can use in this particular situation but I do see plenty of other applications where I can use the code. You're the best ! Thanks a millon. Mike
  7. MikeCDPQ

    Fomat local in control

    I found my own solution. Might not be pretty but it works. Created a table with month numeric value and month French description. Linking month value from date to month value in other query. I then recreate the date in French with dateparts concatenation. According to my condition I either...
  8. MikeCDPQ

    Fomat local in control

    I know about the format function but I dont know how to display for exemple: Janvier in French instead of January in English. Thanks anyway ! Any other solution anyone ?
  9. MikeCDPQ

    Fomat local in control

    I have a form that uses if conditions in certain controls. Something similar to: If province = Quebec then "Bonjour" else "Hello" Based on this same condition I need to translate a date to French. In Excel, one would use:Selection.NumberFormat = "[$-C0C]d mmmm, yyyy;@" What would the...
  10. MikeCDPQ

    Retrieve value of array

    Thank Skip and Swi. That's exactly what I needed. Worked like a charm. Thanks a bunch ! Mike
  11. MikeCDPQ

    Retrieve value of array

    I have a slight problem where I want to find out the value of array (110, 120, 130, 310 etc.) and all I seem to be able to get is the sequential I tried declaring byval and that doesn't seem to work. Once again, must be so simple ... Thanks to anyone for any suggestions. Mike...
  12. MikeCDPQ

    On error only works once ???

    Hi SBerthold, Using Resume instead of Goto did the trick and worked like a charm :-) Thanks a whole bunch. Mike
  13. MikeCDPQ

    On error only works once ???

    Aside from the educational exchanges :-) does anyone have any idea of how to fix my error message ? Thanks for any suggestions. Mike
  14. MikeCDPQ

    On error only works once ???

    There is no IF condition other then the one liner that doesn't need an endif (This will simply cancel the process if user did not enter any value in the inputbox). If you look at the script the "on error" will trigger an inputbox by the same name and user would enter another PO which is then...
  15. MikeCDPQ

    On error only works once ???

    Here is a short script that I am having a problem with. User must input PO number. If PO not found ON ERROR clause works first time. If user re-enters valid PO, no problem. However if user enters another PO that can't be found, then I get error: Run Time error 91: Object variable or with...
  16. MikeCDPQ

    find name of first control on form

    Thanks Ed2020, Tried the code and it doesn't quite work. I'll fiddle with it and make it work. Thanks a bunch ! Mike
  17. MikeCDPQ

    find name of first control on form

    I have been looking for way longer than I care to admit :-( I need to find out what is the name of the field that has tab index 0 (or any other tab index number) on any given form Any suggestions ? something like: screen.activeform.control(0).name ??? Thanks
  18. MikeCDPQ

    Filter Excluding Selection

    Thanks everyone. I got it to work.
  19. MikeCDPQ

    Filter Excluding Selection

    I have a control with both values and blanks Using the Filter Excluding Selection also filters out my records where the value is blank. I want the filter to return all blanks and whatever is not equal to selected value. Thanks for you suggestions ! Michel
  20. MikeCDPQ

    Goto control with tabindex 0

    Thanks to both of you. I opted for Zion7's solution and added in the form section of the control: FirstFieldOnForm = Forms(CurrentFormName).Section(0).Controls(1).Name To answer you question, it seems that Control index is the absolute position of a control on a form whereas Tab Index can be...

Part and Inventory Search

Back
Top