Search results

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.

Hello Richard ! Hi Ridders ! Thank you very much for your answer. So there not such a thing as this "move" I wanted... snif. The_Doc_Man :The subroutine you described is a little like what I want. Let me explain exactly what I am trying to do. The_Doc_Man and Ridders In the header, there is...

Hello, I want to do Something very simple, but....well, it's Access. I can't find anything on Google. So, I have some textboxes at a certain place in a form. When the form open, I move those textboxes (There are in the way) with me.textbox.top = 10. I want them to come back at their original...

Hello you who is looking for a solution ! you can find it here : https://access-programmers.co.uk/forums/showthread.php?t=299509

Hi ! for you who is looking to make a multicriteria search form with combobox and textbox to filter multivalued field you are a the good place. It is not perfect (I'm not a expert), but it works, at least. However, if you select "blue" everything that contains "blue" will appear. Better then...

Oh thank you The Doc Man !! I didn't know Access was doing this in my back :P I though it was the same as creating myself the relationship. I will change all those lookup things. So, Access is creating functionalities to help us.... but in the end, it's just crap. Like Multivalued fields xD