When I, and others, open my Excel VBA toolbox of macros – a message saying ” <<details to come>> you are about to open an ActiveX control. Are you sure … or something” appears. Here is the solution – you need to sign the macro with a certificate. Really this inflates people’s heads because we are […]
This database is ONLY to be used by Electrical so that any things we do only hoses us. Make a new database. Now the way to use SQL Server to log into a dB on another machine is to use the more complicated name for the database. myServerName.myDomainName.myDomainNameSuffix. Here is an example.
First a question: Could this be made more difficult? I switched from VS 2012 to VS 2013 and the new system uses a whole different authentication engine. Once you get your head wrapped around roles and users in the new system it works the same for the individual web.config files in the directories to limit […]
So it seems that one place I work had someone log in with remote software from corporate but without asking first. Sure enough – a little digging in the events viewer look for events with these id’s for Dameware. 105,108,111,112,109. Even better – you can add a filter and on the filter window – you […]
So I had an odd situation where one company I was working at turned off ALL OUTGOING ports (yes – all including the web) for all employees. You needed special permission and they would enable this. So all remote access was removed for all of my other clients – so I hitch hiked free wifi […]
So, a lot of the ports I need at a client are getting shutdown to the point, where I cannot work at that location to get my work done. I have another client not too far that I can SOMETIMES pick up on their wireless signal. Hmmm, what if I had a directional antenna and can […]
Deleting old backups automatically – no it does not work well. Here is how to do it manually.
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 […]
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 […]
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 […]