Search results for query: *

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

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

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...

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

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

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

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...

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 ?

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...

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

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...

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

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

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...

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...

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

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

Thanks everyone. I got it to work.

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

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...