« first day (1782 days earlier)      last day (1398 days later) » 

Duga
Duga
12:01 AM
RELOAD!
[bruglesco/FleetCommand] 1 commit. 18 additions. 4 deletions.
[Etrisa/teleportcost] 1 commit. 21 additions.
[rubberduck-vba/Rubberduck] 3 issue comments.
[Minesweeper] Games Played: 107, Bombs Used: 66, Moves Performed: 13950, New Users: 17
 
IvenBach
IvenBach
12:20 AM
@MathieuGuindon ^
 
Mathieu Guindon
Mathieu Guindon
lol I saw that movie with the kids just yesterday, was awesome
 
IvenBach
IvenBach
That movie was so much better than I thought it would be.
I like the out of shape Peter Parker.
 
Mathieu Guindon
Mathieu Guindon
Porker ;-)
it was great, felt like a living comic
 
Mathieu Guindon
Mathieu Guindon
12:36 AM
@IvenBach so did that build ended up building?
 
IvenBach
IvenBach
@MathieuGuindon To build on my work machine?
 
Mathieu Guindon
Mathieu Guindon
yeah, still not working?
 
IvenBach
IvenBach
I didn't get around to it. Had to pick duckling up from school Friday.
 
Mathieu Guindon
Mathieu Guindon
oh
:)
 
IvenBach
IvenBach
Today played catch up from Friday. And a bit of slacking off not getting to it.
Off work tomorrow and Wed for road trim to see my idol.
Maybe Thu/Fri.
 
 
3 hours later…
IvenBach
IvenBach
3:26 AM
@MathieuGuindon ^ I found something for you.
 
Mathieu Guindon
Mathieu Guindon
> Printer is coming...
lol
 
IvenBach
IvenBach
3:43 AM
I haven't seen it so don't get the reference.
 
Mathieu Guindon
Mathieu Guindon
the family words of House Stark are "Winter is coming"
 
 
1 hour later…
Peter M Taylor
Peter M Taylor
5:00 AM
Umm I believe “this is fine” is taken to extreme here...twitter.com/antirez/status/1120363933204873216?s=21
 
 
3 hours later…
Vogel612
Vogel612
7:35 AM
> All Online Seats Are in Use
Seats will become available after 15 minutes of inactivity. In the meantime, you can continue to browse and search.
~sigh. Obtaining academic papers is such a fucking pain
 
 
4 hours later…
FreeMan
FreeMan
11:10 AM
@IvenBach I've understood that it will make my life better, it's just been a matter of figuring out a good way to get code in/out of VBA and then of actually wrapping my head around the concepts.
I've got the first down (at least for Excel, working on an Access version of it today), and the second just suddenly started clicking last week.
 
FreeMan
FreeMan
11:45 AM
@MathieuGuindon You've commented multiple times about the evils of Attribute VB_PredeclaredId = True in forms giving you a default instance that's easy to abuse to your detriment.
Would it be reasonable to set that to Attribute VB_PredeclaredId = False in order to prevent one from accidentally abusing it?
Would that break anything in the way VBA expects forms to work?
 
Mathieu Guindon
Mathieu Guindon
Might screw up the designer I'd think. But no, predeclared id isn't evil. It's a stateful default instance that's problematic.
Also probably screws up the global Forms collection
never tried tbh
but I use that default instance to get a parameterized factory method that takes the model instance
 
FreeMan
FreeMan
A (perhaps optimistic) thought that hit me as I was working on exporting code from Access this morning...
Not nearly as bad as I thought... in this project, the biggest module I've written a is 55Kb .bas file. (A Tim Hall *.bas is 111k but I don't count that against my coding skills - that's just borrowing skills).
I'd have thought it would have been much worse!
git this sucker up and time to start refactoring!
where does refactoring stop and rewriting begin?
@MathieuGuindon I was referring specifically to the abuse of the default form that most VBA programmers end up using as evil, not Predeclared ID in general...
 
Quack Exchange
Quack Exchange
12:21 PM
0
Q: Export OLEObject to a folder

DirectionskyI got this code from "https://www.pcreview.co.uk/threads/how-can-i-output-the-file.2824299/" The code launches each and every OLEObject in the sheet in new image viewer window, i tried to loop through to avoid some 100s of windows, i failed to do so. I want to extract the images so as of now i w...

vba excel
 
Son Goku ssj4
Son Goku ssj4
@MathieuGuindon: Good morning Matt. I owe you info about the 'backspace' thing. In my work computer, no problem. Office 2016. Backspace behaves normally.
It CAN be a problem with Office 2019/365 which I had on my personal devices.
 
Duga
Duga
12:33 PM
 
Mathieu Guindon
Mathieu Guindon
12:48 PM
@SonGokussj4 hm, I need to download/install 2019 & repro
Wait is it 365 or 2019?
 
Duga
Duga
 
this
this
1:04 PM
@Duga only 2 behind now
 
Hosch250
Hosch250
@MathieuGuindon So pessimistic.
 
FreeMan
FreeMan
1:24 PM
If I do 
  Dim project As VBProject
  Set project = Application.VBE.ActiveVBProject
am I leaking anything because of the Application and VBE objects, or does VBA's cleanup take care of that automatically?
I remember some discussion about that, but don't recall all the details
i.e., do I need to Dim App as Application and Dim VBE as Application.VBE and New each of them up as a child of the previous?
 
this
this
I don't think leaking is an issue. More bigger is whether you'll trip up security alerts and whether it's the project you want.
 
FreeMan
FreeMan
It's for internal use, and despite 3 AVs running on our work machines, I've not had anything yell at me, so I think I'm good there.
As far as a project I want - I'm doing my best to not blow it up shoot myself in the foot.
 
this
this
No, not that kind of security alert - it's the one by Office itself
e.g. "Allow programmatic access to VBE" checkbox in the trust center.
but since you didn't get yelled, I guess that was already checked
for the project - if you are using Access and you do want the current file, you should use the Application.WizHook.dbVbcProject instead.
 
FreeMan
FreeMan
@this ah! yes, I did have to go check that when I started this last week.
 
this
this
that will get you the correct VBProject, even if it's not currently active. That can happen if you have some Access add-ins loaded
 
FreeMan
FreeMan
1:29 PM
Seems it's Office universal, since I did it in Excel, and I'm now running in Access and it didn't yell at me
Add-in free, other than the duck. I'm a purist!
:)
 
this
this
duck isn't an Access add-in, either. ;-)
 
FreeMan
FreeMan
however, I'll look into WizHook
It's an add-in... :P
 
this
this
Undocumented, Will Robinson!
 
FreeMan
FreeMan
 
this
this
But you can google and there's various sites hosting a helpful PDF that explains what the WizHook does. I think you need to provide it with the key before you can use that method. But that method is guaranteed to work in all circumstances.
Unrelated: You have to admit that the robot in the clip looks well... bulky
 
Duga
Duga
1:47 PM
 
Duga
Duga
2:13 PM
 
Mathieu Guindon
Mathieu Guindon
@Duga @Vogel612 I really like the refactoring work in this PR! ...help me out here, I'm failing how it fixes the language-switching exception... does the assembly={nothing} have something to do with it?
 
M.Doerner
M.Doerner
I think what fixes the exception is replacing the inline search box with inline resx styles with a real class.
 
Mathieu Guindon
Mathieu Guindon
interesting
 
M.Doerner
M.Doerner
I think Vogel mentioned that the setters on the inline one are sealed.
 
Duga
Duga
 
Hosch250
Hosch250
2:23 PM
@Vogel612 Pretty sure you don't need assembly=. You can just remove that part, IIRC.
 
Duga
Duga
Create SearchBox component

This component replaces the search boxes in CodeExplorer and Add/Remove References dialog.
It provides a vast simplification over the preexisting use of overriding a TextBox with a
Style defined in the resources section.

Also this commit moves Behaviours into their own solution folder, though no namespace adjustments
are performed.
Replace Search box in CodeExplorer and ARRD with component

This commit also fixes #4915 by virtue of changing how the text is set
Merge pull request #4929 from Vogel612/fix/language-change-exception

Fix language change exception
 
M.Doerner
M.Doerner
That makes it impossible to update them, which the system will try on language change for all things bound to resources.
 
Vogel612
Vogel612
@MathieuGuindon The issue was related to how the style was setting the Tag property before
 
Mathieu Guindon
Mathieu Guindon
> "This leads to RD being translated about half." - that's the bit I had missed! :)
 
Vogel612
Vogel612
that was sealed after first use, and changing the language resulted in the thing blowing up
I was considering to write an analyzer to avoid something like this in the future, but that might be overkill
 
M.Doerner
M.Doerner
2:26 PM
I think the translation simply stopped when encountering the exception.
 
Vogel612
Vogel612
and I don't really have the time to work myself into that in the forseeable future
@M.Doerner yes, exactly
it's also the reason why the settings window didn't close after pressing OK for the first time, btw
 
M.Doerner
M.Doerner
Makes sense.
 
Vogel612
Vogel612
Unrelatedly: allergies are a frigging pain in the backside
 
Mathieu Guindon
Mathieu Guindon
FWIW, Roslyn analyzers working with XAML are possible, but not the "normal" way
2
A: Roslyn: Access XAML of a partial class from code analyzer

Jason MalinowskiRoslyn exposes an AdditionalFiles mechanism where you can specify some additional files to be passed into your analyzer which you need the content of. XAML files for what you're doing would be a perfect example. We have one Roslyn analyzer that we run on Roslyn itself that verifies that the types...

 
Vogel612
Vogel612
aight nevermind that, then
 
Mathieu Guindon
Mathieu Guindon
2:29 PM
was a nice idea though :)
 
Vogel612
Vogel612
it's basically a regression test, so it would've been useful
@Hosch250 it actually forces the current assembly. I though it might help work around the issue with the version string in the RD.Core.csproj.
and now it's in because it's more explicit that way :D
 
Mathieu Guindon
Mathieu Guindon
@Vogel612 GTK
 
Vogel612
Vogel612
for whatever it's worth: it didn't help :D
 
this
this
maybe cake will help?
 
Duga
Duga
 
Vogel612
Vogel612
2:34 PM
@this possibly, but I kinda want to work on tech-debt payments and bugs before introducing cake
 
this
this
yeah
 
Vogel612
Vogel612
also we would want a working msbuild anyways, forcing use of cake results in forcing the cake extension onto contributors, which is something I kinda dislike
 
this
this
oooooh that's a big bummer
 
Vogel612
Vogel612
exactly :)
 
this
this
Who knows. When the core 3 comes out - it might make msbuild issues moot.
OTOH, it might just make everything worse.
 
Vogel612
Vogel612
2:38 PM
It should make them mostly moot.
It should especially take care of building in VS2019
currently we're stuck on 2017, because new csproj is not supported in 2015, but Sunburst is not working in 2019
 
this
this
and author won't be maintaining Sunburst. Unsurprisingly since he considered it a stopgap anyway
 
Vogel612
Vogel612
Which is kinda the whole point of the thing. You don't want people to depend on a stopgap if you can help it
 
Vogel612
Vogel612
2:52 PM
Anyways, I'm back to prepping for my granddad's birthday
 
Duga
Duga
[rubberduck-vba/Rubberduck] build for commit 4d5420b6 on next: AppVeyor build succeeded
[rubberduck-vba/Rubberduck] build for commit 4d5420b6 on next: 64.47% (target 0%)
 
Duga
Duga
3:14 PM
 
Mathieu Guindon
Mathieu Guindon
@Duga no I didn't #ReadFail
 
FreeMan
FreeMan
@this I thought cake was a lie...
 
Duga
Duga
> # [Codecov](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/4927?src=pr&el=h1) Report
> Merging [#4927](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/4927?src=pr&el=desc) into [next](https://codecov.io/gh/rubberduck-vba/Rubberduck/commit/63e529a2bd25f73822bcea037c83b4001b5aa800?src=pr&el=desc) will **increase** coverage by `0.04%`.
> The diff coverage is `0%`.


```diff
@@ Coverage Diff @@
## next #4927 +/- ##
===========================
 
this
this
@Duga not sure how CodeString relates in any way to accesibility. Why not ModifierString?
 
Mathieu Guindon
Mathieu Guindon
3:35 PM
@this tbh the ideal would be a ToString override... ModifierString could be a better name, yeah.
 
Duga
Duga
3:55 PM
[rubberduck-vba/Rubberduck] build for commit cd9e6981 on unknown branch: AppVeyor build succeeded
> # [Codecov](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/4927?src=pr&el=h1) Report
> Merging [#4927](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/4927?src=pr&el=desc) into [next](https://codecov.io/gh/rubberduck-vba/Rubberduck/commit/63e529a2bd25f73822bcea037c83b4001b5aa800?src=pr&el=desc) will **decrease** coverage by `0.02%`.
> The diff coverage is `0%`.


```diff
@@ Coverage Diff @@
## next #4927 +/- ##
===========================
[rubberduck-vba/Rubberduck] build for commit cd9e6981 on unknown branch: 64.51% (target 0%)
 
mansellan
mansellan
4:32 PM
@this uh, wut? I thought Muricans were Christianity-central?
 
Hosch250
Hosch250
@mansellan Not really.
 
Mathieu Guindon
Mathieu Guindon
Easter is all about chocolates and bunnies, isn't it?
 
Hosch250
Hosch250
So, Christianity is the majority religion here, but even then, I'd guess that it's only around 50%, and a lot only declare themselves Christian because their parents did.
 
mansellan
mansellan
@Vogel612 UK, Easter Sunday is one of only two days of the year (the other being Christmas day) where large shops are forbidden from opening.
 
this
this
What Hosch said. It's mostly nominal.
 
Hosch250
Hosch250
4:34 PM
@mansellan Such a law would get shut down very quickly here.
 
mansellan
mansellan
@Hosch250 IIUC (I may not) - the coasts are less religious, the centre, uh, more enthusiastic...
 
Hosch250
Hosch250
@mansellan Nope, it's by city/country, mostly.
 
mansellan
mansellan
huh, #TIL
 
this
this
Feh. And even so, enthusiasm isn't the best indicator.
just because they talk more about God, doesn't mean they actually pay attention.
 
Hosch250
Hosch250
@this That.
 
mansellan
mansellan
4:36 PM
We see various TV programmes of evangalists, assume its the norm...
 
this
this
LOL
 
Hosch250
Hosch250
@mansellan It's kind of a thing where people watch/attend church on Sunday to try to play safe with God, then go do their thing.
 
this
this
^
really, lot of people treat church as basically a social gathering.
 
mansellan
mansellan
My buddy used to live in Texas though, and kept his atheism plenty quiet. He said his neighbours would rather he admit he was an axe-murderer than an atheist...
 
Hosch250
Hosch250
My pastor says it's about as effective for most of them as sitting in a garage and thinking you're becoming a car, LOL.
@mansellan Some are like that, LOL, but I bet he was exaggerating a bit.
 
mansellan
mansellan
4:38 PM
lol
 
this
this
a thought though - if you're an ax murderer why would you want to believe in God? As an atheist, no sweats. You're dirt once you're dead. If not, then you're going to have a little discussion about your propensity to wield an ax, no?
 
mansellan
mansellan
@this Well, perhaps, unless you're doing God's work with the axe. Plus, atheism != amoral. I wield an axe only when chopping wood. :-)
Also, #TIL axe is a UK-ism. Ax gets no red squiggly.
 
this
this
4:53 PM
here it's 50-50, I think
those who think they are doing God's work with an ax are more likely to be disappointed. Atheism may not be amoral but it doesn't have an objective basis for morality.
 
mansellan
mansellan
@this Uh, theism doesn't have one either... but I'll stop there, as this is not the right forum :-)
 
Mathieu Guindon
Mathieu Guindon
@mansellan #TIL
 
this
this
agreed - we'll have to agree to disagree. :)
 
mansellan
mansellan
^
 
IvenBach
IvenBach
@mansellan Very few actually practice and abide by what is taught.
 
mansellan
mansellan
5:04 PM
@IvenBach true
treads very carefully, friendship is more important than argument
 
IvenBach
IvenBach
I'd rather have an athiest as a friend that has a good heart than any religiously affiliated person that isn't. But that's just me.
 
mansellan
mansellan
I like that perspective :-)
 
this
this
5:17 PM
+1
 
KySoto
KySoto
so i did a little test
to see if i could get another VBProject to show up in position 1 of the VBProjects collection
so it seems that no matter how i try to do it, i cant get any addon projects to show up in position 1
now, this is in access, not excel
 
Mathieu Guindon
Mathieu Guindon
what's at position 1?
 
KySoto
KySoto
the file's project
 
Mathieu Guindon
Mathieu Guindon
I'm pretty sure it depends on the order things get loaded
i.e. host/implementation-dependent
 
this
this
it's rare and does not happen but it can - I think the key is to open Access without opening the file, activate the add-in, then open file.
 
KySoto
KySoto
5:30 PM
i cant find a way to load a plugin/addon before the file
 
this
this
Or maybe when you open a file, load the add-in, close the file, then open some another file.
 
KySoto
KySoto
how do you activate an addon without opening a file?
 
this
this
Don't remember how but it does happen
 
KySoto
KySoto
yeah it does seem to allow you to do that
 
this
this
As Mat said - it's host dependent. 95%+ of the time, the first project is the file's project but you can't guarantee that.
and to be clear, I speak of Access only. I don't know how Excel does its thing.
 
KySoto
KySoto
5:31 PM
i never open files in access though
 
this
this
I haven't had to do programmatic stuff in Excel very often.
 
KySoto
KySoto
though with how i use access, id never run into this oddity
 
this
this
and they are usually one-off so I can get away with the ActiveVBProject shortcut
 
KySoto
KySoto
though as far as i know, there are only 2 people who use ANY addons in our entire company
 
Mathieu Guindon
Mathieu Guindon
@this Excel loads all add-ins while the splash screen is shown, i.e. before ThisWorkbook gets to be created
 
this
this
5:33 PM
@MathieuGuindon can they be active instead of the current file? (e.g. a case where ActiveVBProject won't return what you want?)
because I don't know if there's an equivalent of dbVbcProject for Excel.
 
Mathieu Guindon
Mathieu Guindon
in Excel you wouldn't be gambling... you'd retrieve the Workbook you want the VBProject for, and go Set vbp = theBook.VBProject
 
this
this
In most cases, the programmatic stuff are usually administrative in nature (e.g. I'm doing some refactoring or whatever) - so I do admit to use ActiveVBProject shortcut since I'm manually activating the code. But when writing code that's to be shipped, dbVbcProject is a must.
Ah, so it's an exposed property on Excel's OM. Cool.
For some reason, that's not the case on Access' OM.
 
Mathieu Guindon
Mathieu Guindon
that does complicate things
 
this
this
Interestingly, there is a Access.Module which is very very thin wrapper over the VBIDE.Module
 
Mathieu Guindon
Mathieu Guindon
is the project named?
 
this
this
5:36 PM
but they can't be substituted one for other, IIRC.
It can be but it may have a default name.
 
Mathieu Guindon
Mathieu Guindon
if it's named then you could dereference it by name through VBE.Projects, no?
 
this
this
That is assuming you know the name which may be whatever.
 
Mathieu Guindon
Mathieu Guindon
well, Alt+F11 and you know what name you need, no? I feel like I'm missing something...
 
this
this
2 mins ago, by this
In most cases, the programmatic stuff are usually administrative in nature (e.g. I'm doing some refactoring or whatever) - so I do admit to use ActiveVBProject shortcut since I'm manually activating the code. But when writing code that's to be shipped, dbVbcProject is a must.
 
KySoto
KySoto
it seems so wierd that the only reliable way to get the access file's VBProject is to use an undocumented function
 
Mathieu Guindon
Mathieu Guindon
5:39 PM
If Application.VBE.VBProjects.Count = 1 Then
    Set vbp = Application.VBE.VBProjects(1)
Else
    ' work by elimination? exclude known add-ins' names...
End If
 
this
this
As an example, if I'm writing an add-in to do some programmatic changes to a file, I'd rather not have to play the "guess the VBProject name" game.
 
Mathieu Guindon
Mathieu Guindon
@this I can see why
 
KySoto
KySoto
you know, i dont know if there are any useful user addons for access
 
Mathieu Guindon
Mathieu Guindon
is there a UserVoice to add a VBProject member to whatever the host document type is in the Access OM? Database.VBProject?
 
this
this
the vbproject name does not even have to be the same as the file name. I suppose it is also possible to have multiple projects load.
Not that I'm aware of.
@KySoto what about field effect's SQL Editor?
the addin I mentioned is mostly in-house.
 
Mathieu Guindon
Mathieu Guindon
5:41 PM
5
A: Get the VBProject of a Database

HansUpLook in the VBProjects collection and check each project's FileName property. If a project's FileName is the current database file (CurrentDb.Name), that is the one you want. Public Function ThisProject() As String Dim objVBProject As Object Dim strReturn As String For Each objVBP...

wah
 
this
this
Clever. Didn't even think of the FileName property
 
Mathieu Guindon
Mathieu Guindon
knowing that the VBProject.Filename getter throws if the host file isn't saved, IDK.
 
this
this
who's Rubberduck?
 
Mathieu Guindon
Mathieu Guindon
public string FileName
{
    get
    {
        try
        {
            return IsWrappingNullReference ? string.Empty : Target.FileName;
        }
        catch (System.IO.IOException)
        {
            // thrown by the VBIDE API when wrapped VBProject has no filename yet.
            return string.Empty;
        }
    }
}
 
this
this
that wouldn't be the case w/ Access, I think.
In Excel, you can create a blank workbook that's not saved yet, and start writing VBA code, right?
 
Mathieu Guindon
Mathieu Guindon
5:43 PM
I don't think Access gets a different VBIDE API than Excel or any other host
@this yeah
 
this
this
In Access, you must create a file first before you can start writing VBA code.
 
Mathieu Guindon
Mathieu Guindon
right, if Access creates the file first, #ProblemSolved
 
this
this
You can't get to create a database up in the air like you can w/ a workbook.
Yeah, yay for host quirks!
 
Mathieu Guindon
Mathieu Guindon
makes sense
 
KySoto
KySoto
@this uhhhh whats that?
 
this
this
5:45 PM
since we're VBIDE add-in, we have to handle all hosts' quirks.
(not sure I can call Excel's up-in-the-air workbook a quirk but it is something we have to handle)
 
KySoto
KySoto
ahh nevermind, i have it
but, why would a user (non programmer) need that addon?
 
this
this
ahh, didn't understand your original question. No, I can't see add-ins being used like that.
This just massively complicates the distribution.
To my mind, Access add-ins is more useful to a programmer, and isn't something you ship.
In fact, I think PowerPoint add-ins are similar in that regards
 
IvenBach
IvenBach
#TIL some cars come with ass warmers... My wife’s elbow activated it without me knowing. I already knew mine was hot but didn’t take it literally till now. #RoadTripDiscovery
 
this
this
Excel add-ins, OTOH, seems to be popular among users and programmers both; they think nothing of shipping a Excel add-in.
IDK how Word add-ins work.
 
KySoto
KySoto
so really if there is production code out there that references the vbproject (i dont really know why you would in production...) the only people who have to be careful about how they open files are devs
 
this
this
5:48 PM
uh, ok but if you're writing an addin why should you care how a file is opened?
 
Hosch250
Hosch250
@IvenBach Mine has it.
 
this
this
you want an addin that works anywhere, anytime, no?
 
Hosch250
Hosch250
It's indispensible when you park outside, and it gets to -50, and you are in dress clothes.
 
KySoto
KySoto
uhh what addin?
 
this
this
As I said earlier, in-house addins that you write to automate some of the tasks?
for example, I have one that is used to generate VBA stub codes for stored procedure.
 
KySoto
KySoto
5:49 PM
anything ive written to automate stuff has been out of sight for users
 
this
this
Same here but I don't want to deal with error just because I opened a file differently
 
KySoto
KySoto
oh you mean an addon for the devs
 
this
this
Yeah. Doesn't even to have be an actual add-in, either. Could be just a plain file that manipulate some other file, too.
 
KySoto
KySoto
well i didnt realize that it would open an addon's vbproject before the actual file's if you open a file, load an addin then open another file
 
this
this
Yeah - that's why I'm a big believer in writing robust code that works no matter how it's invoked.
 
KySoto
KySoto
5:51 PM
i do try to do that
but then theres return on effort
if the two people who have addins installed always work the same way
is it worth catching for the way they dont use it?
its a lot more time consuming to try to break it then to work the way we already do
then if it breaks, close access and re-open it, it will work
then again, i barely learned about the wizhook thing a couple of months ago vs when i set up the functions/subs that use vbproject
 
this
this
it's just using WizHook.dbVbcProject vs. blindly grabbing ActiveVBProject....
 
KySoto
KySoto
hell, back when i wrote that stuff i didnt have ANY addins
 
this
this
that can be easily found & replaced, no?
e.g. convert all reference to ActiveVBProject into GetCurrentVBProject function which will do the right thing.
 
KySoto
KySoto
id probably name the function accessIzDumb
 
Mathieu Guindon
Mathieu Guindon
@this I call a throwing getter a quirk of the VBIDE API :)
 
this
this
5:56 PM
LOL
 
 
3 hours later…
this
this
8:39 PM
 
Mathieu Guindon
Mathieu Guindon
#WhatCouldPossiblyGoWrong
 
this
this
#SomeoneHasNoCluesAboutCS101
 
mansellan
mansellan
9:06 PM
um, isn't sharing a database a thing?
maybe not access, ofc...
;-)
 
Vogel612
Vogel612
IIRC you can share an access-DB just fine
 
mansellan
mansellan
^ sure, there's always "Compact & Repair". Regularly.
 
this
this
It depends on what we are talking about .
an unsplit Access database is just like any other documents. Copy'n'paste. Freak out when you have multiple versions of truth
A split Access database means that you better be able to access the backend (generally via a shared network folder) which restricts you to a LAN environment.
 
Mark Balhoff
Mark Balhoff
Yeah the linked request is very vague
 
this
this
That's why I don't think he really understand basic CS.
 
Mathieu Guindon
Mathieu Guindon
9:10 PM
> Outlook is refusing to attach my 1.8GB Access database. What am I doing wrong?
 
mansellan
mansellan
Honestly, I don't see the appeal of Access. There are better engines. There are better front-end options. Sure, the two are there together, and they're near-ubiquitous. But there are better options.
 
this
this
Shadow IT, remember?
 
mansellan
mansellan
Yeah... bt;dt.
 
Mathieu Guindon
Mathieu Guindon
@mansellan I can see RAD being useful if you don't have Visual Studio and SQL Server and SSIS and SSRS deployed and under your full control :)
 
mansellan
mansellan
How quickly I forget.
 
Vogel612
Vogel612
9:12 PM
IIRC the whole asp-classic application I was maintaining ran against an access database
 
this
this
The whole point is to be able to solve business solutions without having to get approvals from bloated IT dept who doesn't give a fig for little guys, demand months and thousands of internal budgeting dollars, etc.
 
Mathieu Guindon
Mathieu Guindon
@this lol, that's me :)
 
this
this
It is definitely a thing in corporate departments who don't want to deal with IT
 
Mathieu Guindon
Mathieu Guindon
^ btdt
 
Mark Balhoff
Mark Balhoff
@mansellan well the appeal seems largely for less technical people who don't know better to get a pre-installed database that is quicker GUI off the ground than SQL/C# or other similar combos
 
this
this
9:13 PM
^
 
mansellan
mansellan
@this like I say, bt;dt. Got my start that way, in fact. But MS could, and should, make better shadow IT available.
 
this
this
I think that's what they are trying to do, with the Power Platforms at least.
 
Mathieu Guindon
Mathieu Guindon
^^
 
mansellan
mansellan
LocalDB + managed code...
 
Mathieu Guindon
Mathieu Guindon
you misspelled Azure
 
mansellan
mansellan
9:14 PM
googles Power Platforms
 
this
this
that's just PowerBI, PowerApps, and Flow
 
mansellan
mansellan
oh ok
meh
@MathieuGuindon ah yes... local is bad these days...
 
Mark Balhoff
Mark Balhoff
honestly I've used Access on a couple personal projects for a quick mockup before I had time to build it the way I wanted
 
this
this
IMPOV, nothing has come close to Access in the range of usability. Rewriting a software for new level is usually very expensive and a big point that many software companies, including Microsoft has the most difficulty comprehending.
Nobody wants to rewrite their overnight successful accidental-LOB application; they want to keep growing it.
 
Mark Balhoff
Mark Balhoff
@this Agreed. For small tasks, I end up staying in Access because it is minimal effort to get off the ground.
 
this
this
9:19 PM
I suspect the same can be said about VB6 applications, in spite of all..... quirks.
Would love to find out how many VB6 applications are still mission critical.
 
mansellan
mansellan
But that's the point, surely. Access is old, if MS want to stay relevant they need to pause on the new-shiny and consider what got them so many devs (official and unofficial) - shadow IT. Reinvent it for the 21 century. Without JS, please.
 
this
this
and break the backward compatibility?!?!
That can be a big issue for those who already has a 10 years-old application built.
(or more even).
Personally, I don't mind breaking some of backward compatibility but that is a big problem.
 
mansellan
mansellan
@this Honestly, yes. Put another layer in, allowing managed code. Even if it has to coexist for some years. COM was great, but it's had its time.
 
this
this
Microsoft is apparently schizo on that one.
 
Hosch250
Hosch250
@mansellan COM is still around.
Update a UI control from the wrong thread in WPF creates a COM exception.
 
this
this
9:23 PM
and enhanced recently ( for WindowRT and UWP, I think)
 
Hosch250
Hosch250
It's still there under the scenes of it all. Just buried better.
 
this
this
It depends on who you ask, really. One department in MS will say "down with COM!" Other will say "COM is fundamental!"
Hence, schizo.
 
Hosch250
Hosch250
COM is fundamental for some departments. They aren't going to rewrite Windows threading for a long time yet.
 
mansellan
mansellan
Oh, COM is not going anywhere soon. And Office is COM though-and-through. But it could do with a managed abstraction layer, for the newcomers. JS is the wrong call.
 
this
this
but JS runs anywhere!!!!
I MUST BE ABLE TO EDIT MY WERD DOX ON MY PHONE!!!!
 
mansellan
mansellan
9:30 PM
JS sucks anywhere - FTFY.
 
this
this
Lol
 
Mark Balhoff
Mark Balhoff
Yea COM is terrible but it's so embedded they can't get rid of it
 
mansellan
mansellan
@MarkBalhoff Agreed, but maybe they can hide it?
 
this
this
They already are. It's named.... drumrolls .NET
 
mansellan
mansellan
So.... Office.Net?
 
this
this
9:33 PM
they could have had went forward with VSTA, you know.....
VSTO was a big flop because they basically it not-Office.
 
mansellan
mansellan
Yeah, but implementation was lacking. WTF didn't they stream it into the doc file???
 
this
this
e.g. you had to install a huge runtime just to run your 3Kb VSTO add-in
 
mansellan
mansellan
Who wants to put files alongside...
 
this
this
^
hence, a big flop
 
mansellan
mansellan
bizarre, they already had a vitual filesystem in the office doc format. Just, why?
 
this
this
9:35 PM
security, I think.
 
mansellan
mansellan
eesh
 
this
this
they did not want to repeat the vulnerabilities and exploits with VBA macros.
 
mansellan
mansellan
and now they're ditching AppDomains... go figure.
Managed is much easier to sandbox, iiuc
tl;dr: if MS put a fraction of their current (laudable) tooling expertise into Office, they could nail it for a generation.
some of the stuff they're shipping atm is incredible
 
 
2 hours later…
IvenBach
IvenBach
11:34 PM
@Hosch250 SoCal resident has no need of such things. I only saw 3 believe in jeezus signs while driving through old people area aka desert.
 

« first day (1782 days earlier)      last day (1398 days later) »