Server 2012 backup links
Deleting old backups automatically – no it does not work well. Here is how to do it manually.
Recovering a filemaker runtime
Links so far in my research worth keeping (no solution yet) a) recovering a runtime solution – hold down Ctrl-Shift while double clicking application icon and hold them down til you see the dialog http://www.filemaker.com/help/html/fmpa_tools.24.19.html b) importing data into upgraded runtime http://www.filemaker.com/help/html/fmpa_tools.24.17.html#1028635 c) starting runtime solutions http://www.filemaker.com/help/html/fmpa_tools.24.18.html#1028687 d) naming a filemaker solution and this mysterious […]
Using a class from one Exvel workbook to the other. It can be done
https://support.microsoft.com/en-us/kb/555159 It works. Now, I have to have this workbook work when others do not have this “other workbook” so I use late binding and am not using “Tool->References” to ensure any of this works. Hard coding the path is also what I did – but since it is string you use to reference the […]
Excel 2010+ and basic authentication of data sources
Lets say you have an XML data source and you access it with VBA or thorugh a sheet with a data source already preset once and it worked. Note that this assumes that the link is behind a popup to enter your username/password (Basic Authentication) The next time you go into that sheet or run […]
Excel copy parses data incorrectly – how to pre-clear
Here is a good post that accurately resets what Excel parses on when you paste text. I have known for a long long time, that the LAST text-to-columns settings is what is used when one pastes data into excel, but I thought I would see (I finally snapped for the last time) what other people did. Well, […]
Removing duplicates rows in SQL and keeping the last one
Here is a good article with many links and debates. I have used the “accepted” answer and gotten 95% accurate results – so why not 100%? I have not solved that one. I am trying the 2nd answer which in the efficiency graph gives better results. http://stackoverflow.com/questions/18932/how-can-i-remove-duplicate-rows
Live Dashboards in Excel – from a good friend who did all the research
Here is a nugget – a friend of mine made a dashboard with no VBA where the user IN EXCEL – pulls down a dynamic value to … lets say “may 2015” and the charts etc. update. One could do this in VBA, but, you don’t have to. I thought it was worth saving/sharing the […]
PDF learning
I have a client who wants some PDFs messed with. To do so, layers need to be split and recompiled. Here are links that will help me decide which SDK to use how to … well … do it. A good discussion of pdf libraries layers or content streams extract layers http://www.soft-xpansion.eu/files/pdflib/PDF%20Xpansion%20SDK%20Guide.pdf foxxit, sdk documentation PDFtron […]
Telus V1000H hidden links
https://keithbalomben.wordpress.com/2012/03/29/telus-actiontec-v1000h-hacks-and-information/
Annoyed by Mac’s need to have an admin account to cancel a print job?
http://hints.macworld.com/article.php?story=20081107092520601 should fix that.