Search results for query: *

Many thanks PHV, I never heard before of VBA.collection. Found some material on the web, and works great for my problema. Thanks again, Gerald

Hi there, I have an undefined number of currencies for which I am calculating an exchange rate. I am willing to put those rates in an array for further calculations. What I would like to end up with is something like : dXRate("EUR")=1 dXRate("USD")=1.2 So that at then end I could call back...

Hi There! Does anyone knows where I could find VBA code examples related to Publisher? Many thanks, Gérald

Last step of vba : I set the focus on my first option control on which I allocated a onFocus event which hides the button. Works very well! Many thanks, Gérald

Hi everyone, I have a form whith cascading options (option2 control depends on option1 selection). Once the user has picked up all the necessary controls the submit button appears. When the user click on that submit button, macro his doing its job with the data and the form needs to be...

Hi everyone, I have in Access a macro doing the following : - open a word template - update a few modules in the Word project. Now I am looking forward to protecting that word project through this macro in access. I just can't find the way to protect the project through automation... As...

Hello, I am having a doc file which size is 12cm width for 16 cm height. I print it into the distiller, and whatever option I chose, the final acrobat document I get kept the formatting of the word document. Except that the whole text is centered in a Legal size document. How is it possible...

Hello, Let's say I have a csv file done that way : "Gerald";"Meunier";"2" "Mitch";"Farris";"3" "Erik";"Rapp";"2" Before importing this set of data into a table, I want VBA to map my third field : mapping...

Dear all, I have a table with 2 important fields : COD_AE which is an ID number COT_DATE which is a date There can be several date by ID. There can not be the same ID with the same date twice. My query asks for the latest date for one single ID. I want that date to populate a textbox. Has...