Can anyone point me to a large (200K) VBA file (not a small number of very long strings)? I'm trying to stress-test the visualizer models and view-models against large parse trees.
@M.Doerner Care to elaborate?
@IvenBach I'm just wondering: by what logic did the author promote the project as working with "VB.Net, VBA and VBScript", but not C# or .NET languages in general?
System Scheduler kicked off my scheduled job at 1am this morning, but somehow, the parameter didn't get passed in.
Several manual run attempts & it still wouldn't pass it in. (I log the passed parameter, I got nothing but NULL). Opened the Prod .accdb by hand, looked at the code, changed LogManager.Log DebugLevel, "Parameter(s): " & Command to LogManager.Log DebugLevel, "Parameter(s): " & Command$ (note the typed Command$) and it worked.
that was just the logging line, not the actual "take action if there a parameter here" line.
The "new build" nag notification for dev builds is really nice, but frankly, I don't care about a French translation update. (no offense to you French speakers, oui, non, Ou es la WC? is the extent of my French).
Is it possible to get just one notification and if I chose not to install, I don't get notified until the next build is out?
(I know that's a horribly bad spelling - it's been ages since I took French in junior high school. Please forgive me!)
so like old windows KB updates: "which ones do you want to install?" then you do the checkboxes and it createes a library of KBs and preferences, e.g., to not install that one in the future (but leaves it in the box as greyed out and italicized... just in case)
not sure if you all have different component installs to your updates, e.g., you list like notepadd++ does where "french" is a theme and doesn't need updated, but library references for python are core and should be installed
> **Rubberduck version information** The info below can be copy-paste-completed from the first lines of Rubberduck's log or the About box: ``` Version 2.4.1.5200 OS: Microsoft Windows NT 10.0.17134.0, x64 Host Product: Microsoft Office 2016 x64 Host Version: 16.0.4873.1000 Host Executable: MSACCESS.EXE ```
**Description** The `Copy to Clipboard` icon on the _Code Inspections_ window copies text to the clipboard, but it isn't the currently selected inspection, the current group of ins
@Hosch250 which type of cell tower? i feel like extenders are more interesting than the initial tower, as they have (typically) 10 additional transistors and an additional dual-power source as opposed to the digi-plate (dual power source with one large transistor and a rotational cuff, though the cuff alone is cool as hell, inside)
that crap is always quite fascinating (my son has been keen on construction, trains, etc., for some time so we look at a significant amount of books on the topics)
One of those big ones with a metal triangle on top with lots of big white rods sticking up.
I can't keep up with my Manning books anymore, LOL. They keep giving me free ones.
I got 2 free ones last weekend for reviewing a couple projects for them.
And a free one today for signing up for their daily deal email.
Their December count down thing is going to happen again, and I may or may not get one there (got one last year, but not with the Halloween one this year).
All in all, I have 4 unread books, 1 half-read book, and 1 unread written, but canceled, book (the author wrote it and they decided to not publish it, but put it up for free on their website).
2 of the unread books were part of an Angular pack, so I probably won't read them for a while. I read the other 2 in the pack, which were all I need for a while.
i mean, there are free libraries in your area (if you're in the states and most of europe) lol. i remember getting free journal articles (elsevier, pubmed, etc.) because they were required to provide login to all libraries
and for the ebook, pdf the whole thing... that typically isn't against Terms as it allows you to review the document while offline. after that it may or may not make it to other devices in or outside of your control
so in this case, .ActiveConnection = connect should really be .ActiveConnection.ConnectionString = connect because it's implicitly doing that for me and I should make it explicit.
because .ConnectionString is the default member of .ActiveConnection.
so I probably want to explicitly assign the default .ConnectionString in that case. Though, I don't close the connection in this case, so I should be good to go.
I'll need to think about each instance where this is flagged.
If connect Is Nothing Then
Set connect = New ADODB.Connection
connect.Open CStr(TempVars.Item("constring").Value)
End If
run that ^ once for this activity
connect is a module-scope global. ducks
I do have a '@TODO to fix it!!
@this does seem to be the way to go. Makes the background majik less background-majiky...
and then, in the same module there's this:
cnection.Open CStr(TempVars.Item("constring").Value)
Dim updateCommand As ADODB.Command
Set updateCommand = New ADODB.Command
With updateCommand
Set .ActiveConnection = cnection
so I'm not even remotely consistent in how I do it... :(
Dim updateCommand As ADODB.Command
Set updateCommand = New ADODB.Command
With updateCommand
Dim insertRS As ADODB.Recordset
Set insertRS = .Execute(recChanged)
End With
The most brutal part about the test, however is that you may have sections in the test and you can only be in the section only exactly once and cannot return to it once you leave it.
For example, in some of my advanced SQL exams, we might have a section about a scenario or 2, before we go into the section with all usual MC questions.
the scenario are usually allotted something like 15 or 30 minutes no, that's not right. I only have one time allotment for entire test. I just don't know where I am.
so I have to make super duper sure I'm confident with a scenario section before I leave because there's no returning. In end, I always end up with extra time left over, which gives me opportunity to review the current section (usually the biggest one) at my leisure. but not for the prior sections.
@FreeMan then you don't even need the recordset. Just .Execute recChanged, done.
@Hosch250 look into Microsoft Press cert prep books (that's how I learned .net btw). they're red, 2 to 2.5 inch thick, and come with a companion CD with exam simulations. don't bother trying the cert if you don't score 80+ on the sim
Double duck checking here: Code Explorer>Context Menu>Sync Project> (Update Components | Replace Contents) from files. Update just replaces the chosen file whereas Replace wipes everything but what is explicitly chosen?
@Hosch250 don't fool yourself: certs cover obscure parts of the framework and language that you haven't used before, and will likely never use in the future
back when the books were red there was a whole important part about CAS (now deprecated)
Right now, I'm learning F# and general Azure tooling, brushing up on C#, and trying to remember my Angular stuff. And I still can't process the information fast enough to keep up with my reading.
I switch topics when my brain gets full of one of them.
I think they are aware of some shortcomings w/ certs. I personally don't put too much stock in the certs when interviewing a potential candidate. I've interviewed a Microsoft trainer with more certs than I have and he bombed it.
My source WB I exported. The code files are there. When I (Update | Replace) the foo.BAS and bar.CLS files are (updated | replaced) respectively. Any bazz.DOCCLS are not.
Choosing replace displays the dialog Replace Project Component from Files. Nothing else and it replaces the modules. The DOCCLS modules are unmodified.
Getting consistent behavior with the ordering on File Explorer. IE If it's sorted by file name vs file type. Must think this through to describe correctly.
> **Rubberduck version information** Version 2.4.1.20898 OS: Microsoft Windows NT 10.0.18362.0, x64 Host Product: Microsoft Office 2013 x86 Host Version: 15.0.5023.1000 Host Executable: EXCEL.EXE
**Description** When choosing Code Explorer>Context Menu>Sync Project>Replace contents from files... if there is a missing document the replace proceeds up until the missing document is encountered.
**To Reproduce** Steps to reproduce the behavior: 1. Have a workbook with 3 sheets named Sh
VBA Rubberducking
VBA Rubberducking