Recent content by LeslyP

Well... the code of the Excel macro is not the same as that of the Access Excel macro and I have not found any "translator" yet. I'm going to take a break, but if I manage to make it work, I'll put it here for sure.

The link Gasman gave me is really nice. You can also write you macro directly in Access ! Directly write the Excel formatting function in Access Public Function runExcelMacro(wkbookPath) Dim XL As Object Set XL = CreateObject("Excel.Application") With XL .Visible = False...

Ah ! thank you so much. That's exatly what I was looking for. Google was not with me for that one. _____________ And thank you theDBguy for trying. It is nice of you ^^

Ok so here is my macro: Sub Prep_R() ' ' Prep_R Macro ' ' Selection.End(xlToLeft).Select Selection.End(xlUp).Select Range(Selection, Selection.End(xlDown)).Select Range(Selection, Selection.End(xlToRight)).Select Selection.Replace What:=" ", Replacement:="_"...

Hi theDBguy :) Thank you for you fast answer. Hummm, good question. I do not know if we can do that in Access. What I want to do is : 1. Change the spaces for "_" 2. Change all the letter with accent like "é" to no accent "e" 3. Delete all the " ' ' 4.Fill the empty space with "NA" Can we...

Hi everyone, My problem is about Excel and Access, so I was not sure where to ask it. In my Access database, there is a button to export the data in a Excel sheet. No problem for that. But then, I want a simple macro to start on the Excel sheet to "clean it" for analysis purpose. How do I do...

June7: Oh my god !! You're awesome ! It works number one :D I just need to add a "delete all records" before I can update new ones . Thank you sooo much !! Uncle Gizmo: Thank you for you help as well. It didn't work for me this time, but you already helped me a lot with you videos.

Hello everyone. As usual, what I thought would be simple end up being a headache. I hope we can find a solution to this problem. MajP: I tought about that and I end up with the same solution. Parameter 1, Parameter 1 Unit... I just didn't think about it before I did my exemple, because it is...

Thank you everyone for your answers ! :D MajP: I've 300 fields....for the moment. And maybe almost 900 later. It's all the time the same thing (weight, weight_unit, conductivity, conductitvity_unit...). So I think doing it one by one is not an option. What about Excel. Do I have to do it...

I want something like that.

Hello everyone :) I've got a simple problem. I want to switch my fields name into records. I already found a VBA code, I just do not know how to use it! Ahhh, the newbies! ^^ " It's probably not complicated when you understand VBA. I think I need to create a module first... but then ...

I will have to try later. For now, I have to move on Something else. But thank you very much for your help!

I can't figure out how to do that. I'm using Allen Browne's code to filter my form. How can I put the searches controls on another tab ? I thought it had to be on the header ? Damn... the more I learn about Access, the more I see I know nothing ! Sorry, I might just be tired ^^"

Oh my God, so many answers. Thank you. I thought it would be really easy....Sorry o.o" I don't want to waste everyone's time with that :S I think I'll just make everything smaller. It's not the better option, but damn. It's too complicated for not much. But if you still want to find a answer...

Ridders: Because I want my header to be smaller. The header grow and shrink with the layout.