@this #1, we'd have to figure out a way to upgrade passwords at login time, so we take the old one, validate it, and if it's successful, update the hash.
@Hosch250 Interesting, SQL Server seemed to have solved that somehow by embedding the version and hash in the hash
but given the NIH syndrome around security infrastructure, I bet there are many applications that are too tightly coupled to a particular cryptography implementation.
BCrypt goes down? I'd just figure what the next one was, force a password reset on everyone, and swap the algorithm.
I'd probably just put a flag on the table saying which version the password was on.
Also, our current system doesn't have an easy way to force a password reset. I don't remember if it has it at all, but if it is, admins can't do it--we'd need a DA to do it.
Mine, all it takes is an admin to go in and check a box on the user admin page and save it.
Then next time they sign in, a box pops up and orders them to change their password.
Probably not the most secure, but most users would get the point.
I mean, a web dev could close the box, but it would pop up again next page they visited.
Every single feature I do is either more secure or faster or has more options than the existing system. Most of the time, it's all 3.
@IvenBach wait, did you not get the memo? If you still have stocks of old TPS cover sheets, you should continue to use them until you run out. You can then pick up some new-style TPS cover sheets from your line manager. Oh and by the way, Bob and Bob want to see you in meeting room 3.
Do not, under any circumstances, forget to attach a TPS cover sheet to your report.
I had a Lundbergh moment just recently... Will you cover the release? Yeah, sure. Later: So, you'll be in the office at 00:30? Uh, you want me onsite??? You know I live 90 minutes away, right?
FML
(Hence still being awake at 3am local, tryna acclimatise)
> And I said, I don't care if they lay me off either, because I told, I told Bill that if they move my desk one more time, then, then I'm, I'm quitting, I'm going to quit.
> And, and I told Don too, because they've moved my desk four times already this year, and I used to be over by the window, and I could see the squirrels, and they were merry, but then, they switched from the Swingline to the Boston stapler, but I kept my Swingline stapler because it didn't bind as much, and I kept the staples for the Swingline stapler and it's not okay because if they take my stapler then I'll set the building on fire.
You can use some assembly language to break limitations of vb, of course, the pros and cons of which are up to you. I'm just a porter. There's a function GetClassProcAddress：
Private Function GetClassProcAddress(ByVal SinceCount As Long) As Long
Dim i As Long, jmpAddress As Long
CopyMem...
Pure wizardry, love it!! This answer is getting an over-the-top bounty as soon as I can put a bounty up.. I need to think of the implications for Rubberduck - it could mean unit tests in class modules instead of standard ones... also the last thing standing in the way of a mocking framework for VBA is the ability to create an instance of a VBA class from an in-process IDE add-in; feel free to comment anywhere on that pull request if you have any insights! — Mathieu Guindon17 secs ago
I guess the laptop and the DB need to mingle at the Friday evening get together and have a drink or two. Get to know each other. Maybe in a month or two, they can go out for dinner on their own. Eventually, they'll start dating, but it will be quiet, not wanting anyone in the office to know. After a year or so, maybe there will be enough trust in the relationship for them to make it public & I'll be able to get logged in.
Though, my eldest got me a copy of Farming Simulator 19 for Father's Day. Totally pointless yet addicting game. Tried installing it on my desktop machine - on launch, the machine turned off. Just shut off, cold, no warning, no nothing! Wouldn't power back on for about 5 minutes. Had me worried.
Read the back of the box - my desktop does not meet the minimum hardware requirements. Pretty subtle method of letting me know... :(
@Hosch250 assuming this is for failing to provide the proper credentials x number of times? I'd say yes. Those who legit fat-finger/forget their password will only be more frustrated with your service if they get no feedback at all. If its a forum Shadow banning is somewhat acceptable
hm. That blog is chinese and only has code - the post at least elaborated some more.
Granted, it's not cool if he copied without attribution, but I would not also be surprised if the code was found in other places and he at least gives more detail -- the blog seems to be just the "here's the code" (but in Chinese)
still, it looked like a MSFT staffer sharing a nugget of insider knowledge... there goes our hope of having anyone at MSFT help us create a VBA class instance...
yeah I know.. but if it were a MSFT staff legit posting that answer/code from their own knowledge base, we would have had a chance to get help with instantiating, I think. now, not so much.
open an issue, or make a PR. MS docs are open-source and continually updated. VBA docs is 30K+ pages of documentation and 1-2 staffers maintaining it - they can't catch everything that's wrong by themselves.
so yeah, i was trying to make a thing that would allow me to figure out the username based on the email address
Public Function GetNameFromEmail(ByVal argEmailAddress As String) As String
Dim con As ADODB.Connection
Dim com As ADODB.Command
Dim rs As ADODB.Recordset
Set con = New ADODB.Connection
con.Provider = "ADSDSOObject"
con.Open
Set com = New ADODB.Command
Set com.ActiveConnection = con
com.CommandType = adCmdText
com.CommandText = "SELECT name FROM 'LDAP://DC=???,DC=???' WHERE objectCategory='user' and mail = '" & argEmailAddress & "'"
Set rs = com.Execute
censored my domain info, but it worked like this
and before you guys go on about doing concat on the sql, it errors out when i attempt to use parameters
I created a log routine that creates a module in the desired file that records all changes for future auditing based on workbook events. I would like to com up with an alternative that I can activate at the start of a long process of routines applied to 100.000 rows, which mine doesn't seem to be...
Also, how do we teach people not to use 10,000 lines of code to "read information from the sheet, do some calculations, update an excel chart on the sheet, and write some data back to the worksheet"?
@Hosch250 really I don't get it. The whole thing about normalization is easily summed up in the phrase "a place for each thing and everything in its place."
I suppose that in Excel, they have no problem making sheets 2019, 2018, 2017, etc. or Jan, Feb....Dec. To tell them that it should be in one big bucket is tantamount to heresy.
But here's the thing... I instinctively want it all in one table! That way I can use filters! If it's across sheets, then I can't do comparisons across years!
I fixed some bugs with lockout controls, I added support for more "tokens" (i.e. you can do [user(currentUser):firstname] or [user(jdoe):firstname] and it will populate it).
@Hosch250 how would you go about grabbing .md files on the RDWeb repo, and using that for content? Idea being, we'd want to edit .md files, not recompile and redeploy the whole damn website... Thoughts?
Exactly like I'm doing with my doc structure on Amethyst.
So, it would be in the solution as a content file, push with each deploy.
You go into the solution and edit that, and then push and have it auto-build. When the user requests a doc, you load the .md file and render it as HTML.
i remove the module from the local application, then i export to file the copy from the "source" access file, then i import the file into the local application
yeah.. we both concluded that what we really want is just bring the required witnesses to a courtroom, sign the damn paperwork, and get it over with. no need to spend/waste $30K that we don't have on it
You can use some assembly language to break limitations of vb, of course, the pros and cons of which are up to you. I'm just a porter. There's a function GetClassProcAddress：
Private Function GetClassProcAddress(ByVal SinceCount As Long) As Long
Dim i As Long, jmpAddress As Long
CopyMem...
VBA Rubberducking
VBA Rubberducking