Recent content by hfl

Have updated my first post to the .csv file instead of the table I got after my first import and updated the solution we found to only include the code for my actual problem :) But if anyone have a shorter way that would be super and I am always up for improving the code :)

Thanks for the suggestion but got help by a colleague :) In case someone should have a similar problem here is the working code. Option Explicit Sub Convert_and_format_test_results() 'Always open this selected sheet ActiveWorkbook.Sheets("TestResultsImported").Activate 'Clear...

Hello, Pretty new to coding in Excel so hoping for some help in here :) We got a many .csv log files as under but with +10k rows and 88 different tagnames, I have manually deleted 85 of them to make the example in this post smaller. So what I hope to automate is that it looks like the table...

Late to pick up the kids from kindergarten but solved my problem by converting the pdf files to .ps files instead, then converting back to .pdf files with pdfDistiller and then doing the the merger :) Thanks for any help anyway :)

Selecting and copying the pdf reports to a temp folder is not a problem, I select the Adobe pdf files I want from a searchable continuous form :) edit- I see I worded myself badly saying I open each report (like in Access report) when I meant Adobe pdf report file. Sorry about that. edit-

That is what I am doing first + digitally signing them with Adobe. But then later I might want 20 of the 950 pdf calibration reports in the database merged into one pdf file and I can't merge signed pdf files so I need to be able to print to Adobe PDF before merging and that is where I am stuck...

Hello :) In Access I make calibration reports which I digitally sign with Adobe and that part works perfect but I have run into a small problem, now I need to merge a lot of different calibration reports into one pdf file and I can't do that as long as the reports is signed. My workaround is...

@ridders That's what I didn't get to work, it would only make that one line wider and not the others added later. But I fixed it, I just added 10 lines, made them all wider one by one then I made a query to just keep the last 10 records for that ID sorted on date. Thanks for the help :)

Hello, I have a small problem with a line graph on a form, it's a "history graph" so it will only get more and more "lines" as time goes by. Problem: Changing the line weight in the line graph with VBA. I found this code online and it works for him but I get "Run-time error 438: Object...

@Static Thanks a lot, that worked perfectly and saves me a lot of time :)

Yes, I know... That's why I said in post #9 that I had explained my problem poorly and edited my posts, again I am very sorry. Will look into different forms for the forms with many buttons but I still want users to be able to quickly be able to look at status of the equipment with the color...

@ridders Again, sorry for not explaining my problem well enough at the start... :( So I want to click the buttons but not type any code for each button that I want to click. The form is just a fast overview of some of the equipment we have, green = good, yellow = calibration in 30 days or...

arnelgp: Thanks, didn't think to move it to the on click event outside VBA like that but still is more work than it was in A2007 but so far the best solution so thanks again :) Added an attachment to one of my forms, it's a form that shows equipment that needs calibration. Yes, I also have a...

But how do I get the control tip text to play only when I click the button, not when hoovering over it? Not sure if you have seen it but I didn't explain my problem well enough in my first post and I am sorry about that so I edited my post earlier today...

Yes, thanks for the example, had some other work stuff I had to take care of first :) If I read the example right it needs code in the on click event on all buttons to work and that is what I want to avoid...